I either use the local Windows scheduler and batch files to call maintenance and backup scripts or schedule SSIS packages on another server with the scripts in SQL Tasks.

Here's a link to the scripts, with instructions, that MS provide for moving logins with their SIDs and passwords: http://support.microsoft.com/kb/918992

sqlfriends,

I don't think there is a 'typical' size for a Sharepoint database, that would depend on the amount of data being stored in it.

You don't say if your database in...

Ninad, Shiv,

Search for sp_spaceused in BOL. You will see:

There are some situations, for example, after an index is dropped, when the space information for the table may not...

crazy4sql, I don't want to appear rude, but you're wrong. My experience of renaming local instances using those procs is the same as Michael's. To quote the BOL entry...

crazy4sql, if you look in BOL at the topic How to: Rename a Stand-Alone Instance of SQL Server 2005, you'll see that

sp_dropserver <old_name>

GO

sp_addserver <new_name>, local

GO

is exactly how to do it....

Does this help? http://netic.wordpress.com/2010/03/26/negative-spid-in-sql-server/

To answer your question of why the instance is there, during BackupExec installation, unless it's pointed at an existing SQL Server instance to create the BEDB database it will install...

On the Advanced tab in the job step properties check that the On Success action is not set to 'Quit the job reporting failure'.

Possibly a case of parameter sniffing? http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing

Hi Balaji.

Did you try registering dtspkg.dll and dtspump.dll on your client machine too? Also, this is the 2008 forum - are these packages migrated from 2000? There...

Have you tried registering the Activex Script Host?

Instructions here: http://www.sqldts.com/224.aspx

GO is a batch separator, so your SP is only executing up to the end of the first INSERT. Remove all but the final GO and you'll be sorted.

Check...

And thank you for the link - very informative. From reading that it looks like the OP could be in luck. Will be interesting to see what their...

@SQLBuddy123

Here's someone who's proved SQL Standard 32bit can use more than 4GB on a 32bit OS:...