We have a lot of bulk inserted databases. We set most of them to just SIMPLE recover mode. SQL Server still writes out some information to the transaction log, because...

Reading though your log there it seems that you are trying to access MSDE to check something, before MSDE is started.

Starting custom action UpgDetectBlankSaLogin()

Entering Function MyMsiEvaluateCondition

MsiEvaluateCondition for VersionNT returned TRUE

End Function...

You can use #TempTables (Created the same way as you create a normal table, but with a hash (#) symbol before the name). The temptable is then visible only to...

True, TIMESTAMP columns are altered everytime an insert or update occurs in a row, however, they are NOT a datetime value.

A TIMESTAMP column can tell you in what order...

Where is the job run? What type of job is it? Is it a SQL Server Agent Job, or a .bat file ?

SQL Server Agent Jobs have a Target Server...

SET PARSEONLY  ON

When SET PARSEONLY is ON, Microsoft® SQL Server™ only parses the statement but does nto execute it.

The setting of SET PARSEONLY is set at parse time and...

Precheck your referential integrity before your second insert with a IF EXISTS. eg:

IF EXISTS (Select * from primarykeytable1 WHERE typeX = @typeImAboutToInsert)

    INSERT INTO foreignkeytable1 ....

ELSE

    GOTO ERROR -- The...

Hey Adrian

A faster way to do:

SET @dtToday_midnight = CAST(DATEPART(yyyy, @dtToday) AS VARCHAR(4)) + '-' + CAST(DATEPART(mm, @dtToday) AS VARCHAR(2)) + '-' + CAST(DATEPART(dd, @dtToday) AS VARCHAR(2))

is

SET @dtToday_midnight = CAST(CONVERT(char(8),...

Money Datatype always has four digits to the right of the decimal place.

Jan's example above of using DECIMAL (x,2)  will reduce the number of decimal places.

Permissions are stored in the sysprotects system table in each database. The Action column defines what type of permission (SELECT/UPDATE/CREATE TABLE/etc) is being set. Read SQL BOL for more details...

Permissions are stored in the sysprotects system table in each database. The Action column defines what type of permission (SELECT/UPDATE/CREATE TABLE/etc) is being set. Read SQL BOL for more details...

Timestamp is NOT a date or time, but rather a semi-sequential binary incremental number that is unique database wide. Infact in SQL 2000 timestamp is more correctly known as rowversion.

As...

mmm system table editing..... <insert disaster here>

sp_addlinkedserver allows you to do basically what you are already doing here, have a linked server name point to a different data source.

Using EM,...

use oFile.Move() with the full path to move the file.

use oFile.Name = with only the new name (not the path) to rename the file. 

Hmm. Well if you are using well structured XML you might be able to use SQL XML to import it into native tables and use FOR XML to export it...