Viewing 15 posts - 39,526 through 39,540 (of 39,717 total)
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...
September 25, 2001 at 11:15 am
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...
September 25, 2001 at 10:31 am
September 25, 2001 at 9:47 am
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...
September 25, 2001 at 9:46 am
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...
September 25, 2001 at 9:34 am
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...
September 25, 2001 at 9:24 am
September 24, 2001 at 1:30 pm
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...
September 24, 2001 at 1:17 pm
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...
September 24, 2001 at 1:10 pm
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"...
September 24, 2001 at 12:19 pm
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...
September 24, 2001 at 12:08 pm
September 24, 2001 at 11:52 am
September 23, 2001 at 11:31 am
I have had similar problems with files being held open by DTS. If you run the DTS in EM and allow it to finish. Then close the designer. Then run...
September 23, 2001 at 11:30 am
September 23, 2001 at 11:26 am
Viewing 15 posts - 39,526 through 39,540 (of 39,717 total)