Just for giggles......  Did you call the Garbage man to clean-up the trash heap?

For those who don't get the reference (Oddly I get this a lot) "Trash heap" was the...

Just to add to what David has stated (and does well always), depending on the SIZE of the data and the available memory to SQL will also depend on IF...

I guess your only recourse would be.  Send the SELECT statement to a #TEMP table, gather the MAX(LEN) of all the various columns, build another #TEMP table using DYNAMIC SQL...

1.  I wonder if your account is being spoofed when connected via VPN.  Try creating a VB app that will pop a message with Environ$("USERNAME") that you run from home...

Monty,

You will need to write a custom function to properly format the string.  I think this is because of the various different money formats throughout the world.  Some sep...

If you view the results in QA using the GRID option (Menu bar Query > Results in Grid) OR CTRL+D this will show you just space used

OR

You can CAST/CONVERT the...

Have any changes/upgrades been performed on your Exchange server?

1.  IF @Enddate > getdate should be > GetDate()

2.  I don't think you can call GetDate() from inside a UDF

Try and pass in GETDATE() as a 2nd Variable as in...

According to the Query Plan (From toolbar in QA select Query..  Show Execution Plan) Query 1 is more efficient (doesn't perform a TOP).

However, the TOP cost is 0% it is...

NT scheduler would be painful because you would need to create a schedule for every 10 minute interval OR

approx 120 - 130 schedules per task...... (you cannot schedule other than...

With scheduler you can run it multi. times daily on the schedule tab check show multi. schedules.  Of course this is very painful ....

Do you have the database open in EM?  Try closing EM and ensure that no one else is attempting to access the same DB

When attempting the restore via QA make...

Please avoid multiple posts..

See comments http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=163854

I would research performing a loop with sysojects where the objects are "owned" by the non-existent userid.  This way you could set-up dynamic SQL ...

I think the problem is now you are trying to login with TRUSTED AUTHENTICATION but your server isn't configured for it.  Check the linked server (under security) and check to...