No, my new package just refers to the old package, when you want to edit the old, it requires you to input the password.

@herladygeekedness: user can run it anytime not in plan so I don't want to use schedule

@P Jones: I want to use the simplest way, just install SQL Integration...

SQLKnowItAll (1/16/2012)

---

Sorry, I was getting pulled into a meeting as I was...

Could you please explain me why, I'm try that way, I can connect from my program and I...

Adi Cohn-120898 (1/16/2012)

---

You can create a DDL trigger for login and check if the specific login is using SSMS (by checking the value of app_name() and original_login()). If he...

Thanks a lot, it work well

Just funny that when I create SQL command from partition scheme in SQL Studio Management

The sequence of groups is not in correct order

CREATE PARTITION SCHEME...

Yes Sir

It's here

CREATE PARTITION FUNCTION [pfTBLTRANS_ID](int) AS RANGE LEFT FOR VALUES (1000000, 2000000, 3000000, 4000000, 5000000, 6000000, 7000000, 8000000, 9000000, 10000000)

CREATE PARTITION SCHEME [psTBLTRANS_ID] AS PARTITION [pfTBLTRANS_ID] TO ([GROUP01], [GROUP02],...

Do you mean clause

ALTER PARTITION FUNCTION ... SPLIT RANGE ( ....);

But I want to add more range, not split

Could you please give me detail SQL command of ALTER PARTITION...

OK, I see, thanks very much.

Dev @ +91 973 913 6683 (10/17/2011)

---

Yes, I don't...

Ok, I've done.

But I don't understand why when I create a new Transact-SQL endpoint, connect permissions for public are revoked for the default TDS endpoint and I have to reassign...

When I assign this user to "public" of master, and select for this log-table. I login successfully

But how can I define which login with correct password, which login with wrong...

Martin Schoombee (9/3/2011)

---

thang_ngo_2002 (9/3/2011)

---

I have an alert system based on SQL Server

When I use SQL 2000, I monitor an Oracle system by SQL DTS, DTS contains 1 transform "select 1...

I find out the issue, I forgot port parameter in connection string. Now it's OK. Thanks.

MysteryJimbo (8/24/2011)

---

You wont be able to...