Viewing 15 posts - 8,131 through 8,145 (of 9,241 total)
Naresh
you could try
declare @rows int
select * into dbo.users_new from dbo.users
select @rows = @@rowcount
Print 'Rows copied = ' + cast(@rows as varchar(10))
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:10 am
Casper101 (3/29/2010)
We are in the process of rebuilding a cluster with new hardware. The current 2-node cluster is running SQL Server 2005 (Server A) and the new cluster has SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 9:58 am
as Jeffrey said DBCC LOGINFO and check for anything with a status of 2 near the bottom of the output. SQL server will not truncate or shrink (they are both...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 9:55 am
ourehman (3/30/2010)
Can you login with some other admin account.
see my post immediately above, he needs to confirm he is logging into the correct instance first!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 7:49 am
paulc.byrum (3/29/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 7:18 am
Hi Paul
got that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2010 at 3:27 am
Youngoz
upgrade straight to 2008, just bear in mind what i previously pointed out and as Jeffrey said update your stats too. The full rebuild should catch most of those anyway,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2010 at 3:10 am
whether upgrading to SQL server 2005 or 2008, immediately after run DBCC UPDATEUSAGE and rebuild all indexes. Also run DBCC CHECKDB with DATA_PURITY to ensure your database(s) have no metadata...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2010 at 2:30 pm
pandrikopoulos (3/28/2010)
I agree in general with your suggestions but you should take into account that the database hosts a SAP application. SAP has some restrictions in the way a database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2010 at 2:02 pm
what info does the event log show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2010 at 5:52 am
when upgrading from SQL Server 2000 to 2005 you are well advised to run DBCC UPDATEUSAGE and rebuild all indexes.
Having said that when carrying out normal maintenance on a SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2010 at 5:49 am
scripting the login accounts from the primary to the secondary should take care of any SID mismatches. Or just use the SP_Change_Users_Login stored procedure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2010 at 3:47 pm
starterm (3/25/2010)
How do you make failure in primary server instance
Pull the network cable out!!!!
starterm (3/25/2010)
and make secondary server instance databases onlineplease provide your suggestions..
To bring secondary databases online, restore any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2010 at 3:38 am
No problem, glad i could help!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 25, 2010 at 7:16 am
river1 (3/24/2010)
ok, thank you very much.So what is the "EXECUTE AS" for?
to execute as another database user that is not linked to a server level login
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 12:13 pm
Viewing 15 posts - 8,131 through 8,145 (of 9,241 total)