you run profiler, and pick the Stored procedure events. I see it in

SQL: Batchstarting

SP:starting

SQL:BatchCompleted.

I'd agree with Grant. I assumed (badly) that 30 windows would be multiple servers. If it's not, you might need to rethink the way that you develop code.

I have a list, and PASS has stuffed tickets in the badges for people that used SSC3D before Tuesday (or paid me).

The rest of you will get handled. I'll get...

Great points, GSquared. It's good to let people know that selling blood doesn't necessarily help others with their lives.

I was working on my boss at a startup, trying to get him to go for a 24 hour job. Working 3 days a week and then I was going...

tune the query to run faster.

now that is interesting. Is your cluster already set up in Windows?

I had always installed cluster or had to move an instance to a new server because of the hardware...

Nice job, Wayne, and I hope you get better soon.

The log shipping from your DR server (now your PRIMARY) is not automatic. The primary is the server that is sending logs to the other server. If you failover, that...

Everyone's welcome. Bring your $30 to the door.

It will be from 8-10pm, Monday November 2, 2009. Room 615-617

You won't see it in Profiler like that. You'd only see

sp_test 1, 4

for a stored procedure call in Profiler.

The issue is that you are calling your current server, the one you failed over to, the secondary. Once you failover, it's the primary. all log shipping starts from that...

Snow day is worse here. The kids are home, need to work around them. I've been trying to edit articles around a game of Life, one of Chess, and I've...

I'd lean towards replication myself.

If you log ship, you need a separate database on your central server for each database in your environment. Then you need another database that you...

I'm not sure about the issue, but for the service account. Use a domain user, normal user. They do not need to be a domain admin, or a local admin....