To my knowledge there is not spec. max number but storage limit is to be considered. 

In general its better to use as few cursors as one can. Cursor definitely...

Sql Server 2005 does not provide Backward Compitibility to 2000 version.

It's completely rewritten product.

I am generating the reports from second server using the same sequence and never came across any issuse that you specified.

I do not understand what you mean by every so...

Instead of taking differentials every 30 min. Think of Backup schedule, where you take one Full Backup , one or two [6/8 hrs. apart] differential and transaction logs every 30 min....

Malcom,

This is BOl, check uninstall steps one more time, in the sequence provided here.  

How to: Uninstall an Existing Instance of SQL Server 2005 (Setup) 

Shahab,

Check this very good article in Database Journal by MAK http://www.databasejournal.com/features/mssql/article.php/10894_3389831_1

To restore the "Inventory" database as "MyInventory" database. Copy and...

If You have created BackupDevice then you Restore log command and specify backupDevice name or else copy paste t-sql for all log and change last one with recovery.

RESTORE LOG MyNwind

  ...

Richard,

This script will drop temp table if it exist.

/* drop the temporary table if already exists */

If Object_Id(‘tempdb..#temp') is Not Null

Drop table #temp

/* create temporary table */

Create...

Melissa,

Can you please specify the Salary and benefit details.

I am currently working as Sql Server DBA with 5+ years of experience in DBA & Development.

You can find my post in...

You can even use script if you want to kill all processes from any specific database.

Here is the Script

Create procedure usp_killprocess @dbname varchar(128) as

set nocount...

Bill,

In my view Maintenance Plan in 2005 is not a good option right now for prime time use in production environment.

I have previously placed few issues here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=241231

Hope this helps,

Hi Robert,

Today I have send an email to you.

Try this one

SELECT ORDINAL_POSITION AS POSITION,

COLUMN_NAME = Left(COLUMN_NAME, 20),

DATA_TYPE = Left(DATA_TYPE, 10),

CHARACTER_MAXIMUM_LENGTH as MAX_LEN,

COLUMN_DEFAULT ,IS_NULLABLE AS ISNULL,

NUMERIC_PRECISION AS NUM_PRECISION,

NUMERIC_SCALE AS NUM_SCALE

FROM  Master.Information_Schema.Columns

WHERE Table_Name = 'test'                 ---Change name to...

In your case

Database size: 805679.38 MB

Unallocated space: 143749.79 MB

you have about 18 %...

You can find name and Id of DTS in system table in msdb DB

SELECT * FROM MSDB..SYSDTSPACKAGES