If theres only two values you could create a view with static text.

create view newtable as

select column1, column2, 'EM' column3, column4

from table1

or you could translate it

create view newtable as

select column1,...

Change it to use hours.

Delete files older than 78 hours (3 days + 6 hours). You will get a more consistent retention.

You cannot backup a database in standby either. The restore process must be 100% complete before you can run a backup.

sahoong (8/4/2009)

---

The Gurus,

Could you please, tell me how to change the collation settings of a database to match that on the database server on which it is installed? The...

Oh ya, forgot you need bs.type = 'D' in the where clause

well, if you were just shrinking without reorg, it probably wouldn't claim much back. And the number has to be a valid number bigger than the current data size...

your other options:

CLR SP

http://stackoverflow.com/questions/214698/file-path-size-in-c

OLE automation object

http://www.databasejournal.com/scripts/article.php/3443911/Check-File-Size.htm

This was already addressed here:

http://www.sqlservercentral.com/Forums/Topic734169-149-1.aspx

Your data file, correct? not your log file?

what happens when your run

DBCC SHRINKFILE (N'MSDBData' , 250)

First create a credential

http://msdn.microsoft.com/en-us/library/ms190703(SQL.90).aspx

Then create a proxy

http://msdn.microsoft.com/en-us/library/ms190698(SQL.90).aspx

Then create a CMDEXEC agent job to run your cmd file and schedule it according to your schedule

http://msdn.microsoft.com/en-us/library/ms190264(SQL.90).aspx

Note...

did you try running it through an agent job with a proxy account? I'd personally go this way. You'll get more logging, notification and control this way.

And you...

Is your application referencing it like server.database.schema.table???

If so, you need to change your code where the table is referenced.

Just install the base install (RTM) then go straight to SP3.

No need to install the other ones. It's cumulative.

Then if your client tools don't update, re-run the SP again...

You could also read the msdb tables and find the latest file backed up.

I just whipped this together and could probably be written better - and should be tested! ...

OK - so to confirm, run this on your database:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel')

When you re-run the SP3 installer and hit next a few time you should see the list of...