Viewing 15 posts - 4,996 through 5,010 (of 7,636 total)
Yes, these are called "Extended Properties" in SQL Server and you can read all about them in Books On-Line. I would suggest starting with the article "Using Extended Properties...
November 1, 2008 at 8:52 am
While I agree with everything that Jeff and Gail said, I wanted to add to a couple of these:
clive (10/31/2008)
What is the preferred option, if exists or if @@rowcount.
If @@ROWCOUNT...
November 1, 2008 at 8:29 am
If you mean, "as in the Show Dependencies task", you use the sys.sql_dependencies system catalog view.
However, neither is truly reliable.
October 31, 2008 at 3:02 pm
Great! Thanks for the feedback, Jerry.
October 31, 2008 at 1:29 pm
Jerry Hung (10/31/2008)
I just have a question, how do I switch back to dbo role? (I'm sysadmin on the server)
Well, if you EXECUTE AS is a statement, then you use...
October 31, 2008 at 12:32 pm
As Michael and Jeff have said, the SOP way (favored by the pragmatists) to store elapsed time is as an offset datetime from the Zero datetime value. If you...
October 31, 2008 at 9:57 am
Great article, Gail. I have always found this subject difficult: initially, to understand myself, and then later, to explain to customers. Now I can just point them to...
October 31, 2008 at 8:52 am
Unfortunately this is more common than you might think. I have met very few Exchange Administrators who actually had a good handle on what their spam & virus filters...
October 31, 2008 at 8:03 am
Check the Login's database mapping at the Server Level:
Expand the Server's Security folder (not the Database's)
, then expand the "Logins" folder
, then select and right-click the "SomeUser" login
,...
October 31, 2008 at 7:58 am
well, according to the error, the server logon that you are using, "SomeName" does not have sufficient access to the database to script it.
October 31, 2008 at 6:31 am
Oops, I missed the title. Now I see... 🙂
October 30, 2008 at 2:38 pm
Did this ever work in any edition or version of SQL Server? I don't recall that it did...
October 30, 2008 at 2:22 pm
Viewing 15 posts - 4,996 through 5,010 (of 7,636 total)