Viewing 15 posts - 38,371 through 38,385 (of 39,456 total)
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
January 8, 2002 at 11:36 am
Interesting. I use msgboxes and debug files in DTS to write out execution to a text file.
Steve Jones
January 8, 2002 at 11:33 am
January 8, 2002 at 11:32 am
Viewing 15 posts - 38,371 through 38,385 (of 39,456 total)