Viewing 15 posts - 616 through 630 (of 1,335 total)
You can also use alerts to notify you when the space usage exceeds your set limitations.
July 12, 2007 at 11:46 pm
You have to alter your connection settings properties in QA and no the database settings. Change your connection property then you will avoid these.
July 12, 2007 at 11:40 pm
If you are able to save your MP as a project then save it and deploy it across your other servers.
July 12, 2007 at 11:38 pm
You can query the sysprocess table with dbcc inputbuffer(spid) to find the procedure is running or not.
July 12, 2007 at 11:36 pm
try xp_cmdshell 'nslookup' this will give servername with domain state.
July 12, 2007 at 11:35 pm
Capacity Plan itself is an art. You have to decide disk and space usage in phases and also you have to decide where to place the data and log file.
July 12, 2007 at 11:29 pm
Make use of the script given below.
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=486
July 12, 2007 at 1:37 am
UMS error occurs because of a failure in CPU processor. As michael says there should be a OS patch available to recitfy this issue.
July 12, 2007 at 12:18 am
You can change the password for the Datasource even in the reports website instead of using the utility. the url for the same is http://reporservername/reports
July 12, 2007 at 12:02 am
Check the link below that might help.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=118712
July 11, 2007 at 11:49 pm
Remote servers were supported in SQL 2000 for backward compatability. They are not to be used. Always prefer linked servers to connect to other sql servers than remote servers. Remote...
July 11, 2007 at 11:46 pm
Forgot to say change the password of sa and keep it safe else you are going to land in trouble.
July 11, 2007 at 8:08 am
Is sa account used for reporting services. First change that create a user and limit privileges and use that for reporting services. Also with reporting services try to use shared...
July 11, 2007 at 8:08 am
Is named pipes protocol enabled in the server. I have referred to your point 3 but clarifying again is named pispes anabled in both client and server side as its...
July 11, 2007 at 7:15 am
Using Query Analyzer i dint test this may be let me check i tried with SSMS and got expected results.
July 11, 2007 at 7:09 am
Viewing 15 posts - 616 through 630 (of 1,335 total)