Ah, okay. I suppose that didn't come up for me because I was using them for scripting and I just used the "dependent objects" trick to get them.

s'alright. 🙂

Preaching the evil of cursors then using them yourself for particular instances can be a mixed message for neophytes....

More generally, the OUTPUT parameter modifier does not prevent them being used for input also.

Here's a shortcut way to deal with the namespaces problem:

SELECT CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).value('(//*:DocOrgName)[1]', 'NVarchar(50)')

, CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).query('(//*:DocOrgName/text())')

from DocumentSource

cspencer (3/30/2009)

---

So so. While sysobjects does contain the name of most objects (the exception being indexes), it doesn't directly contain the parent object. I need to do another join using...

dlongnecker (3/30/2009)

---

I'm going to have to side with the cursor argument on this one.

A one time use/db script probably isn't going to take the server down.

The probability of overfilling an...

Krushna (3/30/2009)

---

It was showing :

The network path was not found.

But after I've changed it to a...

The real hard part was figuring out how to spell the tag labels. They're case-sensitive and not generally capitalized the same as they appear above.

Do view source on any forum page and look at the js "Brush" modules right at the top:

<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shCore.js"></script>

<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushCpp.js"></script>

<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushCSharp.js"></script>

<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushCss.js"></script>

<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushJava.js"></script>

<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushJScript.js"></script>

<script...

Do you ever miss a login or a logout? If the answer is no, then you should be able to just count the logins and logouts and match then...

I think that it is just a matter of the order of the Path and Value within the key.

By the way, although I don't think that it is the cause of your current problem, you probably should be using SCOPE_IDENTITY() instead of IDENT_CURRENT().

Also, if you want to quote the post you are replying to, then just click the "Quote"...

If your Inserts are fine, then you are probably OK with that many indexes. You might still use some of the prior advice to determine whether you are using...

good catch Jeffrey!

On my 2005 server this SQL code gives me the same error as the OP, however on my 2008 server, I get "Invalid object name 'Source'." which is...