Viewing 15 posts - 35,431 through 35,445 (of 39,720 total)
dbcc checkidentity will allow you to reset the seed for the identity column.
January 6, 2004 at 6:01 pm
I like your method. It's simple, fast, almost bulletproof. Other methods will be more complex and have more places for things to go wrong.
The biggest issue is to be sure...
January 6, 2004 at 5:58 pm
I'd do this in two steps in DTS. First import this into a table that just moves the data. Easier this way.
Then setup a stored procedure that selects the top...
January 6, 2004 at 5:51 pm
January 6, 2004 at 11:04 am
Are you saying EM is slower than QA?
Does 8 seconds really matter? I'm sure you'd like an answer, but I don't have one. At times EM is slower or faster...
January 6, 2004 at 11:02 am
I knew someone that tried it, seemed to work. Chris Hedgate wrote an article (http://www.sqlservercentral.com/columnists/chedgate/sqlandjavagoonadate.asp) on it. I'd email him and see.
January 6, 2004 at 11:00 am
Still in Yukon Beta 1 BOL so I'd guess yes.
How do you use this?
January 6, 2004 at 10:53 am
Don't use it here, but the MS Operations team uses it extensively for the MS.com site. If this is an issue, I'd bet that custom scripting is used to get...
January 6, 2004 at 10:49 am
LIKE
create table MyTest1
( myid int
, mttxt text
)
go
create table MyTest2
( myid int
, mttxt text
)
go
insert mytest1 select 1, 'This is a test'
insert mytest1 select 2, 'This is a test2'
insert mytest2 select 1,...
January 6, 2004 at 10:48 am
Try
D:\readpga>c:\mssql7\binn\isql -Sclarcombe -dpga -Usa -P -w256 -h-1 -Q"exec AGGT_INRUNNING '''SCORE'''" -oaggtscoreir.htm
January 6, 2004 at 10:37 am
This is some crazy error that we havne't been able to track. Seems about 2 in 10 here with IE 6 as well. With Mozilla (1.5) I don't get the...
January 6, 2004 at 10:35 am
I see this periodically and usually change all jobs to be owned by "sa" to avoid this. It's got to be some type of domain authentication issue, but it's so...
January 6, 2004 at 10:33 am
No. If the AD group has a login , then the user will have access (unless they are denied).
January 6, 2004 at 10:30 am
Viewing 15 posts - 35,431 through 35,445 (of 39,720 total)