Try

D:\readpga>c:\mssql7\binn\isql -Sclarcombe -dpga -Usa -P -w256 -h-1 -Q"exec AGGT_INRUNNING '''SCORE'''" -oaggtscoreir.htm

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...

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...

No. If the AD group has a login , then the user will have access (unless they are denied).

sp_help_revlogin on the MS Technet site can script out old logins that you can transfer to the new server. DTS has a "TRansfer Users" task as well in SQL 2000.

Also,...

We see similar ones on our DB2 machines at times and usually use the IDS to trace back where the source is and use a firewall to block the IPs...

Using Mozilla 1.5 here and I see standard HTML. Reload doesn't bring in the Active X control, but otherwise works fine.

Will a view not work?

If not, then a trigger might be the best way to ensure things are up to date. Set up one for inserts, separate fro updtes, third...

I'm thinking the same thing.

I think you'd have to do fulls periodically. At least to keep recovery.

If you do the file backups, then you can probably restore these, ignoring the logs, but it would...

Tend to agree, don't like to see threads closed. If the suggestion worked, let us know, but I like to have others be able to continue the thread if need...

Interesting question. I assume that the Verify backup does just that. Personally we take a slightly different tact.

Each day the backup file is named with the time it starts are...

I'd use a central procedure that takes the parameters and then calls one of 10 or so subprocedures that performs the search. Seems like a pain, but you set it...

Not entirely sure, but I'd say 3rd party app as well.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I believe it's a byte issue, 256 possible values, -1 for no indexes (0), -1 for clustered (1), maybe a few system items, 255 might be locked out.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best...