There are extended stored procedures that link SQL Server to mail (the xp_startmail, xp_sendmail, etc.).

Some of these include the ability to read mail and you can process the items...

Try restoring with no log. I'm surprised it wants so much temp space, but it may be a check of x times the size as a just in case.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

sp_dropserver

sp_Addserver <new name>,local

will rename the server

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

I usually do two things.

1. Measure the time (use select getdate() around the queries) on the server or client.

2. Check the subtree cost. The percentage cost will always be 1...

Roll with fulls every hour (or every 30 minutes) and then logs every minute or two.

Be sure you get these off the local server in case the server itself fails.

Steve...

Sorry, I see what you mean.

In the code, the first replace is a single quote, followed by 2 single quotes, then another single quote. Why 4?

1 - open string

2...

I roll with logs every hour and once a day backups. We may shrink this down. However, it's a question of restore time. How quickly do you want to be...

Tough to say. Are teh servers the same hardware? Could be that. Could be fragmented. Might want to check with dbcc showcontig and rebuild clustered indexes.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Thanks .

I need to modify this, but the main point still stands. Make someone write some code and use questions that show someone understands SQL, NOT that...

Each single quote must be doubled for SQL to work a ' repeated as '' is not the same as ". They are two difference characters.

If you replace(@string, '''', '''''')...

You are welcome and glad to help.

BTW, I usually use a Domain account so I can get to mail, remote backups, etc. Local Admin, not Domain admin.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Go into Control Panel, Admin Tools, Services and check the account under which SQL Server runs. It's not the account you log in as.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Most changes require a rebiuld of the table because the physical structure changes. If you change the table in EM, the third button from the left is a script button....

yes, you rebuild the index and you can specify the filegroup.

http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409

note the ON clause.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Moving the clustered index should do this. I'd be sure you save the changes, shut down EM and then go back to be sure it refreshes.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones