May be a sytax error where you did not properly specify the interface. I have a small one at work I threw together serveral months ago I can send to...

Sorry, EM and QA do not support hot key macros.

You need to get an idea of the solution taht will alow you the closest duplication of data within reason of data loss.

Major consideration I would add is size...

Unfortunately, Log Explorer is the only tool I have sen that can do this. The fact however that it can do this does mean a DBA should be able to...

I got to thinking about this and it doesn't really matter as %CPU utilization is a process relative thing. You always have threads on the CPU of which many are...

Simon, the growing a set number of time only applies if you set a restricted growth amount. Most folks leave as unrestricted growth, and that is generally because they didn't...

At the table level no. And there is no real good error trapping in SQL. The big problem is if you wrote to a table the errors via trigger the...

Then use the cast as Greg suggests in yuor update in the place of your Round.

Is there a specific reason you cannot change the DB to stored as DECIMAL with...

The big things are stability of application as if one causes sql side issues it can stall the whole server and thus affect your other app. Other than that it...

The query would have to run in the from space against either a linked server using OPENQUERY or there using OPENROWSET.

If you use a linked server then something like this...

You will get an error off of

myq.Connect = strConnect

You will ned to look up the return codes for this method to find out what they mean.

quote:

---

If you look at the three executables that make up SP2 you will notice that one of them is specifically for AS...

Michael...

Try this.

DBCC REINDEX all the indexes

Run sp_updatestats

then DBC UPDATEUSAGE

(see BOL for more info)

I have seen some issues with upgraded databases acting just a bit odd until you do these things.

May...

Describe what you mean by gateway, I have missed this somewhere and may not understand it as that terminology? Other than that sorry, not sure.

In the DTS it builds a default type but on the destination tab you should be able to change to what you want. Note however, I think there is documentation...