Viewing 15 posts - 8,131 through 8,145 (of 9,244 total)
Hi
only if you install SQL Server 2000 does it have to be a default instance and must be installed first before SQL Server 2008. Otherwise it doesnt matter. As Paul...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:27 am
Hi
the following is a great little utility I use for managing and extracting reports, etc from SSRS
http://www.sqldbatips.com/showarticle.asp?ID=62
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:21 am
Hi
you may also want to post this in the appropriate forum in future
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:13 am
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
Viewing 15 posts - 8,131 through 8,145 (of 9,244 total)