In your original post your SQL creates a stored procedure prefixed with "sp_". Make sure you're aware of the potential knock-on affect of creating sp's that are prefixed "sp_".

Try something like this and check for createddate

select * from sys.objects where type = 'U'

*Thats create_date, not createddate

Bkirk....Jeff is bang on the money there, if you choose to use that undocummented sp it'll run for EVERY database, including system ones.

Without showing us the table defs etc it's...

You may want to check out the undocummented procedure sp_msforeachdb

Ok my understanding is that the filegroups are "owned" by the database owner. And therefore you'd need to call the sp_changedbowner procedure. But wait about for one of the experts...

If the fragmentation is as high as that you may want to consider rebuilding the index.

Although without seeing the script you've been advised to run, im guessing it does...

There is no TRIM() function in SQL Server, although you could argue there should be, for times when you need it.

You can always create your own udf which basically...

This kind of overview is easily obtained with a simple google search.

Try this

http://msdn.microsoft.com/en-us/library/ms189852.aspx

I think its due to the fact that each call to xp_cmdshell spawns a new shell process and so the second call (2nd process) can't see the variable. Which explains...

Yes, there's no [WHERE] clause?

To audit you'll need to set up an UPDATE trigger on the table in question. Check BOL for INSERTED / DELETED tables inside triggers

What about merge replication?

Ah thats a much better solution. Great technique, will remember that one for the future. Cheers

The problem here is that if you want SQL Server to display that date in this format DD MMM YYYY (20 Dec 2009) then you need to convert it to...

Recommend looking up PIVOT in BOL.

Hi, you need to convert back to datetime in order to get the correct ordering.

Something like this..

select convert(datetime,convert(varchar(11),datecolumn),103)

order by datecolumn