If you need to do row processing a cursor will work, or you can right a "fake" one using select inside a while loop. I'd suggest backing up and having...

I dont use it often, usually just as easy to put up a simple *.asp. For those following along, here is what we find in BOL:

The user must have SELECT...

Typically the identity columns dont get passed over to the subscriber. Makes sense since you want the data to match. If this is how your set up is initially, one...

I've never tried to do it, have you looked through BOL? I think you can change it by bcp out/back in. I always use case insensitive to start with, then...

Havent tried it. Could you post the output of select @@version?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Good question. Don't know! I'd say either just test to see since it should only affect your local machine, or you can use a tool like RegMon to track registry...

You can use the output of a proc as the data for an insert, like this:

insert into tablea(col1, col2, etc) exec sp_spaceused

Just need to build a table to match the...

Im running same set up with no problems. Is SQLMaint.exe showing up in the Win task list? If it is you should kill it. Could also try running sqlmaint manually...

I'll try to research a little more. Only thought that I have right now is maybe the terminator is case sensitive?

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think its worth doing just to discourage casual tampering...if that matters. In general Im not found of any app that uses stored procs that I cant edit.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Man, I'll have to stop posting code that has bugs in it! Put in a debug.print to confirm that the CommandTerminator property is "GO".

Andy

http://www.sqlservercentral.com/columnists/awarren/

I would recommend using a role even if its only one person. That person may leave eventually and be replaced, need to authorize a second person, etc. With a role...

Thats the right answer. The ID associated with the login will be different when you restore. You'll only see this problem with sql logins, NT logins are treated differently.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I'd start by trying to get the MDAC to install as a stand alone. MS also has an MDAC Component Checker on their site which might be useful.

Andy

http://www.sqlservercentral.com/columnists/awarren/

We're actually in the middle of looking through that. Yes, we have partnered with Amazon so step one is we're going to leverage the web service they published recently to...