Lowell (11/30/2010)

sweet ! i was hoping to fiddle with that old thing after...

Lowell, I tweaked that a bit for my situation, and it worked quite nicely ... Thanks !

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

I use this to script all the objects to files. As I recall, the .exe is not in 2005, so I copied it, and maybe a couple others from my...

A bit impatient ? (You could have done it manually by now)

Create a Windows secirity group through AD, then put the user(s) in that group, then give that group...

GilaMonster (11/21/2010)

To anyone still reading (and not running screaming), do not ever do that. The log is not an optional piece of the database, SQL cannot always recreate it if...

When I have a job that I want disabled for...

Here's a query that you can run to check on when each database was last backed up and the recovery model.

I used this when I started at a new job...

Can it be varchar instead of char ?

Look at how much space the table is currently using to get an idea of the impact.

Are the database and log files on...

Replication is a good option. Another option is use a linked server

truncate table ServerB.DatabaseB..TableB

insert into ServerB.DatabaseB..TableB

select * from DatabaseA..tableA

Why is SSIS not recommended at your company ?

One fallback position could be to take backups when they are still on the 2000 server, just before restoring to 2005. I assume you will do this anyway. In an...

It's possible the indexes you want to delete are hard-coded as index hints. I use something like this to look for character strings in stored procedures

exec sp_MSforeachdb_db 'use [?] select...

Not sure if this applies in this case, but I found this script somewhere ... (probably SSC) and have used it to see how far along a backup or restore...

I splice frequent t-log backups into my defragmentation routines to prevent large .trn file growth.

And try to be a...