When you execute the following statement under QA it shld list out "remoteip" under name column:

select * from master..sysservers

While refering to link server use the following notation:

Servername.databaseName.Owner.ObjectName

HTH

MJ

Don't forget to track Data File Auto Grow and Log File Auto Grow Events (especially for tempdb database) under Database Event Class.

MJ

I would like a copy of the RDL and resource info as well. Please email me at manujaidka@gmail.com

Thanks,

MJ

Check if there is any open transaction in database by running DBCC OPENTRAN. If it returns nothing then its fine.

Shrink in pieces as u said u are not able to...

Still I will ask you in future for scripts in case I am in need of any such information regarding database objects and so...

Hope you won't say no in case...

Adam,

Are you doing this:-

create table #enum_job (

Job_ID uniqueidentifier,

Last_Run_Date int,

Last_Run_Time int,

Next_Run_Date int,

Next_Run_Time int,

Next_Run_Schedule_ID int,

Requested_To_Run int,

Request_Source int,

Request_Source_ID varchar(100),

Running int,

Current_Step int,

Current_Retry_Attempt...

Now everything looks fine. I checked few things(pad_index, siz and included column info, create script etc.) and changed them and cross verified too, evrything looks fine.

Thanks for sharing the script.

In...

Article on http://www.sqlservercentral.com/articles/Administration/2987/ says you need to create fulltext indexes again.

MJ

Under Path in front of new file (right click database-->Properties-->Files) just specify the new drive path. For example if you ant to place database mdf file in new drive say...

Temporary solution (worst one too)--Add files to the database and place those new files on C drive(assuming its not a clustered environment) and in the meanwhile get new drive as...

Check the table fragmentation level(using DBCC showcontig). Are you sure its incremental rather than FULL one.

MJ

Hope you find this useful:

http://www.sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx

MJ

http://www.microsoft.com/sql/solutions/upgrade/default.mspx

You can download the Upgrade Advisor and some useful documents from this link.

Check the below ones too:

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1188595,00.html

Good article at--> http://www.sqlservercentral.com/articles/Administration/2987/

Good guide from DELL at--> wp.bitpipe.com/resource/org_941910899_454/11381_31717_edp.pdf?site_cd=cv -

HTH

MJ

Go thru this link-->http://www.aspfaq.com/sql2000builds.asp

Hope u find it useful.

MJ

Yes you can. Please refer the link: http://msdn.microsoft.com/en-us/library/ms178083.aspx

HTH

MJ