You are welcome. That's a handy one to keep in mind.

Steve Jones

steve@dkranch.net

Not easy. You'd have to build a SQL join for each column you need. USually this is done with dynamic SQL as

select emp.emp-code, b.time as b.date, c.time as c.date

...

You can in T-SQL, but it's an ugly mail message you have to build. I too wish MS had included this.

Send it to sqlwish@microsoft.com

Steve Jones

steve@dkranch.net

When you use Windows Auth, the windows credentials (essentially a token) are passed to SQL Server, which then verifies this with a DC.

First, it's a security risk across the Internet...

Antares is correct. When you execute certain stored procedures (system ones) permissions are rechecked for security purposes. I think the solution proposed above is a great one.

Steve Jones

steve@dkranch.net

If it doesn't have to be realtime, then I usually insert the data into a table and have a job come create those users every minute.

I had a similar issue...

Couple things:

1. You do not need to stop SQL to detach or attach. It is an online op.

2. I would just do the log files, be sure you adjust the...

I cannot speak directly to your issue, but I am wary of having servers that communicate on different Service Packs. I would plan on mirating them all to the same...

I tend to agree with your decision. This will be complicated and I'm not sure we can answer your questions thoroughly or quickly enough.

Basically though you will need to implement...

SQL 2000? If so, you can use a dyanmic properties task inside the package to get your parameters. Otherwise, I believe you can pass them in from a command line,...

I'd use normal database roles and apply the security you anticipate based on roles. Then simple SQL Auth for the users and assign ALL users to a role.

If you need...

These are MS procedures. Shouldn't be an issue for you.

Steve Jones

steve@dkranch.net

You could run profiler, but that might result in gobs of information. I would expect that shared locks were being placed on the perm tables. You should be able to...

da nada

Steve Jones

steve@dkranch.net

Tend to agree with Andy. BOL, while not always accurate, does provide a nice reference point for someone to check in addition to the post. I just wish we could...