Hi Sandhya,

You would be able to see the service account details from the "Services.msc" tool. You can reach their by either

>> Typing services.msc from run command

>> Control panel-> Administrativetools->Services

All the...

Hi Steve,

I have tried restoing a test database from a network backup and still it works. It gives the phisical_device_name as network backup location \\servername\backupshare\backupfilename.

Please correct me if I misunderstood...

Nice Query Jeffery, its very useful. Thank you [:)]

Hi,

You will get the complete syntax of various types of backup and restores from SQL BOL (books Online).

However find the below basic syntax for full backup and restore of...

Hi,

I error could be because of TCP/IP protocol being disabled for the server.

Use the SQL Server Configuration Manager on the server and enable the SQL Server 2005 Network Configuration...

Hi,

you have to first change the datatype of that column and then set the seed value as per your requirement.

ALTER TABLE 'table_name' ALTER COLUMN NMR_No identity (seed,increment)

Where seed is the...

Hi Ruchi,

The following stored procedure will help you in finding all the related views created on a given table.

Use ‘databasename’

sp_depends 'tablename'

This would provide the complete dependencies on the table(foreign key...

Hi,

I have come across the below link, check if this helps:

http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx

-Rajini

Thanks for the info. However the backupset table provides only the log backup information.

-Rajini

Hi,

I have come accross this script, please check if this helps. Download the script available at the below location

http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx

Then we can do the necessary changes and automate the...

From the error messages provided, seems like the server load was too high to create a worker thread. Please check the following and proceed accordingly.

>> Try to run the FULL...

Yeah I echo Ramesh..this has something to do with "QUOTED IDENTIFIER"

Check if the "QUOTED IDENTIFIER" is set to ON and then set it back to OFF

SET QUOTED_IDENTIFIER OFF

GO

-Rajini

As per an article, You will receive this error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server...

To my understanding, this has nothing to do with service pack. It is an property(setting) in SQL server and the usage is as follows:

SELECT "x" FROM Table

If QUOTED_IDENTIFIER is...

Every maintenance plan created will have a corresponding entry in the sysjobs tables in msdb database. Hence cross check if the enabled option is set to '1' using the following...