How about

exec sp_pkeys tablename

In 7.0 Enterprise Manager, the red squiggly line indicates that you are connected to the server.  Right click on one and select "disconnect" and the red squiggly will go away.

Are you running SQL 2000 or 7.0?  If 7.0, do you have "truncate log on checkpoint" on or off?  If 2000, is your recovery model full or simple (or bulk logged)?  It...

Here's one that I wrote...

By the way, this will only work for SQL 2000, it will need minor modifications for 7.0

-- af_revLoginAttrib_2k

-- Verify existence of af_revLoginAttrib_2k procedure.  If it does...

DROP CONSTRAINT isn't a free standing SQL statement. It is part of the ALTER statement.

ALTER tablename

DROP CONSTRAINT constraintname

Lee,

syslogins is not a table, its a view, which is probably why you couldn't find it in EM.

can you use conditional logic to determine which machine your on?

if computername = 'dev'

put it here

else if computername = 'qa'

put it here

else

put it here

you...

Well, I gotta say it feels good to have finally gotten my 1st STAR and promotion to ACTIVE POSTER as of my last post!!! 🙂

xp_fixeddrives will list all the drives on the SQL Server along with the free space on that drive.

All you'd need is a means to execute it against all your machines...

Also, you can increase the quantity of log files retained by right clicking on "SQL Server Logs" in Enterprise Manager, click on "Configure...", click the check box and modify the...

I gotta agree with Michael.

I tried it, also running 2K, SP3a, Personal, and got the results that he described. The key is to have a comment above the create...

From Books Online:

Note If a relative path name is entered for a backup to disk, the backup file is placed in the default backup directory. This directory is set...

As Mike said, you won't need to reinstall, just change the licensing.

Furthermore, if you have restricted your connections to 5, you'll want to increase them now. BUT, in your...

This won't help if the pc disconnects, but you could write a stored proc to clear the entries, and set it up as a start up proc. This would...

Cortec,

Have you tried restoring one of your "successful" backups to ensure that it is indeed a good backup?

I have had "successful" backups that I was unable to restore in the...