You can redistribute SQLExpress/MSDE for this purpose and use merge replication or custom scripts to make data synch up with a central server. The downside is limitations on size with...

What does your trigger look like? If it is set properly there should be no way to add new rows without capturing this.

You might need to trace EM and see what it is pulling. I suspect there might be a big somewhere or it is pulling from another location, like the original...

Maybe a TOP 1 from sysprocesses?

I'd think you could use suser_sname() for the user name. For the MAC I think you are stuck with sysprocesses.

If your connections are from AD authenticated machines/users, i.e. employees, you need a CAL for each user that accesses the machine. Usually when you purchase SQL Server, you get a...

As far as I know, you can determine if a clustered index and therefore the table data is on a filegroup with this script:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1499

DTS or linked server would be my suggestion.

SSC

If you really need clustering, be sure that you benchmark your 30 servers and have enough hardware to support it. The clustering, unless you are geographically dispersed, won't give you...

I think there would be some gas savings, more it would be a personal savings for lots of people. As for the environment, avoiding those plane trips would save way...

My final solution was like this one:

Sue Andy Brian Steve Kevin

Blue Yellow...

First, I have some thoughts here: http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

second, I would always have a team interview. Put the candidate on one side of the table and the whole team, whether 2 or...

I've run both on the same XP machine and W2K3 server. The uninstall is definitely something to be careful of as there could be some dependencies. They should be separate,...

Pls don't cross post. We check all forums.

Yes you can do this. Do it just as you wrote it, perhaps using a parameter instead of the scalar value 100.