Hey guyz, We are planning to move tempdb to a new drive due to poor perfromance with the current location We cannot afford any downtime what so...
HI Guys, The other day was working with setting up ddl trigger, and landed up in some problem with it. I want to block every one from deleting or...
Hello all, Can some one let me know if there is a way to automate the following task. 1.Script as all the jobs to a particular file. 2.Then execute...
Hello All, Till yesterday my reporting site was wrokign fine, but dont know what went wrong now. None of the reports on my reporting server renders...
Hello All, Normally to manage permissions on production servers, we add Security groups (SG'S) and later ask users to join these Security Groups. In...
I executed the following command, to change the Data & Log File locationalter database DBnamemodify...
Hello all, I have a generic question on Cursors. I have declared a cursor (Cur1) on my local machine (Say ServerA) and inside that cursor i exec a...
Separate names with a comma.
