gomikem (9/12/2008)

---

I have some SQL in the code of one of my reports that calls fields from linked (SQL) tables and some pass through queries stored in stored procedures. When...

I'm sorry, I've overlooked the fact I was using sqlcmd. :blush:

Copy / paste .. you know :ermm:

did you try using the column separator parameter ?

from bol:

http://msdn.microsoft.com/en-us/library/aa214012(SQL.80).aspx

-s col_separator

Specifies the...

well ... here's what I used...

http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html

-- how to determin SQLServer Uptime

-- Source: Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html

--

--

SELECT @@servername as ServerName, datediff(mi, login_time, getdate()) as SQLServer_UpTime_Minutes

FROM sys.dm_exec_sessions

WHERE...

If you log load isn't that much, you may want to consider making a full backup and use log backups.

Then you can restore the full backup (norecovery) (first...

Does anyone know what the terminology GDR and QFE means in the bulletin ?

It mentions SQL2000 GDR , SQL2000 QFE, SQL2005 GDR , SQL2005 QFE.

Am I having a weak...

Gayathri.Varadarajan (9/12/2008)

---

T...In fact the PK which i have referred to in the forum is itself the surrogate key and all the child relationships are based on this key.The actual PK...

Many times, this kind of issue points to the upmost advantage of using surrogate keys (which don't have a symantic payload at all, but their strict value).

Change of...

That is indeed a valid workaround if this is a singleshot operation (upgrade, bugfix,...)

If you want datetime info, your best choice is a column of the datetime data type !

You'll get a bunch of datetime functions to surve you !

Rule number 3:...

Then don't update PKs !

If you have FKs pointing to that parent table (I sure hop so), and you realy need...

Isn't this one in Steves build list ? http://www.sqlservercentral.com/articles/Administration/2960/

info at http://support.microsoft.com/kb/934458

did the "restore database" step succeed ?

(what's it output)

can you perform sp_helpdb 'test'

Euhm.... no. It does not produce the same result as show client stats.

Test it and you'll see it reports on object base (stats io).

You can then compare that to what...

I have the impressions it comes to your output capturing way.

Use this:

SQLCMD -E -S .\SQL2000PE -d master -i ".\Osq_Test.sql" -o ".\Osq_Test.txt" -w340 -n -h-1

my Osql_test.sql contains:

/* just produce an output...

you just don't !

Check BOL for timestamp datatype and you'll figure out it is a type that sqlserver maintains itself ! (with every modification to the row !)

So you can...