Forum Replies Created
Viewing 15 posts - 241 through 255 (of 327 total)
-
RE: Question of the Day for 26 Apr 2006
The choice of words was, in truth, a poorly written spec. It left way too much room for assumption. My "assumption" was that if there was a 3 way tie...
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.
-
RE: A Good Reference
I would certainly attend a class given by one of you, although I much prefer Colorado (at any time of the year) to Florida.
RE: Moving master, having problem
you can start SQL from the command prompt using the path arguments to point to the folder that contains the master database you wan to use. Once you have 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.
RE: Not possible to export to text file???
I've missed it more than once but at the top of the list is "Flat File Destination".
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.
RE: deleting through xp_cmdshell
I use this:
xp_cmdshell 'del /Q {your stuff here}'
The /Q means quiet mode and doesn't ask for confirmation.
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.
RE: Scripting a DB Table.
you'll need to do it in a DTS package using using the copy object task.
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.
RE: Debugger not working at client
Look at this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp
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.
RE: The Challenge: Litespeed v TDPSQL
At the time I tested Litespeed it had (or has) a Native Command Substitution that loads as a service and capture native SQL maintenance plans as they execute re-routing them...
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.
RE: lentitud en base de datos
Utilicé a un traductor también. Otra cosa para mirar es la longitud media de la línea para cada disco físico en el perfmon. Si está sobre 2, usted tiene un...
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.
RE: How to check the errorlogs for any errors?
To read the current SQL error log, you could use xp_readerrorlog. Dump the ouptput into a temp table and examine it for keywords. The output of the xp is a...
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.
RE: cursor error msg
-- Begin Main procedure --
BEGIN
Open get_cases
WHILE @@FETCH_STATUS = 0 Begin
Fetch Next
From get_cases
Into @v_case_id
END
CLOSE get_cases
deallocate get_cases
END
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.
RE: Orhpaned Users
As part of your process, you may want to think about adding a DTS/Transfer Login task from production to deveolopment. After restore, use the sp_change_users_login to link the users to the logins....
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.
RE: Execute a VBScript
I don't know if this is typo in the post but you have a \\ in the path.
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.
RE: Return specific columns from a sp
copy the sp_who2 proc into another and modify that one to return only what you want.
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.
RE: Differential Restore - STANDBY vs. NORECOVERY
From BOL:
SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or when...
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.
Viewing 15 posts - 241 through 255 (of 327 total)