In the past I have used temp tables or table variables in this situation reasoning that it is usually going to be better to hit the big table once. ...

Stewart Joslyn (11/16/2007)

---

I think we're still technology fixated - you don't need a pen drive or any other IT hardware to steal a few social security numbers or bank details...

I'm a little late on this discussion, but I would agree that most IT "Consultants" are really contractors. I view a consultant as someone who has the ability to...

I just had this discussion with a co-worker yesterday. I started with SQL 7 which in reality met and continues to meet most of the needs they organization I...

Paul,

Please post what you find out so I can add to my "tool box".

Thanks

To the best of my knowledge, the only way to get information to a trigger is to have the information in the table. Here is an idea on how...

Yes

** cannot view schema (cannot connect to the SQL...

What is the size of the backup file? The next thing is to try to restore from the backup file (on another server or to another DB on the...

This is a drawback in SSRS as there is not a way to set paging based on records. If you are doing any grouping you can set each group...

While this will work, is easy to read, and provides...

David McFarland (10/19/2007)

---

Jack Corbett (10/19/2007)

---

I really enjoyed the thread. A lot of good information and no one got personal as I have seen happen when people have different ideas...

I am just trying to connect using the following command

c:\>sqlcmd -E

I have another sql server where this command works. The second sql server fails with this command.

However, if I use...

Just a couple of comments.

I really enjoyed the thread. A lot of good information and no one got personal as I have seen happen when people have...

Steve,

Thanks for the reply. I was under the assumption that by using union all from the 2 tables in the view that the schema permission would only allow...

I am not sure I understand your problem. What is the code you are running that does not work? Because running sqlcmd -E -S.\Server is connecting to the local...