They need to have privilege to view, update,create table...etc. This outsource company is the developer of one of the software we have and they need to access the database...

Kelley,

We are very sure that non of us (we are only four people whom able to create and access the server physically and create or modify SP) generated script to...

Dear Remi,

We checked all the jobs and there are no one contins a script to drop and recreate SP. What I am looking for right now is kind of a...

Dear Kelley,

let's assume that some body dropped those SP (which is impossible) how can you explain the change of the creation date for the rest of SP.  You may say...

Dear Kelley,

we are the only four in the company whom have administrator permissions. the rest of the employees access the system via the in-house custom application with limited user access....

Thank you Kelley for your response.

the answering to your question is no. No body ran a script to recreate the sp. Beside we are only four people whom have...

Thank you so much.  When I copy the Template Folder to the drive root and repoint the query analizer to the new location, the template will show up in the...

Hello,

I did check the template file extension and it is set to *.tql beside that I logon useing even sa account.

looking forward to hear from you

First of all Thank you for your reply. Also, I would like to apologize if I did not make myself clear. I do know that we see the answer right...

09/092004 Mr. Desiree Harris posted an areticle with the follwoing title " Sending SQL Notifications with CDOSYS at http://www.sqlservercentral.com/columnists/dharris/sendingsqlnotificationswithcdosys.asp

I have been using it since than and this  script is...

Hello every body,

First of all thank you for your response and for helping me understand the different between Diff and log backup. However, I still have one more question. Does...

adding to what Enthusiast mention, at home try to register your work's sql by using the local ip address in stead of server name.

in your previous message you mentioned that when you run xcopy statement from command prompt window the statement executed successfully. I am not sure what causing this statement to run...

Try to map the resource folder in the distination server which is the one will run the script and give it a letter like H then use the script as follow

USE...

I will use xcopy instead of copy command.

try the following:

exec xp_cmdshell 'xcopy "\\server1...\aspstate.mdf" "\\server2..\data2\aspstate.mdf" /s /e /y' 

Also, I will make sure to map the resource directory in the...