For your first issue, SQL Server does have connections to itself - I imagine these would be those connections (especially if the SPID is < 50).

The applicationName that SQL profiler...

Look at these MS KB articles..  It seems that you can indeed have several thousand values quite easily.... However, just make sure you upgrade to SP4 as it can cause...

I would suggest that you wouldn't set remote query timeout at the SQL Server end - try setting it for the oracle gateway instead...  Not sure where to set it...

Please don't cross post - answer questions in this thread instead..

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=243743

Helps keep everything together

No probs.  What you want to do is take another log backup of your database as it stands.

Then you should restore your full backup to a new database (just to...

Please don't cross-post, or if you must, at least include a link in your cross-posted question to your original question.. helps those searching to get all the answers in one...

I've never played with the proper "log shipping" feature of SQL Enterprise so I am not sure.  But the idea of "log shipping" is to have the initial full backup...

and will probably beat it for some time to come

You can at least, in VM Ware (and probably in MS's virtual PC/server) set...

No probs   Glad you found a solution

Are you sure the truncation is a bad thing?  Have you tried restoring your full backup, followed by each of your transaction log backups and see if things are all...

Also, to my knowledge the client tools have not changed between SQL Server RTM and SQL Server SP4 - the service pack is for the sever, not the client tools... ...

Also look at the information_schema views - look in BOL index for "information schema views".  These are the nice and supported way to retrieve metadata from SQL - although I'm...

I would suggest that you could do it using combinations of xp_cmdshell executing the dir command with the /s and /b switches, selecting the result into a temp table.  Then...

Had a similar thing at one stage...

What about

select
ciName, 
(select attributeValue 
 from ciAttribute_t cia 
 where cia.configurationItemID = ci.configurationItemID
 and attributeID = [ATTRIBUTE_ID_FOR_MODEL - OR DO JOIN TO ATTRIBUTES TABLE]

)...

You can't refer to a column alias in the where clause.  I also don't understand why you have a couple of selects in your second attempt?  So modify your query...