I don't think the licence allows for multiplexing through a seperate device, I belive the device/user count is based upon the final end point of the connection regardless of the...

What I make out from that article is that if you were using per user licencing within a domain then each user would require a CAL but this would be...

I would just use the convert function, something like:

set

@tablename = '#BackupFile_' + convert(

From your schema I can't see where people are related to a role.

From what I can see you need a table that relates users to an application role.

Then you could...

One point to remember for reporting is that snapshots use more resources as records are only copied when they are modified. Also snapshots cannot be backed up, not good for your...

At a first guess, maybe some thing to do with the replication is firing a trigger, thus altering the value of the last identity created.

Are you using @@identity or scope_identity()...

For large databases and backups that are transfered over a network speed and size would be an issue.

Such as if you were copying the backups to an offsite location. That...

I suppose the worry here is if the attacker were to gain sys admin rights on the database. Then the whole permission system fails to work. This solution could then...

It looks like xp_cmdshell only uses the first line as the command to run.

I tried running a command using ^ (needed in the command prompt to split a command over...

To me that looks like one of two problems. The user's windows account doesn't have an sql login (got missed in the change over?) or the user is not connecting...

I personally like the idea of having all the procedures checked into source control and then just not allowing the developers access to the procedures on the server as they...

Your trouble is the way floating point numbers are represented in memory, which leads to rounding errors. An eqivelent to this is in decimal we cannot write 1/3 exactly as...

There isn't an setting anywhere to make it non-optional is there? Thus to alias a column you would have to write alias = column or column as alias.

I just create all the diagrams in visio using the reverse engineer function. Although at the moment I can only do this using the generic ODBC driver, anyone know when...

I have seen no way to achive this. Either the procedure needs to be rewrote to be a function, or the function needs to be made into a procedure