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...

Dugi (1/10/2009)

---

I didn't read in deep for the Resource DB, I just was wondering why the other Sys DBs are available for BCK and RDB is not ! Anyway thnx...

Right there with you Lynn.

To me ansi is the guideline, "dialect" will get used whenever ansi doesn't perform as it should.

IMO that's where any DBMS will try to make a...

As Manu stated you need to use SQL_Latin1_General_CP1_CI_AS

CREATE DATABASE [yourDbName] ON PRIMARY

( NAME = N'yourDbName_data'

, FILENAME = N'X:\MSSQL.1\MSSQL\Data\yourDbName_data.mdf'

, SIZE = ..., MAXSIZE = ..., FILEGROWTH =...

Right on target :exclamationmark:

No reason to shout 😉

Why are you using a cursor for this in the first place ?

It would be better to just select it directly into a...