You probably didn't get much interest here, because this forum is for SQL Server 2005 (aka Yukon)!

But it is true that the row size in SQL Server is limited to...

I'm not entirely sure what your question is, but I'm guessing you're wanting different dates to get through to SQL Server.  Have you tried doing a debug.print or a msgbox...

In that case you could create a DTS job and then use your sp to launch it.  For example, you could add DTS to the SQL Server Agent (without giving...

> I also have some confuses here.

That's my fault, I think, because you raise some good points that I didn't think of.  I have very little experience developing extended stored...

We have run into this a few times, primarily with down-level and third-party clients, and usually in a situation where the server was requiring security but the client could not negotiate...

Sahana,

The default trace configuration will capture this information for you.  For SQL:BatchCompleted events and RPC:Completed events, the Duration column of the trace is the number of milliseconds of real ("clock")...

Randall,

So do you already know that Query Analyzer can do this?  Click Tools | Options | Results tab, and then set the "Results output format."

If you want to do this...

Have you tried running sp_diskspace?

-Chris

If it's a production server, that's all the more reason to take it to PSS.  And when opening the incident, make sure that they know you have a Level 1,...

I hesitate to reply, but this should be a short, simple answer:  remember that Oracle8i does not support the ANSI join syntax (the syntax using the word "join").  On 8i...

Adrian ... thanks.  Gack, I can't believe I missed that the format Kevin wanted was one of the CONVERT formats.  Grrrr to me for being in a rush ... but thanks for...

I hope my friends at netapp.com don't come and hunt me down for this, but I'd like to chime in just to say this:  stay on SAN storage for your...

Allen,

I've not run into those assertions, and although somebody else may ring in with some experience specific to the problems you are seeing, I would encourage you to file a...

> much more than was deserved in this case.

I don't know about that ... I thought your original reply certainly deserved to be followed up!

Take care,

Chris

Oh, one more thing:  the length in the STR function is listed as 11, not 10, because this length has to include space for the decimal point as well as...