Viewing 15 posts - 6,136 through 6,150 (of 6,215 total)
Why you care about a recordset if you're using output parameters? You normally use them to avoid creating a recordset.
Andy
July 25, 2001 at 12:50 pm
A local sql account just will not work. Your options are either a domain account from the same domain housing your SQL box, or a SQL login from that same...
July 24, 2001 at 8:23 pm
Several days worth of disk backup if you can. That way if the tape backup job fails you still have it.
Andy
July 24, 2001 at 7:13 pm
Brian has a couple articles about clustering, one of them is here:
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
But its for SQL2K. I dont see a good SQL 7 reference either. We'll see if anyone...
July 23, 2001 at 9:51 pm
Hey,
Im not sure why the 2nd node would hang. A quorum disk is separate. No, you dont need to set up replication. Are you using SQL 7 or SQL 2000?
Andy
...
July 23, 2001 at 9:28 pm
Thats about it. You have to have a clustered key to make it work, along with a bunch of other rules.
I don't entirely agree with Leon's answer - indexed views...
July 23, 2001 at 9:25 pm
Not really. Probably the simplest is to script out the permissions from each db in Domain A, change the login to match whatever you will call it in Domain B,...
July 23, 2001 at 5:14 pm
Hi Paul,
Havent used the SQL 2000 Transcender but thought I'd throw my bit in anyway! I've never heard anyone complain about them, I just find them a bit pricey:-) I...
July 23, 2001 at 7:01 am
Chris,
We're using a very expensive 3rd party app that makes extensive use of server side cursors. When we had it running on a 4 way 550 with 1g of RAM...
July 22, 2001 at 5:26 pm
Chris,
I havent done any real testing, but I doubt your theory. We recently bumped our 8 way box from 4g to 8g, which changed from giving SQL about 2.7g to...
July 21, 2001 at 4:36 pm
Hi Grace,
I imagine you have an orphaned user - take a look at sp_changeuserslogin to see one way to fix it. Aliases are out dated - in 7.0 and higher...
July 21, 2001 at 4:32 pm
Please keep in mind that you have to look at everything before you decide - make sure you have found the cause and not the symptom! That said, I'd say...
July 20, 2001 at 2:59 pm
It's included with SQL. You can find the info in BOL or at this link on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_odbccmpt_6cv7.asp
Andy
July 20, 2001 at 2:48 pm
523 aint a lot for a production box. Buy more, its cheap! I dont have my tuning book here, but I think 2 is a bit on the low side...
July 19, 2001 at 8:53 pm
I think you know more than we do! I'll take another look at MSDN.
Andy
July 19, 2001 at 8:51 pm
Viewing 15 posts - 6,136 through 6,150 (of 6,215 total)