Viewing 15 posts - 1 through 15 (of 58 total)
I think SSCommitted hit the nail on thehead. Life is not a piece of paper saying you know "stuff" butcan you...
September 7, 2018 at 8:53 am
Using Books On Line simply enter @@ in the "Look for:" line. You are just missing it. No big thing..
May 31, 2016 at 6:54 am
I have been evaluating FogLight from Dell for the past month and am very impressed with it. You might look into it.
October 14, 2015 at 6:57 am
You might find what you need by looking into the following roles:
November 26, 2013 at 7:16 am
Upgrades are not as bad as some would try to make you think. The key is doing your home work.
First I would use the UpGrade Advisor:
November 12, 2013 at 8:29 am
There are any number of solutions to this issue. Search for "comma delimited strings" in SQLServerCentral and you will get plenty of examples of functions that will do just...
October 7, 2013 at 9:43 am
If you are looking for a title then you might not want to become a DBA at all. I have been a DBA for 15 years and would not...
September 19, 2012 at 12:28 pm
Well it looks like this thread is going down a different path. To clean up your database you have a few options.
1. Create a new database and...
June 30, 2011 at 6:55 am
The content is sound and fairly well thought out. As stated by others the code is a mess with errors, typos, etc. I do not like the ideal...
October 20, 2009 at 8:59 am
Check this link: http://msdn2.microsoft.com/en-us/library/aa337272.aspx
September 20, 2007 at 6:36 am
One simple way is to build SP simular to the code below in which you would pass the desired db name and call that proc when needed. There are other...
September 17, 2007 at 11:56 am
The error is subtle to spot but it will cause you problems every time. The best way to trouble shoot these types of problems is to print the statement rather...
September 17, 2007 at 11:34 am
I would think that you should have () around each complete select statement.
August 23, 2007 at 10:51 am
The following code will work also and perhaps give you a different way of looking at things. The first part of the query just builds and populates the test table. ...
August 22, 2007 at 10:05 am
A windows group can not own a database. See sp_changedbowner in BOL. A possible work around would be to add the desired group to the DB as a user then...
August 21, 2007 at 6:01 am