Start SQLSAC and select remote computer and enter the virtual sql server name.
Aah, no. You're talking about Active/Active clustering. You don't install SQL Server on a node, you install it on the clustered virtual server....
quote:Originally posted by shahab03 I read somewhere that a each virtual server can have only instance of sql server .. if thats the case then I...
Your other option is indeed dynamic, depedning on what object or how you list your modules: EXEC sp_foreachmodule "SELECT name, '?..' + name FROM...
Okay, howabout nesting the procedures : Create seperate procedures for each module (e.g. sp_module1, sp_module2, etc.) IF (query for existance of...
brad is almost correct, but he's talking about database mirroring and also SP1 is in CTP at the moment. Disk mirroring is a completely different...
Deferred name resolution means the object does not have to exist when the stored procedure is created, but it does have to exist before it is first...
quote:Originally posted by pirinoe I am not sure what you mean by stats of databases. How can I determine this? To design a solution you need...
You realise that this could create an email storm? No need to pay a third party if you're willing to get your hands dirty:...
Okay, for Windows 2003 SP1 Enterprise edition you can get to 32GB of memory so that's no limitation - you just need AWE enabled, what does task...
Ah, so SSMS is not generating this error - is someone trying to use compmgmt.msc?
I don't quite get your last post, but; When you open SSMS on a client workstation you should have no problem. When you connect to the cluster you...
AWE, PAE and /3GB are all 32-bit scenarios. Are you saying you have one 32-bit machine with trouble, and one 64-bit which works okay? If so, you...
This looks like a job for partitions! Create a partition function to segregate the data you want to archive from the data you want live. Then...
Can you connect with SSMS from a workstation?
I don't know, but the quote is, I believe, "He who laughs last, laughs hardest."
Sounds like the jobs being done backwards as usual! <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />First of all the...
You pass one exam for basic technology understanding, and a further two exams for either DBA or Developer qualifications.
Yes, I've passed 70-431, 70-444 and 70-447 (MCTS and MCITP: Database Administrator)
Specify what errors you are getting. Could be the locations don't exist on the new server.
Separate names with a comma.
