In sys.objects the type is 'TR'

You would be able to pull a list of triggers that way.

Or you could query sys.triggers and get a list of the triggers and be...

I've been tempted to get a netbook but can't justify a netbook over a laptop when the prices I have seen are nearly the same.

Can you help me with the...

The user owns the schemas. You will need to transfer that or remove that user from owning the schemas.

http://msdn.microsoft.com/en-us/library/ms173423.aspx

You may want to verify that the account is not the...

what do you have in sysmessages for that error message?

The table scan occurs if the Engine determines that a table scan will be more efficient. If you have null values or empty strings in your column, they will...

With the server being virtual, the question may be pertinent to ask the business managers if they are referring specifically about the VM.

Can one clone a VM? Yes. ...

Punny

Nice review, thanks for the info Jeff.

You can run profiler, that will more or less create a trace that you can use for playback. As far as testing the app though - it wouldn't catch...

The only MLB park I have been to happens to be Coors Field. Rockies Pirates game about 5.5 yrs ago. That is a really nice ballpark with great...

Excel and Access with custom replication to your iphone?

At this point, it would be the archaic method of interviewing the users. Watch what they enter and verify the results. Repeat the process when testing the upgrade.

Alternative,...

Please post the table structure for the tables referenced in the proc.

Thanks for the feedback.

Grant Fritchey (12/18/2009)

---

I'm running the 2008 R2 Enterprise on a netbook in Win 7 with 1gb of RAM. It won't win any speed contests, but it functions, barely. Yes, you...