she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?

if the server was beefy enough to...

ok so you are after more of a console application to run at the command line; still very doable in .net, but you need a lot of parameters, which can...

BLM I've got a .NET project that i built that, among other things, is my Developer Report Builder;

I was re-inventing the wheel to improve my own skillset, and created...

thank you for the feedback! glad it helped you out!

homebrew I've got an old script contribution out there that takes every trace file that happens to be in the same folder as the default trace, and imports it into...

i worked in a shop where someone turned off auto update statistics, and with only 20 users hitting with an application, the database ground to a halt in less than...

dsohal (11/30/2010)

---

Hello,

Thanks for your help, I guess it is going to help me, just couple of things, I am trying this in my development environment right now,

1- How I can...

glad i could help! i had to do a search to find the reference you were talking about, where we participated in a different getdate() post a couple of months...

sure, if you can assume that *today* decides that you want the first of the current month; so if you run the report, witht hat condition, the date range changes...

learned something new today; thanks graham; didn't even know about the Registered Servers panel until this post. lots of options like automatic discovery of all servers on the network and...

InfiniteError (11/29/2010)

---

thanks for the responce,

honeslty, the exact thing that i want to do is to modify the date modifed column for a

stored procedure, and regarding the encryption, all i...

InfiniteError (11/29/2010)

---

thanks for the reply

Im sorry i use the sql 2005 keyword, the changes that i want to made is in sql server 2000, i google it and many said...

dsohal (11/29/2010)

---

Hello, actually I do not want him to connect using cnsuser, but on the otherside I do not want that if I add the trigger as above, I do...

==edit== too slow again....

it'll have to be a case statement i think:

SELECT

CASE

WHEN col01 = 1 THEN 'col1'

WHEN col02 = 1...

well then there is two parts to your issue:

you can do that with a login trigger...you can write to...