Little off the path for us. I'd recommend trying an ASP specific site, or even maybe the company that wrote the GhostView app.

Andy

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

No, it should stop ok. Usually when odd things happen its permissions, running from a job is usually a different account than when you run manually.

Andy

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

Usually not too hard to do. Start by saving out the package as VB code, then look through to find exactly where in the code the property is getting set...

You can do it in EM. Other than that you can do it yourself by bcp'ing the data to a temp table, altering the table to be the way you...

The first time, yes. After that you'd have the procs and you can always create them manually anyway. Not sure why it matters? Maybe I dont understand totally what you're...

If you tell it the subscriber already has the data you won't have to deal with the updates. I'd recommend breaking it up into two pubs, the first being all...

Sure, sp_password.

Andy

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

No built in way. How about a job that sends a reminder to someone to change the password? Or you could have it change the password forcing someone to reset...

You can run a job that will do DBCC Shrinkfile to free up the space. Both are typically set to grow by 10%, so some growth is the result of...

Or just update sysjobs directly. Or maybe backup msdb prior to the test, then restore afterwards?

Andy

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

I wouldnt worry about changing your style too much - just try to put yourself in the readers shoes if you can. Dont know that I succeed at that myself!...

Disk permissions are ok where the catalog is created?

Andy

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

See if this works. Look for a follow up article in the next week or so.

Dim oserver As SQLDMO.SQLServer

Dim oLinkedServer As SQLDMO.LinkedServer

Dim oResults As SQLDMO.QueryResults

Dim oLogin As SQLDMO.LinkedServerLogin

Dim J As...

Shouldnt matter how they are created, just do:

set rs.activeconnection=nothing

Andy

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

We have a system in one app that is not bad. Keep all the authorized users in one table, it has a series of bit columns called RoleThis, RoleThat. If...