Are you connected to right server / instance? Please verify.

Sorry missed the second part of question.

You should keep taking log backup at regular interval for Transaction Logs truncation. 30 minutes interval is fine.

You can take Log Backups on Primary Server.

How do you define cluster of rows in your table? If it’s the order of insertion then you are going on wrong track. The order of rows in table is...

Replication: http://msdn.microsoft.com/en-us/library/ms152567.aspx

OR

Distributed Transactions: http://msdn.microsoft.com/en-us/library/ms177403.aspx

You need to post the requested information here on forum. When you reply to post attach the requested files.

disable / drop windows login (in SQL Server)

same as...

If it’s an academic question then answer is Triggers.

Else DON’T do it. Why do you want to track IP addresses? The one who modified the objects is not sufficient to...

It’s safe if you didn’t crack any pants joke 😉

Gail has covered pretty much everything. Just highlighting few points on her post as caution (if you quick read)

•The trace rolls over after a file reaches 20MB or the server...

Please decide on database shrinking wisely.

Best Practices:

Consider the following information when you plan to shrink a database:

•A shrink operation is most effective after an operation that creates lots of unused...

IMO for 300 GB database autogrowth should be 1GB or more.

I guess you missed the part which I added later.

'As...

Good. So you (as a DBA) have control here. Keep checking in these scripts in Version Control tools as & when they arrive. Include this task in your DB Deployment...

ns22boss (12/14/2011)

For the first time when i run the query it is counting from 1 to n..

Next time when i run the console once again and execute the query, my...