Viewing 15 posts - 8,146 through 8,160 (of 9,241 total)
test the SP3 first on a test sql server to make sure it doesnt break anything!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 12:09 pm
river1 (3/24/2010)
I need to know where (in wich database) to create the login and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 12:06 pm
if you script this yourself just remember to disable or remove any foreign keys, triggers, etc first. Create the base schema (Tables) and load all the data then apply any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 11:51 am
Ratheesh.K.Nair (3/24/2010)
Hi Experts,Is it possible to take a table level backup?
TIA
Hi
if you want just data and structure then use the following for a quick and dirty
select * into newtable from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 11:44 am
if you run the root SETUP.exe it will detect your architecture and launch the appropriate installer. You can also see the architecture by clicking options on the left menu in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 11:37 am
is this a windows 2003 or windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2010 at 3:06 pm
Jeff Moden (3/22/2010)
It's a real shame that we have to try to rewrite that which works so well...[font="Arial Black"]Dir c:\*.* /s /b[/font]
Good old DOS Jeff, you can't beat it can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2010 at 11:56 am
Scott Wise (3/22/2010)
Perry,I really appreciate the follow up. Isn't what you are saying to do just creating a new cluster?
No, it is creating a new clustered instance 😉
there is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2010 at 10:40 am
newbie2sql (3/19/2010)
Solution you had given me is correct for my solution. Currently I am checking the permissions and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2010 at 4:19 am
yes, that goes without saying!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2010 at 4:16 am
OK, i made this real easy. The screenshots below shows the registry entries created when installing SQL Server and the instance configuration in the installer. Notice the default instance (MSSQLSERVER)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 6:45 pm
i dont see whats wrong with my script?? :ermm:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 6:31 pm
As Gail says "no commit, no dice" 😉
it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 6:27 pm
GTR (3/18/2010)
Perry, are sure that will work on cluster?Scott, i think if you need two instances on cluster then you should go for Active\Active clustering with two named instances.
you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 7:18 am
try this
--uncomment the where clause and specify a database user
--to get permissions for a single account
USE yourdbhere
SELECT
'Permission "' + CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS + '" "' +
case CONVERT(NVARCHAR(10),...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2010 at 4:24 pm
Viewing 15 posts - 8,146 through 8,160 (of 9,241 total)