I've had limited experience with this. I worked with a ASP.NET MVP that was consulting with us. It was generally for half days and only about one or...

First job out of college was 1h 5m because I didn't want to move from my rural home. Since it was work on a mainframe that I didn't like...

I know this is an old post but I've been looking for answer to this so I'm putting what I've found here for the next person.

Wish I could give a...

I like the idea... it's a two way street. Not only does it give the company a chance to see if you will work out but gives you chance...

We are running into this same problem. The problem happens when we run out of log space on a DB. Then the checkpoint is stuck on the DB....

Finally a SQL user group close by... Hope I can make it to the first one.

Ditto on this statement. If have to make a change that affects stored procedures that are not even used and proceed to change those time is wasted. A...

Seems to me that it would be less damaging if they would just raise the prices of both and be done with it. Maybe that's why I'm not in...

Wasn't 2005 Standard 2 sockets and not X number of CPUs. By the time we move to SQL 2008 we will likely be using 2 4 core processors. ...

I did not but I now have a better understanding of it... different object owners so it didn't seem to work. I didn't set it up before because I...

Thanks for the post. The sql is not dynamic. Here is the code in basic terms...

the view: select * from dbB.dbo.tblB

the sp: select * from dbo.tblA join dbo.viewB...

Good article.

I have a case where I need to pull data from another DB and created view on the same DB as the SP but I get an error "The...

Yes, I just ran it on our test server that has SP2 and it works fine.  We are planning to move to SP2 for production but just haven't got there...

Guess I was a little slow on that one getting through my head.  I understand now.  TheI was using to run the package was 32 bit so it worked but...

For some reason I didn't get the notify of your reply.

This is the command line that is generated when I successfully run the package on the server...

/DTS "\MSDB\rewDataToPromap" /SERVER BUZZ...