If you lookup RESTORE VERIFYONLY in BOL, the first paragraph states:

Verifies the backup but does not restore the backup. Checks to see that the backup set is complete and that...

Here's a quick, brute force way. It involves creating a table to map characters with ascii codes above 127 to other characters. You could create CharMap as a temp table or table...

Leeland,

All of the status numbers are shown in base 10 (decimal, our usual numbering system).

However, you will note that all of the numbers are a multiple of 2 because

they represent a...

You don't actually have a domain. WOOD and LAPTOP are either the computer names or the workgroup names. The easiest way to share the servers would be to change the...

Just to clarify - you need the exported data to end up as a dBase IV file for use with the digital mapping application? Can I assume that the mapping...

How are you creating the Excel file? If you've got the data in a datawindow, just use the SaveAs method and save it as dBase III.

string ls_filename

ls_filename = ...

dw_1.SaveAs...

I have to agree with Bill. While I happy for you guys, all too often I've seen an independent enterprise like SSC, following a take over by a commercial entity,...

When using UNC names, the format is \\server\sharename\...

Make sure to check permissions on both the folder and the share on server B.

You can verify/change the login mode by accessing the following registry key on the server:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode

1=Windows Authentication

2=Mixed Mode

Orders is my example table. If the whole script is run, it should be run in a test database on a development server, not in the production database.

That said, the...

Yes, you must restart SQL Server to see the name change.

It looks to me as if you want a running total sort by customer and date.

Something like this might help:

--DROP TABLE Orders

GO

CREATE TABLE Orders

(

  orderID int

, custno int

,...

I assume that your data has a very specific structure to it.  As Sergy pointed out, the test IF @Counter > 0 is meaningless, as it will always be true.

One...

First of all, I don't have enough information to validate your query. However, I would take an alternate approach and avoid using dynamic SQL. I assume that you are using...

Maybe I'm missing something, but why can't you do something like this:

DECLARE @db2query varchar(8000)

, @statement varchar(8000)

, @identifier varchar(10)

...