Hi Michelle,

This is really very helpful .Shared with my team members.

Thanx for ur efforts and keep posting ur best.

from

Killer

Hi Veeresh,

U really added important thing.

hope this help  the guy.

from

Killer

hi Sheckster,

Nice one.

from

Killer

Hi Asif,

Read this

http://support.microsoft.com/default.aspx?scid=kb;en-us;317748

this will help u

from

Killer

Hi Asif,

Why are u using ODBC Connection to connect Client to server.

Give the server name and connect it will connect if ur RPC is on

Hope thus helps

from

Killer

Hi ,

Have u run RESTORE VERIFYONLY on the database file to verify integrity.

See BOL for correct syntex.

Hope this helps.

From

Killer

An apple a Day keeps error away.

Hi Carl,

As u had written that rollback takes more than 14 hours it seems that u have millions of records.

u can issue the truncate command to drop the table with...

Hi,

If today is ur first day as a DBA .

Start like this:

(i) Database name and Service pack.

(ii) No of Databases and mode of Recovery.

(iii) No of Tables, Views and Indexes.

(iv)Available...

Hi Suneel,

This will help u more

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/CL_SecDBSe.asp

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

U can read more in  BOL just type Auditing

Page heading "Auditing SQL Server Activity"

I learnt about Auditing from this site

http://www.databasejournal.com/features/mssql/article.php/3399241

Hope this will...

Hi Ray,

Is it right to run DBCC Shrinkfile when we have tlog backup running.

do Microsoft support this.

AFAIK when we  go for ful backup sql server shrink the logfile and the same...

Hi Eric,

Ok, An overview in sql server we create many user and defines privilages to that user but who should have sysdmin rights and who should not have sysadmin rights.

this...

Hi Sathish,

If u had executed the command mentioned by u shrinks the log file means free the space (old data in the tlog)

but ur problem is that u want to...

Hi Deni,

Ur help is really appreciating.I shared it with my team.

But there are others who are more intrested in increasing the post then to help.

from

Killer

Hi Suneel,

This will help u

http://support.microsoft.com/kb/891719

HTHP

From

Killer

Learning manners.

Hi,

If u want to get deep see this artical.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

from

Killer

Learning Manners.