Hello Senthil,

Can you check this

SELECT select_list INTO table_variable

Thanks and have a nice day!!!

Hello John,

Can you elaborate your scenario?

Ok do the following steps:

1. Check with which account both SQL Server and Agent have been started.

2. If Windows domain account, then check whether the shared folder has the full control...

Hello Nali,

Are you using Windows NT user or SQL User login?

Does the user login has required access to the shared folder?

Please go through the "Remarks" section of xp_cmdshell in Books Online.

Thanks...

Hello Donna,

If you are using SQL 2000, then Books Online is the best resource to find information. Type "Linked Servers" and "Truncate Table" as search criteria.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ta-tz_2hk5.asp

Thanks and have...

Hello Ram,

Are you accessing any shared folder with the xp_cmdshell command?

If so, please check up whether the proxy account which you are using has the necessary permissions to read/write to...

Hello Daryl,

Please go through this link as Microsoft is conveying that it has highly unwanted side-effects. These include the potential to damage the buffer pool.

http://msdn2.microsoft.com/en-us/library/ms178015.aspx

Thanks and have a nice...

Hello Henrique,

I'm not sure whether it works fine or not, but you can try it once.

In the DTS designer, you can place an ActiveX Script as the first step to...

Hello Homero,

Can you give more details?

From your message, I think that you have taken a backup of a database "abc" through Enterprise Manager.

When you try to restore the backup, are...

Hello Martini,

Please go through this link and you will find the steps to install the sample database after SQL 2005 setup.

http://msdn2.microsoft.com/en-us/library/ms143739.aspx

Thanks and have a nice day!!!

Hello Raj,

What is the version of SQL Server?

When you run DBCC MemUsage, you will get 5 columns with respect to SQL 2000. Check the database name and object name by...

Hello Faiyaaz,

Please check the service ownership. I would suggest you to check the services of MSSQLServer and SQLAgent. May be they might have been started with the LOCAL System Account.

Thanks and have...

Hello Gofrin,

Can you check out this query

select coduser, codcar, stdate, (sum([to])- sum([from]))/60.0 as totalhrs

from <ur table name>

group by coduser, codcar, stdate

Thanks and have a nice day!!!

Hello Joshi,

For named instance, you need to add the server in Client Network Utility.

Go to Start ->Programs->Microsoft SQL Server->Client Network Utility

In the Alias tab, click on Add button and give...

Hello Joshi,

First ping the SQL Server from your machine.

Next, check whether the username and password you have used to register the Server in Enterprise Manager are one and the same...