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...

When Starship Troopers first came out, I wanted to see it, since i had read the book a long time ago...

took my kids to see it when they were 8...

here is a simple model that might help: take a look a this thread on a similar subject, where limits were needed to prevent connections from anywhere but the "right"...

it seems to me that unless you want the name and phone number fields to be null, you have to join to another table (by ID?) to get those other...

The original poster says he has installed SQL server, but cannot connect via SQL Server Management Studio. He also wants to learn BI, but is just getting...

Please don't crosspost. It just wastes people's time and fragments replies.

(cross posting is asking the same question multiple times in different forums)

By checking Recent Posts>>Posts Added Today

other forum...

Not enough information, my friend; remember we can't see the query that you are refering in your question...you'll need to show us the query you started with, so we can...

I have this snippets saved which might help; it's using a pair of loops table to strip out any comments , so you can then search just the remaining proc...

it depends on the source.

any SQL statement that features a FROM Clause can optionally have an INTO NEWTABLENAME in it.

so the trick is to wrap BULK INSERT so it has...