Yeah, there are some high-order bits in the file

They look like spaces but are not...

If you copy the code into notepad you will see ?what look like boxes instead of...

The SQL Debugger that comes with ISQLW (Query Analyzer) uses DCOM. Becuase of this, there are a multitude of reasons the debugger "won't work". If a SQL Server...

We have the following separate SQL Server environments:

·Development

·Integration

·Staging

·Production

We do not allow anyone other than our DBA’s to modify the structures within the database. We rarely allow developers...

Of course you have to have the variable defined. The assumption is that on each server you would have a common environment variable defined that points to the backup...

quote:

---

I just need to create a windows system environment variable sql_backup_drive="X:\" for each SQL server and use it to determine the location...

One option is to use a derived table containing the key + max(ship_date) and then delete from your table the rows that don't match as so:

DELETE Orders

--select *

FROM Orders t

LEFT...

quote:

---

PC, you are missing out on a lot since dynamic sql used correctly can yield very good results. Although I did not...

David asked for an example of the UDF that was referenced in my previous post. But before you review the code, David said "It sounds to me like all...

Boy, you guys are brave!

I NEVER use dynamic SQL EVER in ANY Production system.

It does come in handy for 1-off utilities that I write and use myself.

For Queries...