My question is, is there any easy way to transfer existing files into a table that contains a filestream column?

We are currently using indexing services to do article searches -...

One more note: I know I could solve this problem by using multiple column or row grouping if I have aggregated my source data into these two types of counts...

I actually just found an article that verifies my concern over RSS feed.

http://www.cgisecurity.com/papers/HackingFeeds.pdf

Any suggestions on best ways to safeguard from the hacking?

I just tested and found out the login actually would work on SQL server even if I removed the delete permission to the underlying table. So most likely it's an...

On a different note about Left Join(Not related to the tests here), I have noticed that a Left Join with a not null filter in the Where statement outperforms an...

Jamie,

I resolved the issue by reinstalling the Enterprise Manager. Hope that works for you, too. Good luck!

Michelle

SysProcesses is in master db. You probably forgot to put the spid number in the query. Here's what the query would look like to run in any db (replace 60 with your own...

After a lot of hair pulling, I finally got this resolved

Here's how - just reinstall the Enterprise Manager, not the SQL server,...

Carlos, your theory of reversal proved to be right. It worked. Thanks!

Thanks, Kathy. That's a good way to go, especially as the number of my DTS packages grow, it'll be a good idea to implement tables like this. For the problem...

That sucks! But it's interesting to know there's at least a way to access the initial value in the child package.

Thanks, Erik!