Hi Jack,

Backup is SQL Native backup. about the MMC snap-in is it in EM?

All you have to do is to supply the necessary informations in this part of the scipt

--Set Values to the variables

SET @newpath_mdf = 'C:\put path here)\' --new path wherein you...

Actually our servers do not backup log files. when i arrived at the company they are set to full recovery but not backing logfiles. We decided to change the recovery...

Thanks Clive I was also advised by my officer about transactions not comitted to the database that cause the shrink to fail I think a full backup then shrink will...

If your in MSSQL 2000 or 7 try the script below but test it first on your testing server

/*************************************************************

Script made by : Lester A. Policarpio

Email Address : lpolicarpio2001@yahoo.com

Date Created :...

I think the 1st solution will not be applicable since he will not be permitted to install a client connectivity. I've read some articles about psexec I think this will...

Thank you very much for your help!! what values do i need to input in the server where I am connecting? do I need to copy the values in the...

Are the columns the same for the new and old excel file? you can try creating an excel file that will stand as your template save it to a location...

Mh (8/14/2008)

---

I have a simple question, I am trying to execute a storedproc the following way which has about 5 input parameters.

SQL:

Execute storedproc

Select col1,col2,col3,col4,col5 from #Temp

I am passing in col1,col2,col3,col4,col5...

"I think" it can be done using a tally table. Some experts here in the forum maybe can share something about it.

And also please read the article of The...

For your 1st question...

I am in a banking industry and hadling 40+ branch servers. I made a script which will run 1 query to the entire branch servers so whenever...

@vambati,@avipenina

Guys any feedback on the answers i gave you???

Can you post the trigger schema you created and the process of updating the link server?

What else do you need to monitor???

Angel Miranda Nieto (8/7/2008)

---

Hello to everyone, I try to explain my problem, i need with BCP utility put a file in remote machine, I writed this script exec master..xp_cmdshell 'bcp...