I agree with bkelly on suggestion number 1- writing a VBScript. This is how we generate static web pages (ultimately by calling a function that was residing on an...

If you don't mind being evil (like me), just set a limit on the size you want the logfile to grow to. It sounds like it wouldn't be too...

While it's unlikely to have changed, check the server registration properties in enterprise manager to make sure "Show system database and system objects" is checked.

Also check the registration properties to...

I think it's interesting that in SQL Server 6.5 you have the ability restore specific tables only, if you wish. I'm not going to say anything positive about SQL...

An excellent idea, I use this for backups of all OLTP systems in my company. I have one idea, an add-on you may want to add to your package....

I'd first check the file growth like npeeters and antares686 mentioned. It's also possible your performance problems stem from index page splitting. Is it possible for you to...

If you can ping, and you get an error indicating "Not associated with a trusted connection" it seems like you have network connectivity. Can you connect using an SQL...

As a dba with very little programming experience I've used sql-dmo in the past in a vb6 app doing the simple task of comparing and promoting tables and stored procedures...

Touch Type, 60-80 WPM. 80 if you count backspace =)

Interesting.. I have a few general comments on object naming. I use a very similar naming convention for my backup files, which helps tremendously when faced with restoring...

you might be a dba if you..

... handle problematic users by putting a trigger on sysprocesses, killing any connection that user tries to make

... you wish Bank of America would let you download your (personal) statements in XML.

Another comment. If you DON'T have terminal services set up, and you don't feel like installing a free third party (security hole) application on your server, simply use xp_cmdshell...

Regarding the problem with the security profiles... When you restore the backup you have the sysusers table still, I create a script to reassociate logins based on the values...

Though it's never been an issue for me, I tried this on a test server that I just butcher with restoring, dropping, and attaching various databases. I have one...