IMO just copying SMO.dll will not do the trick you want.

Keep in mind you can connect to non-local servers/instances as well, so you should be able to perform your actions...

Does your "3. run a dos batch file to rename the trace file with a timestamp" succeed when the start new trace fails ?

Golova (1/21/2009)

---

Hi,

One more question:

If I have to roll back to the SP2 according to Microsoft i nave to re-install SQL server 2005 and then restore all system dbs,...

Bad to the...

I knew one of my friends did suffer these DRP issues after upgrade, but I couldn't find the ref.

Today I found it back, so here it is:

http://sqlblog.com/blogs/allen_white/archive/2007/10/08/pay-attention-to-cluster-setup.aspx#11345

approximately 1,000,000 members of SSC ...

first glimps:

One thing I've seen in your 1222 list :

UPDATE WebCustomer SET CustomerCode = CustomerID

WHERE CustomerGuid = N'851e456e-2389-4c82-96b9-4be6aa93f717'

....

(@1...

hmm... indeed posting the query would indeed demistify a little bit.

Just copy/paste it as it is in your actual application/script.

(no matter the language 😉 of the columns)

Norm (1/20/2009)

---

Hi,

I have implemented an auditing solution that uses 3 different trace files. My ultimate goal was to have a static trace id for each type of audit (DDL,DML,Logins).

The...

Here's a set of scripts to diagnose SSB.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/

And don't forget the SQLserver Errorlog !

As you have seen, if the question is good, the solution(s) come in quickly :w00t:

Lynn gave you the solution.

However for the query I would suggest to use a convert with a specific conversion type.

This way everybody maintaining your query will know of the explicit...

- Cross db queries ??

- we have been warned as from sql7.0 (if I'm correct sp2) that this kind of joins were obsolete. And with every migration project I've...

Is this related to bug http://support.microsoft.com/kb/959006/

SP3 has it in its fix list :w00t:

Nice testing Gabe.

Thank you for the feedback.

One of my co-workers discovered the same and it is a valuable lesson.

It is certainly worth to know, because everyone experimenting with partitioning and...

Lynn Pettis (1/7/2009)

---

Okay, I will look into that tomorrow morning (well, it is almost tomorrow morning now for me) when I get into work. I'll let you know what...