use

master

go

GRANT

VIEW ANY DEFINITION TO user_login;

go

USE master;GOEXEC sp_who 'active';GO

If the process found this way should not run then kill it and detach the db, otherwise wait until the process is finished; there is also an...

SQL does not allow more than one clustered index per table; a clustered index defines the physical sorting order of your data in the table. However, a clustered index can...

It sounds strange, most probably there's not any trick for getting the script run for once (BOL - Drop table topic)

I would say to write your code like: BEGIN TRAN ALTER TABLE...DROP...

I'm affraid the location cannot be changed, the files have to stay in the Data folder where your SQL installation is. What you can do is to implement an archiving...

Severity 19 errors are very rare, I would say this sounds as a MS bug. Which sql 2k sp are you running? However, this issue needs further investigation: where did...

Create a (sql agent) job where to add your backup code as a job step, then schedule the job; forget about maintenance plan if you want to run your own...

Firstly the Administrator login doesn't need to be a sysadmin login.

The job should be owned by 'Administrator';

The user database you have created the sp in should have TRUSTWORTHY set...

Unfortunately this cannot be done.

This is done usually in a separate database where you run exclusively administration tasks, lets name it DBAdmin; you create a table in this db that will contain all your...

A way of breaking down buffers by objects (table, indexes) in the buffer cache:

select b.database_id, db=db_name(b.database_id),

  p.object_id,

  object_name(p.object_id) as objname,

  p.index_id,

  buffer_count=count(*)

from sys.allocation_units a,

  sys.dm_os_buffer_descriptors b,

  sys.partitions p

where a.allocation_unit_id = b.allocation_unit_id

and a.container_id = p.hobt_id

and b.database_id = db_id()

and left(object_name(p.object_id),3)!='sys'

group...

Assuming that the account you're connected to the sql instance has got write permissions, things to check:

- does your log file have enough space to grow?

- does your trigger have...

You would have to enable trace flag 1222 for deadlock trace output (see output in sql logs) This trace flag has got improvements over the flag on sql2k; you can...

You're stopping them one by one. They are distinct in sql 2k5 because you may not use full-text search for example, or you may not need sql browser in which...

Thanks for that. I didn't have this problem but you may never know.