Viewing 15 posts - 36,481 through 36,495 (of 39,720 total)
Why can you not use an identity?
Also, does the number need to be generated in the select?
Steve Jones
March 3, 2003 at 5:11 pm
Kind of confusing. Can you provide an example of what you mean?
Steve Jones
February 26, 2003 at 10:24 am
xp_cmdshell 'dir c:' will get you this, but you have to parse.
Steve Jones
February 26, 2003 at 10:09 am
SP3 will upgrade MDAC to 2.71
No issues really. The application of the SP3 should not affect the SQL 7 instance.
Steve Jones
February 26, 2003 at 10:00 am
Shouldn't affect anything, but will be easier to read. (and type)
Steve Jones
February 25, 2003 at 1:22 pm
Part 2 will look at separate tables.
Interesting thought about the sequence table.
Steve Jones
February 25, 2003 at 1:19 pm
Not sure if the end users will get hit. Appears to be more for ISVs who resell code.
The articles haven't really run detsails.
A 2nd article at http://news.com.com/2100-1001-985359.html
Steve Jones
February 25, 2003 at 1:12 pm
Correct, no SP2 required.
Read the README and test.
Steve Jones
February 24, 2003 at 11:19 am
February 24, 2003 at 11:07 am
We have 2 TSM's here on AIX and both are used to grab the flat file that Litespeed generates. Backing up a db to tape isn't recommended anyway.
We just purchased...
February 24, 2003 at 11:04 am
Even with the middle tier app, I wouldn't have it set. There isn't a reason. The delay and ability to backup the file means that there is a chance the...
February 24, 2003 at 10:57 am
February 24, 2003 at 10:51 am
There isn't really a good tool. You can trap some info from Profiler, but really this is an admin function that you could use VSS/CVS, etc to do.
Steve Jones
February 24, 2003 at 10:26 am
Are these scheduled jobs? Do you need the DTS job to run on the other server or is the package on the other server?
If you need it to run on...
February 21, 2003 at 10:40 am
Viewing 15 posts - 36,481 through 36,495 (of 39,720 total)