Lynn Pettis (1/9/2009)

What I am saying, is I won't ignore the solid technical advice of an individual based on his appearance, where as you basically have said that you would....

That's a great question, but I don't think many of them can be reset. They all come from counters stored in virtual tables in SQL Server and most of those...

you are welcome and glad you learned a few things. I know I did.

Correct, it says nothing about using SSMS, but you're saying that you can't move them in SSMS? It doesn't say anything about moving databases. It asks which ones can you...

Moving to a 2005 forum.

You can run a trace all the time, I'd schedule or set up a server side trace, not with profiler to reduce the load. however...

Definitely watch out for the GUID as John mentioned unless you're adding them sequentially.There's a way to do that in 2005. In 2000, use a date column, but try to...

For the record, I didn't pick the shirt in the image. Well I did pick to wear it, but I didn't pick it for the image. The artist at Red...

Need more info, what is the linked server (type of system), what query is being run, etc.

I saw some issues going against DB2 before where there was a limit in...

Words aren't necessarily bad and plenty of people prefer using those to autonumbers since they might better represent a real key. An identity is a surrogate key.

If you want to...

Backup your databases in a test environment and run it there. you should have a test environment. If you don't, install a VM system and create a test environment.

The idea...

Sure, enable full mode, run log backups, note size.

There's no downside to doing this. Change it during the day, set up backups every 15 minutes and keep track of the...

Run Profiler and trace the username trying to connect.

Are you sure the user is connecting with Windows auth? Can you connect from that workstation with your credentials?

I'm not sure if this works without being sysadmin. You might be able to kludge it, but after all that, why not just give sysadmin? This should only be on...

The rollback will occur if you trap an error, but you'd need to check for an error after every statement to ensure it gets handled.

If you post the error, we...

George, they should be placed according to some standard when you install, but two issues. One is people not familiar with SQL, or perhaps with your standard (or as part...