Viewing 15 posts - 38,371 through 38,385 (of 39,466 total)
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
Can you post the DDL for what you are intending. Not sure if a computed column will work without seeing some sample.
Steve Jones
January 9, 2002 at 10:11 am
I'd then move it to an archive table using insert ArchiveTable select ...
Steve Jones
January 9, 2002 at 10:07 am
I tend to agree with Chris. SQL needs some work in autditing, but the system admin account is not going away. I understand that people want to restrict the data...
January 9, 2002 at 9:54 am
Actually I use the filesystem object to create a handle to a text file if I have a debug flag set. I store the debug flag, the filename and path...
January 8, 2002 at 4:01 pm
January 8, 2002 at 3:59 pm
Viewing 15 posts - 38,371 through 38,385 (of 39,466 total)