Hi Shawn

yes, as previously mentioned you need to have the paper proof which normally the DBA doesnt have access to (only the admins or bean counters 😉 ). If the...

Hi

you could use the following but as already mentioned it will probably not be helpful as paper proof is the norm now

select serverproperty('Licensetype'), serverproperty('Numlicenses')

However these details can be entered onto...

Jeffrey

i understand exactly where you were coming from.

All

From BOL

However, if the old log file is not found and if the database was shut down cleanly and has no active log...

SQL Server should really be installed after the computer name is changed, having said that

check the following link from MS

http://msdn.microsoft.com/en-us/library/ms143799.aspx

ensure each clone is prepped properly (new SID and computer name)

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...

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

Hi

you may also want to post this in the appropriate forum in future

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))

Casper101 (3/29/2010)

---

Hi,

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...

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...

see my post immediately above, he needs to confirm he is logging into the correct instance first!

paulc.byrum (3/29/2010)

---

The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL...

Hi Paul

got that

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,...

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...