I don't think you can do this with Profiler. You can do it using Extended Events though.

In general, I'm always wary to shrink log files until I'm sure that I've got them under control so I know what size they really ought to be. You don't...

Finished my 3 mile contribution gotta go log it.

I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but I seldom wear long socks with...

Yes, it could be the connection, but then I'd expect that to affect the query on both sides.... although, maybe not. Maybe only on the hop. I'm not sure.

That is not one I've run into before. I'd check to see if there are differences between the databases. I'd focus on the collation and the ANSI connection settings. Something...

Gianluca Sartori (6/8/2011)

Grant Fritchey (6/8/2011)

Jim Murphy (6/8/2011)

I'm not much of a runner. Uh, at all. But with...

Jim Murphy (6/8/2011)

I'm not much of a runner. Uh, at all. But with all of this peer...

That's old style error handling. Try setting up a TRY/CATCH event.

Another vote for Red Gate SQL Doc. Excellent tool, should do what you need.

Disclosure: I work for Red Gate.

Don't forget to get out and Run with Steve[/url] today everyone.

Can you put error handling into the script so that it deals with the error and doesn't return it to SQL Agent?

You need to define blocking in this case. If you're doing reads, shared locks are taken, which will block any other process from performing updates (which includes deletes). That's independent...

Express does cover the fundamentals of the SQL Server relational engine very well. You can learn querying, basic maintenance, backups and restores, tuning, pretty much all you need. If you...

Instead of trying to build this yourself, I'd suggest you pick up one of the third party tools out there that are designed for doing exactly this. It'll make your...

The key to reducing I/O through an index, which Gail has detailed already, are designed explicitly to reduce I/O, is to build the right indexes. Simply putting indexes on the...