Viewing 15 posts - 42,931 through 42,945 (of 49,566 total)
It doesn't add builtin\administrators. It adds windows accounts that you specify to SQL server and makes them sysadmin. There's no good reason not to run it.
If your server is set...
November 26, 2008 at 1:54 pm
Adam Bean (11/26/2008)
Why oh why is this not working!
I'll be blunt. That form of query does not and can not perform well. Regardless of indexes, order of bits in the...
November 26, 2008 at 1:48 pm
I also took very few photos. I checked my camera this afternoon and realised that I took just 1 photo during the 3 main days. 🙁
November 26, 2008 at 1:36 pm
nate (11/26/2008)
Gail, the quick response is much appreciated. Also, nice presentation at PASS 2008.
Oh, thanks.
The primary key is actually non-clustered, and I'm trying to delete a clustered...
November 26, 2008 at 1:26 pm
Benjamin Lotter (11/26/2008)
By default, when you install SQL, it adds the group "BUILTIN\Administrators" to the SQL Server with the sysadmin server role.
Not on Vista or Server 2008. On those...
November 26, 2008 at 1:23 pm
The primary key is enforced by an index and, I'd guess from your description that the primary key is the clustered index (use sp_helpindex to check). You can't drop the...
November 26, 2008 at 1:16 pm
Trace does show before execution. That's what the StmtStarting and SPStarting events are. The StmtCompleted and SPCompleted are the events that fire after execution. It's not going to let you...
November 26, 2008 at 1:07 pm
Thread continues here: http://www.sqlservercentral.com/Forums/FindPost609378.aspx
Marin: It's better to continue posting on a single thread than to start a new one. That way the people helping you can see when new posts...
November 26, 2008 at 12:43 pm
For the sample data that you've posted, what's the output that you want? What records do you want back?
November 26, 2008 at 12:32 pm
You can use profiler and catch the statement/sp starting events. Not sure if it's the right solution though.
What's the reason behind the question? What are you trying to do with...
November 26, 2008 at 12:31 pm
Garadin (11/26/2008)
November 26, 2008 at 12:27 pm
kotlas7 (11/26/2008)
But One thing still confusing me..In BOL, they mentioned tail backup is introduced in SQL Server 2005. But it also working in sql server 2000.
No, they don't...
November 26, 2008 at 12:17 pm
What does the query for the report look like? Can you do the calculation there?
November 26, 2008 at 12:07 pm
Ok, I've never actually tried running both. Isn't needed. If what you want is to take a log backup and switch the DB into recovery to prevent more changes before...
November 26, 2008 at 12:05 pm
No version of SQL 2008 will run on Windows 2000. Below are the supported OS's for 2008 Express
Windows XP SP2 Home, Professional, Tablet, Media Center
Windows Server 2003 Small Business Server...
November 26, 2008 at 11:17 am
Viewing 15 posts - 42,931 through 42,945 (of 49,566 total)