Now is a good time for me to use the blush icon as the example I gave does not work 🙂 Just tried it.

It all works...

Hi.

Your best bet would be write a normal select using FOR XML to create the XML.

Once this is correct you can use the extended proc

http://www.sqlservercentral.com/products/jgama/XP_file/

which allows you...

Greetings.

There are tools such as Embarcadero and RedGate. Favorite is Embarcadero 🙂

They compare two DB's or selected objects and generate alter script to sync them.

http://www.Embarcadero.com

Cheers,

Crispin

The guy just sent me one of the culprits.

No select intos... 🙁

Any body spot anything that may cause the problem? I can't.

SELECT DISTINCT 

  ...

Hi Steve.

Apparently it is reproducable.

I am just relaying messages 🙁

It happens in a proc which is only doing a select.

You can run the proc 10 times and you'll get the...

Hi.

Using QA Use CTRL + Shift + T will show you the times.

Something else I do is assign DateTime to a variable at the top of the proc and at...

I would give 1 or 2 more senior developers access but certainly restrict most people.

Becomes to easy for people to screw things up and just keep quite.

I have 9 enviroments...

I can't think how you would do it with a proc but you could

use a function to update each row in the table.

Convert the proc to a function.

Update...

I prefer not using a mouse. Find it much faster doing things with the keyboard.

It's the one draw back of mssqlXpress. There are some keyboard short cuts that are missing....

What did I do before SQL?

I used to repair industrial cranes, tower cranes etc etc. If it lifted things, I would repair it.

Small change in career.

James,...

Hi Carl.

There's an app called mssqlXpress which handles that.

It's basically a replacment for QA and EM.

Has some very nice / handy functions (Code Completion!!! 🙂

Integrates into MS VSS nicely.

http://www.xpressapps.com

Embarcadero also...

Thomas, must be hurting you to watch the cricket at the moment.

When time comes for Rugby, you...

bnordber: Sorry mate. Over 30!

ejdelaune: Almost but I got no kid.

Guese I am still aloner....

In ten years time...

Does the service log on using system account?

I had a similiar problem but between w2k machines.

Created a domain account called SQLSVC and SQL uses that to logon.

The share on the...

Thanks Dale!

Cheers,

Crispin