SSWUG was initially created by Stephen Wynkoop on his web site, http://www.swynk.com. It was. at the time, the best source of information about SQL Server.  Low and behold, one...

As a long time VB programmer / SQL Server DBA, I would not use Hungarian for any object names is a database.  One of the biggest challenges I have faced...

Ah.  The joys of inheriting a database.

It sounds as if you have multiple issues. 

If I understand the first issue, the job is set to run as a user against...

A few ideas that may work.

What type of sql autentication is the application that you want the users to use doing?

For example, if the users are connecting with SQL authentication...

This is a shot in the dark, but this sounds similar to an issue I have run into with ADO.  SQL server can't figure out the specific row that needs...

Unfortunatly, I do not. 

Download the beta and try to create a table.  Then you can let all of us know!

Actually, there is a forum for SQL server 2005 on this site.  Post...

Keep doing it with option A.

You are asking for trouble, as well as potential performance issues, with option B

Been there, done that!

Unfortunatly, SQL 7 or greater will not allow a constraint between two different data types or two identical datatypes with different sizes, even if they are "functionally identical".

So, what you...

If you are using Windows Authentication and ODBC, your connect string is in conflict with itself.

Yours:

SQLServer = "DSN=" & maDB_LOC(intIDX).lrdata_dsn & ";SERVER=SQLSERVER;Network=DBMSSOCN;Address=10.0.18.5,1433;UID=" & strLoginID & ";PWD=" & Me.txtPassword

Mine:

Provider=MSDASQL.1;Persist Security Info=False;Extended...

I think the problem started when you got the "SIDS" out of sync between the master (syslogins) and database tables.  The user "sa" is mapped to dbo in each individual...

Sorry, slight misunderstanding. 

But, I still stick with my original thought that this is normal, or at least not unusual, after doing a reindex and a shrink.

Are your database file...

You may be confusing index free space with database file free space.

Index free space refers to the free space in each page of an index.  When an insert operations occurs,...

This doesn't sound like a SQL problem, it sounds like a Crystal problem. 

While Crystal is designed to simply "connect and create" reports against a database, it's notoriously slow if...

Transaction logging cannot be "turned off", regardless of the recovery model in place.

SQL Server issues a "checkpoint" every 60 seconds in the transaction log.  This interval can change depending upon...