Viewing 15 posts - 121 through 135 (of 149 total)
Here's the code...
And yes I know I can create an SSIS package to do this. I just want to be able to script it so I may, in the future,...
April 28, 2008 at 3:19 pm
I tried as you suggested...
DECLARE @DBNAME varchar(50)
DECLARE @MyCommand varchar(1000)
SET @DBNAME = '_RESTORERECOVER'
PRINT @DBNAME
SET @MyCommand = 'USE [' + @DBNAME + ']'
EXECUTE(@MyCommand)
But the DB never switched to the _RESTORERECOVER DB.
I ran...
April 28, 2008 at 12:21 pm
Thanks everyone for the replies. I simply wrote a vbscript that prompted for credentials (not safe but for testing it works) to connect via SQL Native Client to my servers...
April 7, 2008 at 1:04 pm
Move all your clustered resources in "Cluster Administrator" to the node you need to install it on and try it again.
February 4, 2008 at 1:47 pm
Most importantly "Normalize" your DB when you are done. There will be a lot of redundant data as you merge your DB's.
January 3, 2008 at 5:31 pm
Post your script. Is it a vbscript, TSQL, pearl, POSIX.....?
January 3, 2008 at 4:03 pm
Have you ever just moved only th SQL resources in cluser admin? When I did this, the DTC service failed to start on the second node.
December 19, 2007 at 2:22 pm
No worries. We ran into a problem with the first collation change at the column level. We had to remove it and put it back because other PK/FK and Constraints...
December 18, 2007 at 1:15 pm
Did tou make colation change at the SQL Server level, DB level, Table level or Column? I would like to know because we made the change at the Column level...
December 18, 2007 at 9:41 am
If it's "deprecated" why the hell is there then? Why doesn't SQL allow case sensitivity to a column? Oracle does! Why can't SQL allow this feature with the default language...
December 17, 2007 at 9:36 am
I just re-read your original post. If your middleware folks say you do not need to pay for CAL's and you already purchased the SQL license, then you are fine....
December 14, 2007 at 12:14 pm
CAL's are typically licenses required for connecting to a shared resource like a shared directory on your server like "\\yourserver\movies" and "\\yourserver\userdata" or shared printers. When it comes to SQL...
December 14, 2007 at 12:08 pm
If the middleware app requires a SQL backend then did you install SQL? If you did install SQL then SQL has to be Licensed.
Or did the middleware app install an...
December 14, 2007 at 11:46 am
OK, I am in the Colation screen and I selected "Windows Collation", selected "Dictionary Sort" and checked "Case Sensitive".
Now what Collation Country/Language do I select in the drop down list...
December 14, 2007 at 11:40 am
For SQL Server licensing it is licensed by CPU "SOCKET". If you have 2 physical CPU sockets you have to purchase two licenses. They currently do not count the cores,...
December 14, 2007 at 11:10 am
Viewing 15 posts - 121 through 135 (of 149 total)