in my sql server i have 20 sql user accounts used for SA authentication.
Roles for 19 accounts are = public only. Remaining account is the default Sa account.
When i connect in with one of th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22985255.html
I want to create a stored procedure that accepts an endpoint name and deletes the specified endpoint. Which type should I use? nvarchar doesn't seem to work.
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2308...
hello ee! does anyone know how to link to another database on the same server? I have a table with stuff related to another table on another database and i want to show a query of all my records an...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2312...
I need to monitor the jobs that are running in a particular database
when I use sp_who2, I only see the job or sql's that I am running locally from MS SQL Server studio
Also when I use select *...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2313...
I need to load data from table 1 to table 2, the tables have an identity column
How do I run an sql to move data from t1 to t2,
The sql below gives me an error. I am using SQL Server 2005
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2318...
Hi
I'll simplify my problem , i have table with columm "Issue_dt" smaldatetime
selct * from mytable
the result appear like the following
Issue_dt
-----------
2008-06-15 00:00:00
2008-06-12 ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2348...
Hi
when i perform the follwoing sql statment
select convert(nvarchar(10) ,issue_dt ,103) from MyTable
i got the result as following
--------------
15/06/2008
12/06/2008
12/06/...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2348...
How to change the loginname of user DBO in SQL server 2005? Can This be done?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2361...
how to get table 2 from table 1
table 1
case# Opendate CloseDate
11 01/01/2007 08/09/2007
22 03/15/2007 05/01/2007
33 04/28/2007 ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2373...
I have a subform that uses the following SQL code in Access
SELECT IVR_write.variable_name, IVR_write.value, Descriptions.description
FROM IVR_write LEFT JOIN Descriptions ON (IVR_Write.type & ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21702134.html
