ddonck (2/20/2009)

---

I didn't know about xp_delete_file. It might be a solution for us, but I see it doesn't work for txt files (not surprising, as cleaning up txt files in...

Can you Try? http://support.microsoft.com/kb/814398

If some temporary access is needed you could be receiving this error because of insufficient permissions to a temporary folder.

I am sure you are having a configuration...

AFAIK "Funeral Homes" can only have surpluses and not downsizing :Whistling:

Can't believe this joke thread is still alive!

is it: Windows 2008 x64 Enterprise Edition ?

Full code:

SELECT

object_name(i.[object_id]) ...

sys.partition_range_values

Is the OS the same version ?

50 is *not* a lot 😀

I am thinking of using SELECT INTO...but the problem is that it copies the data also.

is there any way i can just copy the structure of the table using SELECT...

As its Name implies MERGE will "merge" changes bidirectionally. So all you need is to point your clients to the right server.

One way of doing this is by using DNS...

When you said "stopped working" What error do you get ?

If anyone can "accidentally" DROP a database you have much bigger problems!!!!

You can prevent "accidental" DROP DATABASE using:

1. The...

You can determine if someone has a transaction running on tempdb with DBCC OPENTRAN('tempdb')

Lowell (2/20/2009)

---

you want to test IF EXISTS(any rows in logger2)

not that (somequery = 0)--you weanted to count the rows or something, right?

so you'd want to tweak it to something like...