This is corect. All the changes in SQL are considered a single transaction if this is one statement. This would be an implicit transaction.

Steve Jones

steve@dkranch.net

that is the correct behaviour

Steve Jones

steve@dkranch.net

You ought to if you can get a MAPI client, like Outlook, to send.

Steve Jones

steve@dkranch.net

Here are a few links:

http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/tips/storagen.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/tips/storagen.asp

Steve Jones

steve@dkranch.net

xp_cmdshell - takes rights of the SQL Server service. This means that the command is executed as if the SQL Server Service account logged into the server, opened a command...

I see this occassionly on my W2K/SS2K server. Actually I had it the last two nights. The server is across a slow link fro the domain and it seems to...

In line with that, be sure you have mixed security mode selected.

Steve Jones

steve@dkranch.net

My 2 cents:

1. I'd have the user "submit" a request to create dbs. You can then have someone create the db (or automate this).

2. I'd give the users logins, and...

I usually see this error when my T-SQL code does something "illegal" in SQL. Like a divide by 0 (thought I think that actually throws a reasonable error).

Recheck the SQL...

Where are you getting this? EM or QA or somewhere else?

You might have some network problems.

I'd try it from the local console of the server and see what happens. You...

Start here:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q237980

Steve Jones

steve@dkranch.net

Did you delete from the NT/2000 GUI? Or from SQL?

There might be some setting that is trying to keep files in the recycle bin( like 3rd party sfotware.

Also be...

There are a couple ways:

1. Hack the system tables (master..sysfiles).

Shut down SQL, copy the files, restart SQL. HAck master..sysfiles to change the path of the files.

2. Make a script...

Server (remote): W2K Server, SP2 SQL2K, SP1

Workstation: W2K Pro, SP2 SQL2K Personal, SP1

Created package. One activeX task with the following:

Function Main()

msgbox("test")

print "test"

Main = DTSTaskExecResult_Success

End Function

Saved as "Test_Output"...

I am not sure what the problem is. I suspect your MDAC is not setup correctly. I ran your code, changing the server name and password only and it worked...