Loner (7/18/2008)

---

I also would have to agree with the premise behind this quote. Folks in IT tend to be logical folks who see a right way and wrong way...

It is BOL not LOB and stands for Books On Line.

How come thi statemetent does not work:

SELECT @StringColumn = (SELECT COL_NAME(OBJECT_ID(@TableName), @Counter) AS 'Column Name')

IF...

Carla Wilson (7/18/2008)

---

But all this said, I think it's time for me to brush up on my communication skills. In the past week, I've almost exploded twice. Thanks...

Since I have not used Access to modify a SQL table in a long time I'm not sure where it would be, but my gut tells me you should see...

This is not the best example, but does show a difference. Run this in AdventureWorks:

[font="Courier New"]SELECT

    M.Title AS ManagerTitle,

    E.Title...

So would...

You can add an activity directory group. You need to use the format domain\group (Domain\DB Admins) or use the Browse button and navigate to the group.

Kaushal (7/18/2008)

---

For large volume of data deletion, I always unload the data to be kept, truncate the table and load the data back. You can reduce your overall time for...

What is the recovery model of the database? If SIMPLE I would batch my deletes and issue a CHECKPOINT after each one which will cause the log to truncate,...

If I understand correctly DBAdmins is a windows group and it sounds like this group has not been granted access to the SQL Server. By default local administrators have...

Use the function SUSER_NAME() which will return domain\user_name for windows authentication and user_name for SQL Authentication. If you are using a generic sql login to connect to the database...

You could grant execute permissions on the dbo schema or create a role that has execute permissions on the functions needed.

Duplicate post. Original here

Please do not cross post.

In addition to what Steve said, I also find it easier to read because join criteria is separated from any filtering criteria. Also when using Outer joins placement of...

First of all it is not a good practice to have code in triggers that depend on services/resources outside the database or databases on the same server for exactly the...