Thanks a lot.

Rgds

Mohan Kumar VS

Thanks for your response. I've idenfied the same.

Can you please let me know if there is any script to change Non-clustered index to Clustered Index?

Right...

Hi

The details are as below for a table :

ReservedSpace: 10776 KB

DataSpace : 8640 KB

CombinedIndex Space: 1488 KB

UnusedSpace : 648 KB

When I executed DBCC SHOWCONTIG ('TableName'),...

Swati

Windows Authentication requires that SQL Server services must run as domain users in trusted domains or as network services.

To authenticate both ends of a connection, Windows Authentication uses the credentials...

Swati

You can try this:

SELECT CustomerID, CompanyName

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'\\servername\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb'; -- change the path here

'admin';'',Customers)

GO

Rgds

Mohan...

Tara

Hope this will be helpful....

-- Create Tmp Table

create table #tmp1 (firstname varchar(100))

-- Insert records

insert into #tmp1 values ('BugdetRev120909_PA')

insert into #tmp1 values ('SirsregionRev_CA')

insert into #tmp1 values ('BugdetRev120909_PAxxx')

insert into #tmp1 values...

Vandana

You can use sys.dm_tran_locks dynamic view to get information about currently active lock manager resources.

Rgds

Mohan Kumar VS

Vandana

Regarding:

The table should have row-locking enabled to ensure that one user cannot delete a row that someone else is working on .

You can use SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

...

backup database [dbaScripts] to disk=N'C:\backup\dbaScripts_1.bak',

disk=N'd:\backup\dbaScripts_2.bak' with stats=10;

Rgds

Mohan Kumar VS

Thanks.