Yelena,

Thanks, the presentation did go very well, although I had to cut a little material at the end on-the-fly since I did not have time for it. Got caught up...

The thing that I am constantly puzzled by is why everyone is so happy to do dynamic parameters (if by nothing else then at least using (faked) arrays and lists)...

I know of no theory that would support this implementation, but I can name one that says this is a bad implementation. How about the relational model of database management?...

4. Create 14 different stored procedures, the first one with one parameter, next with two parameters etc. Call the correct one from client app.

5. Use parameterized queries from client app...

You could create another view yourself, and specify WITH SCHEMABINDING. That way the other view (owned by the person who shall not be allowed to drop it) cannot be dropped...

If you are not logged in to the machine using the same account as SQL Server is running as, then there is most probably not an E: drive available for...

If I am understanding the requirements correctly then a DECIMAL(9) seems efficient, needing 5 bytes storage. But it of course means there will be conversion needed when working with it,...

Great, I'll keep an eye out. I'm also downloading June CTP right now, so when that is done and installed I can see if there is any change there. Won't...

Standard or Enterprise?

Edit: Extremely late.. Remi already posted the same.

The best way is to block access to the server using a firewall like I said, and then opening for SSH or similar. That way you can get a secure...

I do not have much personal experience with DTS, but I can provide some links I think could be helpful.

SQLDTS.com should probably have all the answers you need.

Regarding Integration...

If there is no firewall restricting access to the server then yes, anyone can access it from the internet. They will of course need to login as usual, but that...

This happens if SQL Server is restarted while System Monitor is open. You probably also have an error message in the error log that says something about failing to access...

I did a bit more of digging through BOL and found this on the topic about sp_dbcmptlevel, which is the system stored procedure for viewing and changing database compatibilit...