HI Guyz, Thanks for your post, i had an idea that if i would move the tempdb data and log files, and start the SQL server Agent then this would get...
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...
Hello, I hope this URl http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm helps you with your clarification on your new SSRS...
Hello Mahmoud, Thanks for modifying it, really appreciate it. But still pondering over my first question.... Can we somehow stop disabling and...
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...
Hey Guys, I used these queries sometime back, to check the cpu waits and memory waits on production machines. Select...
HI Satya, Are we talking about the different reports that are available to monitor Server and database statistics under the summary tab. If yes then...
HI, Thanks for the above query. But on my production machine I frequently get processes that time CPU cycles in thousands, my question for you is...
Hello, If i simply execute DBCC LOGINFO then it lists a lot of files with same file id, better if someone could explain what these rows indicate....
HI Satya, Appreciate your help. It would be great if someone who knows to work with power shell post how to move jobs from one server to another,...
Hello All, I am using Mixed mode authentication and the server belongs to a particular domain. Thanks, Mani
Hi Rohit, Thanks for your response, I am aware of this process but can we do something to autmate this. Automatically dumping the Scripts into a...
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...
HI, Well if thats the case, then none of the Reporting database created on that server should be compatible with my reporting server. However i...
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...
Hi John, Appologies for delay in response, previously we had all the system database along with user database but now we have got a separate drive...
Hey Thanks for the post, but i found the fix. After we give alter database command, we need to stop the services and then move those files(MDF's or...
Hello John, My question is simple here, I have a cursor that loops through a particular table (table A), takes the primary key value from each row...
Appologies for any typos, this is the command i executed alter database DBnamemodify file(name=Data_file,filename='newpathOS_filename')
Separate names with a comma.
