ok i know linked server queries are slow because if you join a local table to a remote table, the entire remote table is downloaded into local temp, and then...

CREATE TABLE [Test] (col1 bit)

DECLARE @endDate datetime

SET @endDate = DATEADD(hh,8,GETDATE()) -- 8 hours from now

WHILE GETDATE() < @endDate

BEGIN

INSERT INTO [Test] VALUES...

the procedure sp_spaceused takes an optional parameter, tablename, which would give you some info like this:

sp_spaceused CLIENTREQHIST

--results:

name rows...

i just changed it on my dev machine, and can find it in both the SQL logs and the Event Viewers "Security" Windows logs, but it's not obvious what the...

do you host the email server? if you are talking about emails you SENT, you cannot, you can only check the status of emails that exist on your mail server,...

Paul White NZ (5/5/2010)

---

I've had a much better idea. Create an XML format file like so:

<snip>

And use the BULK OPENROWSET provider to allow you to pre-process the raw data...

well this compiles correctly, but it depends on the other procedure GetFileSpaceStats , which was not posted so far;

if the procedure...

this question i think you could have found directly from SQL Server Books Online or Google.

bcp AdventureWorks2008R2..MyTestFormatFiles format nul -c -t, -x -f myTestFormatFiles.Xml -T

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

there are two functions you can use to check the length of a string :

LEN(SomeField)

--or

DATALENGTH(SomeField)

both return integer values. I believe that your check constraint would have to use either...

Scott awesome job posting the table and data; it makes it so easy for me to test with!

Thank you!

someone poke holes in my calculations, but i keep getting 20 days...

Your response is very misleading...you said you were building an application in c#; that application is a Windows Application right? Based on that, I inferred you had some familiarity with...

if there are two tables, aliased W and T, i think it should look like this:

UPDATE W

SET

W.TableNumber = T.TableNumber,

W.LineNumber = T.LineNumber,

.....

UnitNumber = T.UnitNumber

FROM [LINKED SERVER].DATABASE.dbo.TABLE1 AS W,

[LINKEDSERVER].DATABASE.dbo.temporaryTABLE AS T

WHERE W.IdentityID...

every dataTable and dataSet in .NET has the ability to .ReadXML and .WriteXML.

you can add a .xsd DataSet to your project, and drag and drop an one or more...

ahh ok, then i think you can use dynamic sql to add the linked server.

you might want to drop and recreate each time, or use a if not exists(select *...

Richard maybe something like this:

the proc sp_tables_ex in a try...catch, if it fails to find the linked server?

i tested it with both a valid and invalid linked server name, and...