I found a site that shows the option values for that command:

http://mesquiteit.com/online_help/kb/_1rl0v2p72.htm

Syntax:

DBCC checkprimaryfile ({'FileName'} [,opt={0|1|2|3}])

where

FileName is the primary database file to check.

opt=0 - check is the file...

I'm reposting this question in the hopes of finding a solution (my previous post never received a response.)

We are using a third-party software application on a SQL Server 2005 database...

Thanks for the reply, William.

Have you ever heard of a distinction between "SQL Server Native" and "SQL Server Standard" OCBC drivers? This seems to be the point of contention....

I have a correction to my post. The second odbc connection I listed as:

SQL Server (Version 2005.85.1117.00)

should be:

SQL Server (Version 2000.85.1117.00)

This was a good piece of information. I actually thought about adding the "USE" statement, but I thought that controlled where the SP would be created. Your statement...

Thanks for the prompt reply.

I actually performed step 1 and created the stored procedure at the Master level and added a job step to EXEC the SP. However, when...

Well, we HOPE to do auto deploys...it depends on how quickly I can figure out a solution to this. Ours is a very manual process in our move to...

That's a useful utility you have written. My dilemma is that I need to retrieve the scripts from a different server and run them from a job on the...

We're currently using subversion for our source control. When I mentioned source control in my original post, I really should have referred to our move to production process, although...

Thanks for the reply.

My comment about source control was misleading, and I apologize for creating confusion.

You've raised many great points about how this task is being approached.

The fundamental...

Excellent. Thanks very much for all the advice.

Thanks so much for the response and information. I will use the DBCC SHRINKFILE and report back on the results.

All I'm trying to do is shrink the log file to a reasonable size. Since the recovery model is Simple, there are no transaction log backups and I was...

I tried shrinking the file using the GUI option in Management Studio (right-click > Tasks > Shrink> Files > Log.)

The log didn't shrink, so I thought it couldn't be done....

I'm facing a similar issue. I have a transaction log that I am unable to shrink, as the recovery model is Simple on the database. This is not...