Viewing 15 posts - 1 through 15 (of 39 total)
This may be helpful - http://synsol.eu/blog/2011/03/sql-clustered-instances-automatic-max-server-memory-settings/
October 19, 2011 at 5:47 pm
SQL Server 2005 uses the dynamic port when a named instance is installed. You can change your port to the static port from Configuration Manager.
October 19, 2011 at 3:11 pm
Use function ISNULL ( check_expression , replacement_value ) in your query and replace your NULLs with a blank.
October 19, 2011 at 3:07 pm
Yes, you can do it by selecting from the Possible Owners list. You can do this from Cluster Admin.
October 19, 2011 at 2:55 pm
Is the file there in the location showing in the error logs.
Try to detach and reattach providing the new path.
October 19, 2011 at 2:50 pm
Why not do a replace in the excel sheet itself. Replace all your NULLs with a blank.
October 19, 2011 at 2:40 pm
Yup, it's usually a task of the system admin or SANadmin to present the LUNs or the mount points but if you know ver well how to do it and...
October 19, 2011 at 2:37 pm
Yes, run SSMS as the administrator which would have the permissions on the registry.
October 19, 2011 at 2:34 pm
You might be running the trace on the already busy server due to which the trace is contributing in locking the queries that are running on the server.
October 19, 2011 at 2:28 pm
I think you are not recycling the SQL Service. Any change in protocols require you to restart the services.
Also, if you disable all the protocols, you won't even be able...
October 19, 2011 at 2:24 pm
I suspect you are connecting to the right instance that you have installed AdventureWorks DB on? Did the executable gave any errors while installing
October 19, 2011 at 2:16 pm
Can you explain what you are trying to do here? Where are you using the data source (Which variable or connection manager)
October 19, 2011 at 2:12 pm
You can use a light-weight trace capture. Don't capture all the events/columns but only the important ones.
October 17, 2011 at 12:56 pm
Don't think that SSMS2005 & 2008R2 on the same box should matter. But have you tried the same thing with SSMS2005.
Just want to see if it is an issue with...
October 17, 2011 at 12:53 pm
Look at the perfmon counters for SQLServer:Databases -
Data File(s) Size(KB)
Log File(s) Size(KB)
This would show you the growth of your data/log files.
October 14, 2011 at 12:45 pm
Viewing 15 posts - 1 through 15 (of 39 total)