Viewing 15 posts - 38,356 through 38,370 (of 39,456 total)
yes. or whenever you create the table. If you are creating the table from Access, then use the table designer to change the key later in Enterprise Manager.
Steve Jones
January 9, 2002 at 2:02 pm
yep. hate that task. Unreliable IMHO. I stick to detach/attach or backup/restore
Steve Jones
January 9, 2002 at 2:00 pm
Something happened during install. This usually means the server is not running (that you are trying to connect to). Is it running? If so, then can you uninstall and...
January 9, 2002 at 1:58 pm
You can manually change this in the system tables, but it is not recommended. Personally I'd backup the db, drop it, recreate it as needed and restore.
Steve Jones
January 9, 2002 at 1:57 pm
January 9, 2002 at 11:01 am
Be careful in that someone could exploit dynamic sql as a security breech.
I just implement multiple stored procedures and absorb the workload.
Steve Jones
January 9, 2002 at 10:59 am
Interesting, but this still doesn't solve the key issue. Transmitting the key along with the data defeats the purpose to some extent. Any tool like profiler or a network sniffer...
January 9, 2002 at 10:55 am
January 9, 2002 at 10:54 am
January 9, 2002 at 10:50 am
January 9, 2002 at 10:49 am
Use the dynamic properites task to alter the query. You can write a SQL statement to build this query.
Steve Jones
January 9, 2002 at 10:27 am
Hate to say it, but running a job with a GUI on a schedule is a bad idea. You should rewrite the app to urn without a GUI.
Steve Jones
January 9, 2002 at 10:25 am
What about restoring from a backup and then detaching and replacing the last mdf with the current one? I think you are stuck, but I am reaching here.
Or not detaching,...
January 9, 2002 at 10:24 am
The Embarkadero tool ER/Studio can make a change to a logical design doc and roll that forward to multiple physical designs. You could have one physical design for SQL and...
January 9, 2002 at 10:18 am
API calls are not the only memory wasters. A VB app by iteself can cause issues. I'd tend to agree that the SQL box should remian standalone, though you might...
January 9, 2002 at 10:13 am
Viewing 15 posts - 38,356 through 38,370 (of 39,456 total)