check if this helps.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DiskAvailableSpace]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[DiskAvailableSpace]

GO

CREATE TABLE [dbo].[DiskAvailableSpace] (

[ID] [int] IDENTITY (1, 1) NOT NULL ,

[DriveLetter]...

http://technet.microsoft.com/en-us/bb738014.aspx

It will ask you to register with microsoft. Its a huge file of 280...

Its a bug in replication in 2005 and is fixed in SP2. Apply SP2 but you cannot revert back sp2 on 2005 server. So, test this on...

for SQL Server 2005

create table #DBUSERS

(

DBNAME varchar(50),

USERNAME varchar(50),

MEMBERNAME varchar(50),

OBJECTNAME varchar(100),

PERMGRANTED varchar(200),

PERMDENIED varchar(50),

COLUMNPERM varchar(10)

)

declare @cmd nvarchar(4000)

declare @cmd1 nvarchar(4000)

set @cmd =

'insert into #DBUSERS (DBNAME,USERNAME,MEMBERNAME)

select...

Dinu E Anastasiu (3/19/2008)

---

We need to create a new empty database B which should have the same elements (tables, views, stored procedures etc) as an existing database A.

Is there another...

Can you please elaborate the question in detail? I didn't get it?

Priya20001mu (3/19/2008)

---

Hi,

Can anyone tell me why i am getting this error msg? I am running this trace file through stored procedures, not through profiler.

If anyone has a solution to this,...

You should take the backup on same server and then move backup to another server using xcopy or robocopy. DBA job is to reduce the risk and worst if...

I agree with Jason. I did the same thing. after SQL Data compare, created Logins and users and mapped them.

You can download a 30 day trial version.

Thanks DAB. useful link. I was in search for these counters for perfmon...

check these links. I am not sure if this is what you are looking for.

http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en

http://www.sql-server-performance.com/articles/per/stress_test_part3_p1.aspx

select database name from the drop down list in each job step or use

use Databasename

Go

in each step.

You can change the value of OrigFillFactor column in sysindexes table for that particular index. You have to change it before executing DBCC INDEXDEFRAG.

Use master

declare @DBName varchar(35),

@STR varchar (255)

declare DBRecoveryModelGenerator_cursor cursor for

select name from sysdatabases

where category...

I had the same issue. I had to uninstall SQL Server 2005 instance, restarted the server and reapplied SP2. Mine was active/passive cluster. Worst thing I found about...