Hi

cant speak for SQL 6.x or 7 but certainly from 2000 on the default of 0 is 100% thats what i have understood and read.

Yes you probably want to change...

I too have had...

especially ensure the first thing you do after restoring or attaching the database to SQL Server 2008

is to run

DBCC UPDATEUSAGE

see the following link

http://msdn.microsoft.com/en-us/library/ms188414.aspx?ppud=4

you may have to leave the compatibility level...

paulc.byrum (3/26/2010)

---

Perhaps, my problem is that I have several instanaces of SQL Server. They are:

SQL Server 9.0.4035 (SharePoint instance)

SQL Server 8.0.2055 (Standard edition)

SQL Server 8.0.760 (MSDE)

SQL Server 9.0.4053 (Express Edition)

The...

paulc.byrum (3/31/2010)

---

I tried:

sqlcmd -E -d master -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

and then:

ALTER LOGIN [PBTF\Group - IT DB Admins] WITH DEFAULT_DATABASE = master

No errors running the command, but I still see Error 4064 in...

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