Forum Replies Created
Viewing 15 posts - 166 through 180 (of 327 total)
-
RE: Logging Progress and Errors
I started playing with the fuzzy grouping. I like it.
I put the output in a spread sheet and let the users go...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: Logging Progress and Errors
Well, there isn't any fissionable material but a large cloud of Chlorine gas would produce similar results with the added benefit of not destroying buildings, infrastrucure etc
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: Logging Progress and Errors
Thanks again - I am just starting to read up on the script comp. I originally thought of error output because it was simple. I need to identify the duplicates...
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: Logging Progress and Errors
The error columns are not being populated. I have tried creating new packages on different servers but get the same result.
The main issue I see with pushing the rows...
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: Transfer SQL Server Objects Task - Problem
I know very well how frustrating is. I spent a few days trying to fix what I was believed was wrong. I thought the time would be well spent since...
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: Transfer SQL Server Objects Task - Problem
Unfortunately, welcome to the club. I found in a blog by a Microsoftie that said MS won't be doing anything with the this in the 2005 edition but will "probably" addresss...
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: Die Access, Die
I know a lot of people with "micro" businesses (1 to 5 employees, typically family) that use Access exclusively. They don't need anything more and it's a complete environment. My...
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 get date of last restore
Tables in msdb:
restorefile
restorefilegroup
restorehistory (backup_set_id is in this one)
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: Applying a snapshot that was ftp''''d to me.
From the ".cab" externsion, this is probably a cabinet file. WinZip should be able to extract the file(s) in the cabinet. I think you'll find a database backup in there...
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: DB Mail problem
The users need to be a memeber of the DatabaseMailUserRole database role in msdb.
IN BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/14cbf88f-d9d1-41a5-994e-532e2973ac9e.htm
To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb...
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: Deadlock Trace
You'll need to turn on a couple of trace flags - DBCC TRACEON(3605, 1204)
These will send the deadlock information to the SQL Server Error Log and will tell you 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: Automatically scripting replication
You can use the Scripting Object in DMO (2000, 7.0) or SMO (2005). DMO can be use in a VB Script but SMO needs VB.Net.
Create your script/program and schedule it...
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: SQL2005 SSMS script DROP before CREATE
I believe it is only in the Script Wizard options when you click at the database level. Right click a database, Tasks, Generate Scripts... This starts the wizard.
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: Need tips of tracing a dead lock issue
I found this article when I trying to resolve a deadlock issue:
http://www.code-magazine.com/Article.aspx?quickid=0309101
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: Frustrating Problem
I have a similiar problem. I am trying to use the Transfer SQL Server Objects to copy all tables and data from a source server to a target server. It fails...
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 - 166 through 180 (of 327 total)