Thanks Steve.

I have  dbcc inputbuffer and fn_get_sql () on the brain!

 I meant dbcc indexdefrag

Check out these links.

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

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

No trouble doing it this way. Remember to check for orphaned users.

This should help

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q224/0/71.asp&NoWebContent=1

SQL Server 2000 sp3a on both machines.

I managed to get around this problem by renaming the database.

Cheers

SQL Server 2000 sp3a on both machines.

I managed to get around this problem by renaming the database.

Cheers

Hi if you are doing a full backup of the database every night then yes it backups all objects eg stored procs,views users,tables etc and data.

Hi if you are doing a full backup of the database every night then yes it backups all objects eg stored procs,views users,tables etc and data.

Hi Jonathan  I have read that setting minimum memory may improve performance on an a dedicated system or is this not the case?

Thanks

When I script out the table it does

all the fields except the ones that cannont be viewed in em?

Found a work around. Copied table to another server then...

Does the transaction per second refer to kb or number of transactions?

If it's number then what counter do use to see the size in kb?

What is the backup device?

Howdy

To monitor disk space

Using a host watch to monitor disk space. Alerts are sent to email and sms sent a group of mobiles if free space goes below a...

This was tip a given to me a little while ago. Try changing the category id of the database to 0 sysdatabases in the master database.

Try xp_msver to get information about the server. This however will not tell how much ram is currently being used.

Howdy I had a similar problem when doing log shipping to my standby servers.

I have just finsihed writing this script and thought you might be interested.

Remember please test before...