This is loosely related, but are any of you running SQL Server in a Windows virtual environment on the iSeries. This would be a i5/OS V5R4 config. I...

Stu Boy -

Sounds like a waste of time to me. Security should be set up at the server/database level and at the folder/file level. I did something similar...

Copy Blat (www.blat.org) files to system32 folder then create a DTS job that spits out the Body of your e-mail into a text file (or you can just add a...

Logs were very specific and helpful. OS errors stating "Access is Denied" on the data and log files. MSSQL errors also mention not being able to locate files.

WOW!!  Very nice.

One of the problems I've run into is the size of the fact tables.  This is with a with a web site doing 70+ million hits per year.  I've found...

Watch out for default collations on the new server.  That one got me recently b/c I like to use accent insensitive (AI) and the SQL 2000 default is AS.

Here's what I got for a query plan response...

Server: Msg 8623, Level 16, State 1, Line 1

Internal Query Processor Error: The query processor could not produce a query plan.  Contact...

hbatra -

I have just developed a C# app that does exactly what you explained (ie, writes from an MSMQ queue to a SQL Server table).  Do you mind sharing how...

PRB: Indexed Views Can Be Created on All Versions of SQL Server 2000

The script should look something like this...when you parse it, you shouldn't get an error.  Whether it runs correctly is a question of having your database, table and schema correctly...

The essential question is whether or not to read this fairly simple data from an XML file or from a database.  Prior to implementing a new FAQ system, the data...

Annoying that a closing parenthesis by itself turns into a winking smiley...

RptCount int

This doesn't include the Else...Insert statement, and this is in reference to summarizing about 50,000 rows every night, but here is my question:

If I choose the IF EXISTS...