Using EM?

Hi Sherri,

Sorry it took so long. I set up three dbs to some testing, first db with a transactional pub to the 2nd, a merge pub on it to the...

Hey Richard,

Thanks for reading the article and taking time to comment. I can't really argue that using recursion probably takes more resources, but I think you'd have to a REALLY...

I'll be curious to see how this works out too! Go Steve!

Andy

The script Steve referenced is terrific. A cheap hack is to detach the db, delete the log file, then use the sp_attach_single_file_db proc to reattach, it will generate a new...

You've got two different things to test. One is the upgrade, the other is how your apps perform. It's been a while since we upgraded from 6.5, but the wizard...

Steve's suggestion is a good one. Plenty of reasons to upgrade to SQL2K and XML support is included.

If that's all you need though, just remember that an XML document is...

Hey, I just profiled it a couple times, then changed the identity setting via EM several times - looks like it does drop the table each time, but at least...

Well, if the problem happens from the VB app then it's not IIS (though the 60 second thing is damn coincidental...be suspicious anyway!). Are they setting a command and connection...

I think you have to focus on advancing your skill with one or the other - its a lot to master. Without knowing exactly the level of your skills now,...

I havent tried that combo, but I cant think of a reason for it not to work. Merge replication basically uses triggers to track the changes - so no matter...

Once you move it and restart successfully, you can just remove the old temp.mdf.

Andy

BOL says this about alter table:

ALTER TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are...

With a sql login you can connect without a problem. For instance, to upload articles to this site I run an executable on my workstation at home that connects using...

Both are good solutions. Had never thought about it, but was surprised there was no sp_helptable type sp.

Another way to get the list from an existing stored procedure would be...