Viewing 14 posts - 1 through 14 (of 14 total)
Youn need to grant your developer group membership of the SQLAgentOperatorRole to allow them to create jobs - unless they login to the server as the proxy that you have...
August 5, 2011 at 12:38 am
Have you checked the value of the "STATE" part of the error message from the SQL error log on Server 1? That might point you to the specifics...
June 9, 2011 at 1:05 am
PAE is required ins case to address memory above 4GB. Rebuilding as 64-bit Windows would remove this option.
With PAE enabled then you can make use of AWE...
June 9, 2011 at 12:49 am
Getting a basic install of SQL Server is still pretty much a no-brainer. This should still account for the small, low transaction volume databases (and a large number of...
June 9, 2011 at 12:40 am
Julie
Have you considered simply shutting down SQL Server and taking a full system level backup of the server and then restoring that to your new box? That would...
April 28, 2011 at 10:53 pm
As this is an operating system consideration, there is no direct way to get it through a T-SQL query, other than using xp_cmdshell or a CLR function.
I'd suggets writing a...
April 28, 2011 at 10:30 pm
In an ideal world - yes, having different accounts for each INSTANCE is a better approach. However we all live in the real world and there is often the...
April 28, 2011 at 10:24 pm
I assume you mean the transaction log file for your database? The critical component of this is to ensure that the disk that you want to move...
April 28, 2011 at 10:15 pm
Lucky
I suspect it is because you have granted the "View Definition" permission to your role rather than the "Select" permission.
"View Definition" allows the role members to see the T-SQL underneath...
August 8, 2010 at 11:15 pm
Daniel
As long as you and your developers understand what is happenning (which you seem to do) and that the child delete is ALWAYS the intended behaviour then the cascading deletes...
January 8, 2008 at 5:10 am
SQL Server (like all DBMS) works best when dealing with sets rather than row by row operations.
When you use the JOIN variations for this type of query, SQL Server can...
May 29, 2007 at 12:39 am
Bernard
SQL Server 2000 will perform the necessary changes to the 7.0 database when you detach and attach. However, as it is a new version of SQL Server, there are some...
November 18, 2004 at 11:55 pm
I am 100% for using the forum as a further discussion on the merits of the answers in the QOD.
However, if somebody cannot provide anything constructive to the debate then...
November 18, 2004 at 11:35 pm
ALTER TABLE adds columns or constraints to a table, or drops constraints from a table, but it does not allow columns to be removed.
To drop or change a column you...
August 3, 2004 at 5:47 pm
Viewing 14 posts - 1 through 14 (of 14 total)