CirquedeSQLeil (5/6/2010)

---

Skipping the tent and just going...

The safest and easiest way to license test/dev/uat servers is to purchase enough Developer Edition licenses for every one that can actually modify database objects in those environments. Users,...

It is there for whoever needs it, just be sure the hippo knows you are coming. 😛

IIRC, and you have the Enterprise Edition, you would use TDE, Transparent Data Encryption. Look it up in Books Online. After reading that, any questions, come back and...

Catch his...

Are you the DBA for the system in question?

True, the method I showed is open for SQL Injection as is, but there are defensive means of handling it. Being late, and not having access to SQL Server...

"Oh, please, tell me exactly what I need to do. I can't think for myself" said the OP.

You should be able to verify everythhing Jason indicated using SSMS without having to run any queries, just the gui interface.

You can check the login under the Security folder of...

rockingadmin (5/6/2010)

---

Hi

i have query that have input parameters in the where condition of dynamic sql. the problem is, i have 10 input parameters from application.

when data was inserted any of...

Still could have ued an answer to my question, it really is a vital question based on the sample data and expected output. More like a running division than...

CirquedeSQLeil (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

crookj (5/6/2010)

---

sing4you (5/6/2010)

---

Don't forget Texas. It may...

Trick is getting some of them to buy in. Sys Admins? Good luck, we can't even get them to tell us why our servers crashed, or where our...

kenneths-1139284 (5/6/2010)

---

I guess that could help with troubleshooting.

h.refID varchar(50)

s.DistributorOrd varchar(50)

WHERE s.DistributorOrderNumber is null should be ...DistributorOrd... still not working

the information is initially imported from the h. table into the...

Still confused, so here is some code. Work with it and see if it solves your problem. You may need to tweak it some, you didn't provide anything...