nihal9200_kwada (10/11/2012)

---

Hi we are using Litespeed for backups. We got below error for full user db backup maintenance job. is this something network error.

and also after job failure I noticed...

Yusuf Ali Bhiwandiwala (10/11/2012)

---

Thanks Chandan and Chris,

Have already tried the OPENQUERY and the recent EXECUTE AT remoteserver feature (latter having the much needed ability to pass parameters) and both work...

ChrisM@home (10/11/2012)

---

The filter is being applied locally. You could use EXEC with dynamic SQL as Chandan suggests; I'd personally use OPENQUERY, which will also require your statement to be constructed...

OK. so this is how it is. When you hardcode a value in the query using linked server, you can find the correct filter applied at the remote server and...

I have understood your problem and I have faced it a lot of times and each time the solution has been depending upon the need. Let me spend sometime testing...

First you need to make sure if the linked servers are working fine and you are able to test them before you use them in your T-SQL queries.

Right click...

MSDB database has some built in roles which can be granted to a...

Can you provide an example of a task based on what you need.

In general if the data is distributed, you will have to use linked server or replication depending upon...

We keep backups available on our network servers for 15 days and then archive them to tapes...

stillconfused (10/5/2012)

---

Hi I am trying to import data from oracle to sql 2000 using dts package but unable to get all the tables.I am not even getting any error messgs.what...

Konuri Dinesh (10/6/2012)

---

Hey Pals!

I moved My MSDB database to another location. after that i tried to start my server but unfortunately it can't 🙁

i done it by following steps

step:1

SELECT ...

Exactly. Earlier when I just stepped in this profession, I though mirroring or log-shipping will take care of the job. But as you know, mirroring is almost identical to prod...

I have not gone through the script entirely but the part where you are generating an SQL command and then executing it.

If I were you, I would have simply generated...

As stated above, it could be parameter sniffing. If you have identified what procedure runs that cause the sniffing capture that parameter in particular that causes this.

Now, don't put...

I am glad that this worked for you. MSDTC options would be...