Viewing 15 posts - 38,626 through 38,640 (of 39,717 total)
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
I started as a network admin. Got a client-server app dumped in my lap that did not work and spent many, many hours babysitting this app to reboot the server...
January 8, 2002 at 3:57 pm
I prefer hard coded sql. That way I can optimize each query. Also, dyamic sql tends to remove some of the benefits of precompiled query plans.
Steve Jones
January 8, 2002 at 3:53 pm
1433 is the SQL Server standard as specified in an RFC. If you use something else, this is ok, but no expected behavior. AFAIK, nothing changes this except manual intervention.
Steve...
January 8, 2002 at 3:49 pm
January 8, 2002 at 3:48 pm
Viewing 15 posts - 38,626 through 38,640 (of 39,717 total)