Viewing 15 posts - 32,101 through 32,115 (of 39,818 total)
Check the Windows error log for the reason it won't start. Likely it's security.
No tricks. works like other services. The Service account does need to be able to log into...
May 22, 2007 at 7:55 am
Here's some notes. A little dated, but they should work for 2000.
http://www.sqlservercentral.com/columnists/sjones/20010422115752_1.asp
http://www.sqlservercentral.com/columnists/sjones/20010422115754_1.asp
May 22, 2007 at 7:53 am
Especially check with Windows as mentioned above.
SQL should be fine, but watch performance as Michael mentioned. things change with multiple processors. Should work better, but watch it.
May 22, 2007 at 7:48 am
Also, search out "errorlog" on your system on all drives and be sure they're not getting put somewhere weird.
Are they also not appearing in EM?
May 22, 2007 at 7:46 am
The only kegs coming back to Denver are Guiness if I can get across the stream to Ireland. Other than that, I'll stick with my Corona from the border below...
May 22, 2007 at 7:09 am
Sam has defined it, but in SQL 2000, you had a database, say Sales, with a table, say MyTable. The owner of the table was usually dbo, but it could...
May 21, 2007 at 8:26 am
encryptbypassphrase() works, but a better method is to create keys and use those for encryption. That way you can assign rights to use the keys to users.
May 21, 2007 at 8:22 am
I had some issues if I used different extensions as well. Be sure you're patched beyond SP2 with the fixes, and check your paths. There are some strange things in...
May 21, 2007 at 8:21 am
As much as I like Joe's description, Brandie, I think you've got a good description there.
May 21, 2007 at 8:13 am
Can you post the code you're running? My guess is you're using c:\program files, which means there's a space there. You might need to use quotes around the string.
May 21, 2007 at 8:07 am
I don't think you have updatable subscribers with log shipping. That's with replication.
Both mirroring and log shipping work in similar fashions, by applying transactions to the secondary server. Mirroring allows...
May 21, 2007 at 8:06 am
Paul's posted here as well and his blog is here:http://blogs.msdn.com/sqlserverstorageengine/
I pinged him with this thread, so you may see a response here.
May 21, 2007 at 8:02 am
No hugs from Grant ![]()
I'm actually going to Cambridge for a Red Gate visit, and not sure I'll spend any time in London. Out...
May 21, 2007 at 7:50 am
I'm not sure of where you could get the DTS internals, but one thing that might help is to save as a "VB File" and then execute it in a...
May 21, 2007 at 7:47 am
You can set them to auto-close if you think they aren't being used and then if they get accessed, the log will reflect it opening. Don't do this for systems...
May 21, 2007 at 7:44 am
Viewing 15 posts - 32,101 through 32,115 (of 39,818 total)