RESTORE LOG [Database Name] WITH RECOVERY

I ran using the bat file, which has slightly different parameters. I believe the line is

start /wait x86\setup\setupsql.exe -s -m -SMS -f1 "sql2kdef.iis"

Also, are you running while logged...

It seems that many of the vendors I work with are moving in the opposite direction. Many products used to work on your choice of several different database servers...

What kind of problems are you having? It's been a while, but I installed SP3a on dozens of servers with unattended installs.

Perhaps a better discription would have been Microsoft UDFs? Or standard UDFs?

UDFs are written with T-SQL and have some hard restrictions. I don't believe that built-in functions are...

quote:

---

My thought was to use a select query from the master database name column where dbid > 4 to make sure I...

It seems safer to me to issue SHRINKFILE against tempdbs log file and to leave the data files alone.

I believe that SQL Server aranges its columns in a certain order (fixed data length first, etc.). Thus adding a new column may cause the entire table to be...

I've never used a UDF inside a trigger, but I used SPs inside triggers all the time. Never had a problem.

What's your subselect, and what's the error?

Lumigent also has a product called Log Explorer. I believe you can download a free trial.

http://www.lumigent.com/products/le_sql/le_sql.htm

The nice thing about Log Explorer is that you can examine log...

It's been a long while, but I seem to remember performance decreasing when I upgraded from NT 4 to Windows 2000. Performance increased when I upgraded from Windows 2000...

You could insert your result sets into a temp table.

Unfortnately, often when a position is approved at a company, it is approved at a specific salary. Thus, they know how much they can pay before they start interviewing....

Insert into Zip

Select ZIP, City, County, State

From ZIP_CODE_IMPORT

Where ID Not in (

Select ID

From ZIP_CODE_IMPORT a,

Zip b

...

It seems like you could accomplish that without a function simply by using two queries. First execute your dynamic query, then execute your second query, using the local variable.

...