To me, it looks like you do not have anything that consumes the variables @status, etc.

I have not tested this to ensure the syntax is correct, but you need something...

There are lots of levels to defragmentation of SQL Server databases. All of them are important.

The first is index defragmentation. There are lots of threads about this, so...

Rajan has some good ideas, but I don't think the DBA should touch the Windows hotfix logs. These are the 'property' of the Windows infrastructure dudes, and they should...

Vishal,

You need to grant execute rights on xp_cmdshell to user Test.

Security practitioners think it is good there is separation of duties between the people administering a service and the people granting authority to use the service. Equally, they see...

I completly agree with Steve. My policy is never shrink a data or log file if you expect it to grow within the next 3 months. Even then,...

SSMS is SQL Server Management Studio. I have not noticed any changes in the way is works between 32-bit and 64-bit.

Is the user trying to use the SP_OA procedures a member of sysadmin? In SQL Server 2005 only members of sysadmin can use SP_OA procs. In SQL Server...

You should only give db_owner rights to users that can be trusted and need to have db_owner functionality to do their job.

If you have given db_owner authority to more people...

When SSMS starts, by default it will try to connect to the default instance on the local server. Does this happen for you?

If you want to have a list...

A named pipe connection requires far more traffic to transmit data than does TCP.

If you are running clients on a local LAN, in practice you will find very...

Apart from the datetime formatting capabilities of CONVERT, CAST and CONVERT do identical jobs.

Personally I prefer to use CAST in all situations except where I want to format datetime to...

Michael is right - you need to update the number of history rows stored for the job.

You also need to go into SQL Agent properties and increase the...

There is no way to influence security within SQL Server via GPOs (apart from password policy). This is true also in SQL Server 2008.

IMO it would be great if...

The OP asked why we can only have one clustered index per table.

A lot of people responded why this is the case for SQL Server. I posted about DB2...