I think you mean "no one is disrespecting"

That's a good example of where mis-communications occur. It is important to try and learn from your mistakes when you're working in another...

Tony,

thanks and glad you like them. I'll try to keep them coming and hopefully pick interesting topics.

You could script out the indexes, save this. Then do a search and replace for the indexes, choosing the new filegroup as the new location.

Mixed mode means you can use either SQL or Windows authentication. It doesn't mean you are using one or the other.

If you are using SQL authentication, you can only base...

Very nice 🙂

:), actually I should see who 666 was!

Anytime. I am usually busy, so I don't worry about the stuff that isn't being queried. Who knows how many tables are old, never deleted, out of date, etc. Same...

I'm with Jeremy. I'm sure there's a good set based way to do this, but to just get it done, I'd rip through the table based on time and process...

It's not completely clear what results you are looking for and what the data means from your explanation. Please clarify with a simpler example using the fields you need and...

You can use Local System, but if you do need to access, the network, don't put the service account into the admin group. Instead create a regular user account, no...

Is there anything ever written to the SQL Server error log or the Windows Event Log?

It's strange to see this type of error. I have no idea why you'd be...

This one: http://www.sqlservercentral.com/articles/OpenDataSource/61552/

Mark,

Thanks and I understand the reasons, but it's still something that I never have come across in the SQL Server documentation. I wanted to point it out to be sure...

I'd probably use some type of replication to move data around, but I'm more comfortable with that. If you're comfortable with Perl or DTS, use that.

You need to track down...

If you have DB1, DB2, DB3, I'd recommend you create a view for each table.

In DB1, create view db2Employee as select * from db2.dbo.Employee.

Also, create view db3Employee as select *...