Viewing 15 posts - 1 through 15 (of 17 total)
You're welcome Miguel. This won’t be the first (or last) time any of us find ourselves in this situation. The reason I knew about the delete level is from working...
February 13, 2012 at 10:28 am
You could also use the @delete_level parameter of sp_add_job.
0 = Never
1 = On success
2 = On failure
3 = Always
When using SSMS to create/modify the properties of a job this appears...
February 13, 2012 at 6:39 am
Be careful. The ROUTINE_DEFINITION returned by INFORMATION_SCHEMA.ROUTINES is nvarchar(4000). Using this view will miss references beyond that for procs/functions that are more than 4000 characters. The same goes for VIEW_DEFINITION....
February 9, 2011 at 7:19 am
James Lean (4/15/2010)
Agreed, I can set model to read-only on 2005 and 2008.Good question though, I was unaware these limitations existed.
Ditto. According to BOL the model database cannot be set...
April 15, 2010 at 6:00 am
Michael Kipp (6/25/2009)
June 25, 2009 at 6:02 am
Noel McKinney (6/5/2009)
June 5, 2009 at 6:03 am
I wasn't sure which way to go either between "national character varying" & "national varying character", but then I saw this in BOL so I chose the former.
(nvarchar data type):...
May 28, 2009 at 6:23 am
I was thrown off too. The documentation is inconsistent.
At first I found the capacity limitations page that indicates 50 instances on a stand-alone server for all SQL Server editions except...
May 18, 2009 at 6:37 am
Mohit (11/24/2008)
Old Password is required if a user was changing the password. If you were changing the password with SysAdmin account it doesn't care.
Yes I was using a sysadmin...
November 24, 2008 at 8:24 am
I tried this out on Windows 2003 to see how it reacts (Windows 2003 SP2; SQL Server 2005 Standard SP2 64-bit).
Using the SSMS GUI, the following commands are issued.
[font="Courier New"]--...
November 24, 2008 at 7:27 am
Ditto the above concerning sp_describe_cursor_columns. Can the question's author please give an example of how the number of rows returned by a cursor can be obtained by calling sp_describe_cursor_columns? If...
June 18, 2008 at 7:08 am
Wikipedia (http://en.wikipedia.org/wiki/Yottabyte) would have you believe that all four answers are correct, using base 2 or 10.
The quoted reference in the answer (http://en.linuxreviews.org/Yottabyte) would have you believe that only two...
April 4, 2008 at 11:19 am
yussuf.khan (2/11/2008)
February 11, 2008 at 6:29 am
I'm wondering the same thing as Gordon. As is often the case, it seems that there are multiple ways of accomplishing the goal.
Quote from SQL Server 2005 Books Online:
Connection...
January 28, 2008 at 6:19 am
In addition to the problems listed above, Answer 1 also returns "yes" for an empty string.
Why is Answer 3 incorrect?
June 2, 2005 at 8:18 am
Viewing 15 posts - 1 through 15 (of 17 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy