We were planning to implement Application Roles as a way of tightening up security in our .NET applications. We currently have a commonly known and...
I just came across this good explanation: http://groups.google.com/group/microsoft.public.sqlserver.server/msg/b86e343e513ab281?hl=en
-- <br />--' ************************************************************<br />--' Parameters:<br />--' Purpose: Like SP_WHO2 but sorts by...
I use these scripts every now & then to look at all my database backup's history at a glance and make sure everything's happening when it's supposed...
Perhaps the scheduled jobs that run the packages have the old owner. That's easy to change right on the Sched Job. An old owner on the DTS itself...
Also, make sure the job AND the Schedule are both enabled.
Even if you just right click & schedule a DTS, the scheduled job gets the same name as the DTS package, so they should match up unless someone...
My message at home is: Hi, we can't come to the phone right now. If you're calling to sell us something, we've already got one. Otherwise leave a...
Did you get anywhere with this ?? I need to replicate from our public website, back through the firewall to our local SQL server. I couldn't get...
I have a query (QUERY A) that runs in 6+ minutes, and generates an execution plan that doesn't use parallelism. Then, I used an optimization tool,...
Nope ..... I don't have any identity columns.
From what I've read, SQL2000 shouldn't lock tables during the initial snapshot for transactional replication, I even checked the option : "Do not...
Separate names with a comma.
