Viewing 15 posts - 961 through 975 (of 1,160 total)
The Maintenance Plans available in the SQL Server 2005 does this without the need of writing scripts.
July 30, 2010 at 9:59 am
I could not find that info in any of the .xml/.ini files on DVD. Not sure how setup determines which Edition it is.
July 30, 2010 at 9:24 am
The "SQL***MemoryManager" counter in Perfmon will give you the details.
July 30, 2010 at 9:11 am
You may use xp_cmdshell to execute the command line parameters for the FTP command. Also you may try using SSIS
July 30, 2010 at 9:02 am
You may check which process is using that file using Process Explorer. Also you can add a WAIT/SLEEP value so that there is delay between robocopy and copy file process.
July 30, 2010 at 8:37 am
You have to use a custom query and (or) save it in a file. You may use the -I switch or -Q switch to call that query as an input...
July 30, 2010 at 6:07 am
Yes you are right. The ":" in your backup file is causing this issue. Without the : the backup should be fine. The ":" symbol is used only at...
July 30, 2010 at 5:31 am
I don't know what do you mean by the page size of disk. In SQL Server the page size is 8 KB.
July 30, 2010 at 5:26 am
Books Online is the best resource to get these details. However, you may refer these links.
July 30, 2010 at 5:12 am
Can you please try changing the start date of the job to today, for the ones which have very old start date?
July 30, 2010 at 3:57 am
You may try the "workaround" mentioned in this article. Even though it is for SQL 2000, it is worth trying.
Also could you try changing the start date of the job...
July 30, 2010 at 3:53 am
Please add an output file to the job (under Job Properties --> Job Step --> Advanced). This will give you the entire job run history
July 29, 2010 at 11:38 pm
RS.Open "Exec getStaffAppointment " & myStaffId, myStartDateUS, myEndDateUS,objConn
Modify this line as below.
RS.Open "Exec getStaffAppointment " & myStaffId & "," & myStartDateUS & "," & myEndDateUS,objConn
July 29, 2010 at 5:07 am
Since the requirement is to retain some of the data in the original database, the best option is to restore the backup provided by the vendor on to a new...
July 29, 2010 at 4:52 am
Viewing 15 posts - 961 through 975 (of 1,160 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy