Viewing 15 posts - 38,716 through 38,730 (of 39,804 total)
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
the account under which sql agent run is in the control panel/services. This account should be setup like a normal user in the Exchange server.
Steve Jones
January 8, 2002 at 3:45 pm
January 8, 2002 at 3:44 pm
if you have cookies enabled, check the box on the login screen.
There is a search button on the top of the main page.
Steve Jones
January 8, 2002 at 3:43 pm
Viewing 15 posts - 38,716 through 38,730 (of 39,804 total)