I know how to do it that way I can also do the same thing in QA, however I'm trying to create an application that will allow users to...

We have been doing some work with PDA and using SQL Server. There are two different ways to transfer the data from the PDA back to SQL. I have included...

quote:

---

A better option than providing a shortcut to execute the DTS package, would be to setup the pacakge as a scheduled job...

Ya after I posted I relized that there were two spots where that was the case. Thanks it works great

Also what does the C mean in the following update

"UPDATE...

Well I keep getting the same error. Here is the DB detail. Where you see pingName is what I am considering the computer name:

Server: Msg 16924, Level 16,...

Are organization has been struggling with which replication to use. Are there any articles out there that have been written for specific replication architecture based on specific industries? We are...

Thanks, I end up figuring out. Would you also happen to know if there was a way to get the value from a global variable within a SQL task? Thanks

...

It was not checked; however after removing the single quotes and rerunning I still get the same Problems Once again I have successfully run this in QA

why in gods green earth would I want to start SQL in the command prompt???

quote:

---

First, you need to check SQL Server errorlog to see any error messages indicate why MSDB was suspended.

In order to restore MSDB...

The problem was that there was never an issue with not having enough disk space. I did set it to auto growth 10% (default) I have looked at books online...

I have realized that after recreating the DB on the subscriber that I had forgotten to recreate the full text index on one of the tables. So the Stored...

Thanks Steve, I actually fixed the problem. For some reason the file that my sql query was producing was dirty and some miscellaneous spaces in it which caused it to...

We are sending it to a 2000 server box from a 2000 server box

I tried it several more time but still no results.

I have tried that before and it worked. I just tried it again and it stills works..