Cookies were required with the old software and we are running in a dual ASP.NET / classic ASP environment now.

We might be able to eliminate them in the future, but...

http://www.sqlservercentral.com/columnists/hji/trace.asp

I would agree with above. The suspect flag is just a bit setting in sysdatabases. If it keeps getting reset, then likely the issue has not been resolved and PSS...

Run profiler and see what is hitting the server.

Your only choice is a per CPU license. As soon as you authenticate anonymous users, whether directly, through a website, or using MTS, you must license per CPU. Only when...

Not sure since I don't use Log Shipping, but this message indicates that a log is being restored out of order. Or one was missed. I'd check there.

What type of replication?

Most books on SQL Server have a decent tutorial on getting started with replication. Brian Knight's SS2K for Experienced DBAs has a good explanation (ISBN:0072227885 )

The only real way to automate this is with a trigger. But the trigger can be really simple and update the same table as mentioned above, then load your "backup"...

You also need to be sure that you know why the database went suspect. Check the error log for a reason.

You can clear the suspect flag as well with

sp_resetstatus <db...

While we're not really looking at doing that for a number of reasons, can you list the issues with the new forums? It's a big change for me as well,...

I use a batch file (*.cmd) that calls

isql -S ServerA -E -Q"sp_password null, new, sa" >> change.txt

with a line for each server, add a server add a line, change the...

and for the select, if the owner is "dbo" then the parser automatically resolves this. If any other user owns the object, you must query as owner.object.

Might be hidden. Is this regarding an authors area?

Try the "Jump" box at the bottom.

Sorry , never tried this. I tend to work the things separately. I know in VS.NET it is completely integrated and the debugging crosses...

What if you split this into

select @newvar =  "@intDataChangeMode=" + cast(@intDataChangeMode as char)

print @newvar

Does it still fail? I'm curious to see if you can trace one execution under MTS with...