fantom (4/11/2016)

---

I get an error that it cannot upgrade. These are the features that it is trying to update.

Database engine services

sql server replication

full-text and semantic extractions for...

Satiz (4/10/2016)

---

Phil Parkin (4/10/2016)

---

Satiz (4/10/2016)

---

Hey guys i tried...

Satiz (4/10/2016)

---

Hey guys i tried by using synonym...

jude.pieries (4/8/2016)

---

Happy days are here again. Thought i will share my pain with and success with rest of you.

So it seems, having expression in the connection manager does...

patrickmcginnis59 10839 (4/8/2016)

---

--snip

The downside is that you have to learn sqlcmd. I really like it because I can parameterize the heck out of it, and run jobs against any database...

Greg A Goss (4/8/2016)

---

Without knowing anything else about the application/process/environment, what if you created the stored proc in the order database (the one that changes names) and then reference...

Satiz (4/8/2016)

---

Phil Parkin (4/8/2016)

---

Satiz (4/8/2016)

---

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate it prod...

Satiz (4/8/2016)

---

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate it prod without making any...

Satiz (4/8/2016)

---

Thanks for your reply .I need to change this dynamically because database name differs in both staging and production environment so we will passing database name as a...

lorisj33 (4/8/2016)

---

Thanks Phil,

I'm testing it this way because I eventually want to wrap it in a for each file loop, reading each sql file and exe the code one by...

Presumably the Integration Services service is running on the server and you are able to connect to it from an ordinary SSMS session?

xqzuo72 (4/8/2016)

---

Hello, Phil, Thank you very much for your help! I am a beginner of SQL. I use MS SQL server 2014.

I tried your code and substitute...

xqzuo72 (4/7/2016)

---

Hello, I need to find out the unique values in each column from the tables in a linked server. I have about 30 columns and 30 tables...

Have a look here.

There's something special about that number.

JTSash (4/8/2016)

---

Thank you, Phil. Not what I was hoping for, but at least I know. SSIS is not something that I'm familiar with (and little time to learn...