Viewing 15 posts - 211 through 225 (of 327 total)
I have a VBScript (uses DMO) that will script out a 2000 server and I believe has what you need. In essence, it creates a script that will build an...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
October 18, 2006 at 7:14 am
A "tail log backup" refers to this situation:
The database has a failure and isn't usuable. You would like to be able to restore to the point in time just before the...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
October 6, 2006 at 7:01 am
I created a few stored procedures for Maintenance on SQL Express and execute them via the Windows Task Scheduler and an OSQL command in a batch (command) file. Works fine....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 25, 2006 at 6:14 am
GilaMonster, thank you for the explanation. I would like to read the article on the technical details.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 22, 2006 at 5:44 am
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 21, 2006 at 8:39 am
have you been here:
http://msdn2.microsoft.com/en-us/library/ms143706.aspx#runtime_installing
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 20, 2006 at 8:21 am
There is, or was, (I think it's part of SP1 now) a backward compatibility kit that will allow you to view and run DTS packages. It also has an upgrade...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 20, 2006 at 6:40 am
The only way I know of is to stop and start the SQL Server service.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 21, 2006 at 6:03 am
CBaptiste - thanks for your reply - I have most of it done in VB.Net already.
Our developers use a variety of tools. Fortunately, the syntax for creating database objects hasn't...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 1, 2006 at 3:42 pm
Thanks for example. I am in no way a VB coder let alone a VB.Net coder. I was hoping to not need to read the disk file into a command,...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 1, 2006 at 10:35 am
Our development teams use Source Safe for code control. When a stored procedure(s) is ready for release, they will send us (DBAs) a list of the procedures that are to...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 1, 2006 at 7:19 am
For SQL 2000 it is SA unfortunately. SQL 2K5 doesn't require SA.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 20, 2006 at 7:39 am
Just a PS to this item:
The Backward Compatibility feature lets me capture all the things I need. using VBScript and SQL DMO. I would imagine that this feature won't go away...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 12, 2006 at 12:22 pm
As I said, I inherited the script and I don't know much at all about scripting. This is what I get:
Set svr = CreateObject("Microsoft.SQLServer.Management.SMO.Server")
'Server svr = new Server(); this...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2006 at 9:32 am
Thanks Brian, I appreciate it. I already have a VBScript that uses SQL DMO to script out all the objects. I need to convert that to SQL SMO and the...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2006 at 9:01 am
Viewing 15 posts - 211 through 225 (of 327 total)