What are you trying to find from the log?

Andy

As you work on this remember connectivity is key - until you can ping the server, no point in worrying about the SQL part of it!

Andy

I agree - though proving it isnt the worst idea!

Andy

Plenty of stuff here on the site. Here are some articles I turned up searching for "login".

http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

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

http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp

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

Andy

No, it will always return the correct value. Compare this behavior to @@Identity which returns the last identity inserted for that user.

Andy

Profiler should work for this. What it doesn't capture is changes to NT user passwords or group memberships - but you can enable auditing in your domain to capture those...

Tend to agree about the proc names - thats the same reason I DONT use hungarian for property/method names in objects.

Andy

You could also look at replication as a way of doing this.

Andy

As far as CDO, you should take a look in the script library, might find something already made. If not, still not hard to write a wrapper around it that...

From what we saw at PASS in Feb looks like the next version of SQL will have an integrated EM/ISQL tool and it is supposed to include support for .Net...

In my opinion a better way to do this is to use CDO to send the mail so that you can set the from/to options. Changing profiles back/forth could cause...

The reason its optional is that you can set the name separately & before making the call to the start method. The optional parameters on the start method let you...

Try:

oSQLServer.Start vbFalse, strSQLServerName

Andy

DTS will let you import DBF files with no problem. Not sure what file format the accounting software uses. If its one of the ones supported by DTS you can...

You have the option of using a DTS solution like a global variable, or moving all the DTS code into your VB app so you can parameterize it how you...