An undocumented procedure is a procedure that is distributed along with the database engine, but is undocumented. Since it is undocumented, there is no guarantee that Microsoft will continue...

Steve,

Thanks for the post. As the author of SQLCop, it's very informative for me to know which tests you find interesting and which ones you don't.

When running SLQCop, it's...

I wrote SQLCop a couple years ago. SQLCop can also detect whether Instant File Initialization is enabled.

Download SQLCop from http://sqlcop.lessthandot.com

Run SQLCop

Log in to any database on the server.

Expand "Configuration"

Click...

I own a software company that has a niche product. A couple months ago, we released an update that requires SQL2005. Until then, we were compatible to SQL2000....

I found IBM's web page that describes compatibility.

http://www-1.ibm.com/servers/eserver/iseries/access/supportedos.htm

Hope it helps.

I had a similar problem with one of my customers.  They were using an AS/400 and my software uses SQL Server 2000/MSDE 2000.

There is a known compatibility problem with IBM's...

Thank you.  Your solution worked. 

I keep forgetting abount using inequality operators while joining tables.

Thanks Peter.  The Round function resolved the problem.  Before your post, I tried...

Update Table Set IntegerField=Convert(Int, Convert(Float, VarCharField))

This also worked.  Converting to a float, and then to an integer just...

There are 2 methods I have used to do this....

1.  Convert the field to a varchar and then do the comparision. 

Select * From Table Where Convert(VarChar(10), MyField, 101) = '08/04/2004'

When...

I recommend that you continue storing it in a DateTime field.  Use the Convert function when retreiving the value from the database. 

Something Like....

Select Convert(VarChar(12), MyDateField, 101) As MyReturnedFieldName From...

This is ASP 3 code, but it should be easy to adapt it to ASP.net

<%

Set Connection = Server.CreateObject("ADODB.Connection")

Connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AnyAccessDatabase.mdb"

Call Connection.Open

Set O = Server.CreateObject("ADOX.Catalog")

Set O.ActiveConnection = Connection

Response.Write("<table...

Is the logon account set to "Local System Account"?

You can check this by opening the services panel...  start/control panel/administrative tools/services

Find the "MSSQL Server" service and double click on it.  Then,...

Without more information, it is hard to say what the problem is. 

SQL Server has several authentication methods.  SQL Server authentication, Windows NT authentication, and mixed mode (allows either).  When...