No probs - glad to help!

No probs!  Good luck

Hmmm... Try a google search with the imporart part of the error string - surround it with quotes in Google and see what you come up with.  I've read stuff...

I think it was SQL 7 that got very upset about changes to computer names.  SQL 2000 corrected this as described previously

From a performance perspective, if you are running code like

select au_lname, au_fname FROM authors -- returns 2 rows

 where contains(au_fname, '"Mich*"') or SOUNDEX(au_fname) = 'M240'

Try to have a calculated column that...

They are, for all intents and purposes, unique.

The link you refer to details what someone once described as the COMB - can't remember what it stood for or who did...

When you install MSDE, you must specify the DISABLENETWORKPROTOCOLS=0 command line option to setup.exe to allow network access.

To rectify this after installation, run the server network configuration utility for SQL...

Or if you can't install stuff on the unix machine, try installing Cygwin on your windows box (or get a native port) of gzip.  gzip is pretty much standard on...

Do you mean row lock vs page lock vs table lock?  Or do you mean shared vs exclusive?  Look up "transaction isolation levels" and "lock escalation" as well as "locking...

Plz don't cross post - answer questions in this thread...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=217021

Does your booking process go over several screens?  My local theatres have a system where you can pre-order your tickets over the net and even choose the seats you want...

Mapped drives won't work, as a rule, because they are made specific to a user account.  Just because your account in Windows - which may even be the one you...

Yes good point.

Try

sp_change_users_login 'auto_fix', USERNAME

where USERNAME is the name of the login/user you are using.  Does the login you use (SQL or NT) have access to the production server?

hahahaha

Careful, someone might lose their job if they took that back to their boss with a straight face only to find his...

As Shawn said...

What are you using to generate the PDFs?

Are some of your server defaults set differently?  (SET options)

Are any other parts of the DB working?  Eg searching, etc -...