You could use the QUERYOUT part of BCP to do this also. If you have a SP that puts the data into a temp table and then use BCP with...

I'm not certain I understand your problem correctly from your post but it looks to me like what you really want is all the records from the SB_PRODUCTREPORT and SB_PRODUCT...

Try looking at the TSQL for sp_spaceused and see where your script might be off. Also remember that if you haven't updated your statistics sysindexes might not be as accurate...

I've found that BCP is a bit limiting when using unicode characters. I would either use a linked server and transfer the data across the linked server or use a...

Hey Steve,

Why did you do a right join instead of Left? I almost allways do Left Joins as I like to have the "Main" table first in the join clause...

Christy,

as sholliday stated you really don't want to use SELECT * FROM in your app. It will come back as a bug later on.

Also, sholliday said "

-------------------------------------------------------------------------------------------

7) It says...

This sounds to me like a scenario for merge replication. What kind of latency is acceptable? Do you need to be able to modify data on both servers? If not...

Thanks for taking the time to write the article Steve! As for the email notification I personally ALWAYS ask to be notified. I do this as if I don't get...

Since you are already logging to a table simply create a job that periodically BCP's the log table to your text file.

jkeepi,

without knowing how you are storing the data it is a little hard to answer this correctly. However it looks like you may be adding records to the tbl_user table...

You might look into the ISNULL and COALESCE functions to see if they would do what you want. IE:

Assignment.fk_staffid LIKE (ISNULL(@x,Assignment.fk_staffid)

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

In Enterprise Manager go to the Jobs node and right click it. Select "All Tasks/Generate Sql Script" and go to town.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

More than likely the problem lies in the outer join. Without knowing more about your data it is really hard for me to know how to write the query. Also,...

Here is a Single step version.

DECLARE @v varchar(30)

    , @iLastHyphen int

    , @iLocationFromEnd int



SET @v = 'peer-3255-Organizational Skills'



SELECT SUBSTRING(@v,LEN(@v) -...

Hmm... My BOL doesn't just state that about error 2627. What it also states is:

Invalid identity information can cause error message 2627 when a primary key or unique key constraint...