Recent content by lemosley01

Terry, Out of curiosity, is there a maximum statement length for select, inserts, etc?

Thanks Terry. I've read that before but glossed right over the fact the BOL says they cannot be used as variables. Guess the day hasn't been a waste. Lawrence M.

You can't do a full backup of a database after detaching it. You would need to do the backup of the database first, then detach it. Once detached, the database is no longer available and all you can do with it is backup that actual files the comprise the database. Rest of that seems fine, but...

Check for the table using IF EXISTS as in: if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME='Categories' and TABLE_SCHEMA='dbo' ) [DROP STATEMENTS HERE] ELSE [do other stuff]

See the text an ntext data types in SQL Books Online.

Try reapplying or upgrading MDAC and make sure you are logged in as an Administrator. If it's access you could upgrade to the latest JET release (SP3 plus a security rollup I believe) Perhaps you would be better served by posting your question in the ODBC forum

How about using cast/convert to convert to an integer.

Check the properties of Enterprise Manager (Tools | Options | Advanced) and see open console tree to last note option is on. This option exists nder SQL 2K, and I think under 7.0 EM as well

When the users connect you will see their NT account names, not the group name. If you want to see it in action for yourself, use SYSTEM_USER. Connect to the server as one of these users and run the following from query analyzer select system_user

BTW - showing the plan or even trying to display the estimated execution plan does not work either. When I try to use display estimated plan it returns the 'cannot use ntext...in order by clause' error. How exactly are you getting an execution plan against a statement that the server is...

Ran this against an Enterprise Edition installation that has SP2+Latest security rollup applied, and it failed (as expected). Maybe there was a bug in a patch that you have applied that was fixed, it wouldn't be the first time, but I kind of doubt it. Can you post the table DDL? Perhaps...

Maybe a sniffer will show something. Sounds like the target server is being shutdown or you have some network problems that are causing connection-loss. Have you tried backing up to a local drive, then performing a copy of this file (so you have it in two places)? That's probably safer anyhow...

What error does it return? I can't see how the execution plan should be different for different versions. If it is not supposed to work, then it shouldn't matter what the execution plan says. Are you *sure* that the field it does work on is an ntext?

System error 5 is 'access is denied' Whatever id is trying to load the driver doesn't have permission to do so. Check the securities on your system (maybe try auditing and see what that turns up). Since this is a web-server, I would be hesitant to start granting the id administrator access.

You can have only one primary key per table, so I assume you are talking about a composite key. If the StoreID and Store No. taken together are unique, then you could use these. If either column will always contain unique values, then just set that column as the primary key. If both column will...