You can change the path for master in the startup for the service. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters

Then you could start up, and then detach the others and attach them at the new...

How far is the new center? I'd really look at snail mailing or driving the full over, maybe then a diff from day 2 and go with logs to catch...

What kind of files? This is best done with other compare methods, not SQL.

Also, please post in the appropriate forum. It's been moved to the TSQL forum.

While I remember my own phone number, it's surprising how many others I don't know. Most of my friends are in the phone and I have no idea of what...

I'd use two different versions of the script, one for each SQL Server version, especially as the 2000 one might not work in 2008. Just return the same values so...

http://www.sqlservercentral.com/articles/Integration+Services/61619/

We don't have that, but we do have "Recent Post" above and "Active Threads" that show you what's changed since your last visit. With that you could log on, then...

William, not right now, but I'm considering turning the forum search back on.

If you pick the Active Threads on the left, that will get posts since your last visit. I usually scan for those with 0 or 1 response.

You can also pick...

Chris,

I can do that. We're in the midst of sorting the feeds out, so I've been waiting for that to change before I move things around, but I can easily...

OK, bring the ice back, clear, preferably Vodka ice and not black ice, and we'll trade!

Barely got out the driveway, so my prayers for the day were answered by 4L

PK doesn't do either. It doesn't help with speed or with inegrity. It tells you which column identifies data. You can set your unique index column to be the PK...

Do both people share the same employeeID? If so, then something's wrong. If not, then the WHERE clause is filtering it out.

The left join returns something like this:

1 ...

It sounds like corruption or perhaps a problem with the syscomments table.

My guess is DF_Serial_HQID" is a default on the table. If you check the table in SSMS, look for...

That could be it and if so, that's definitely a bug.

I'll try to check. I'm here so often, I've never paid attention.

Thanks for the visits, though 🙂