Forum Replies Created
Viewing 15 posts - 226 through 240 (of 327 total)
-
RE: Is replication an option?
"I've found replication to be a bit unreliable" If you stick to the rules, it works quite well.
1) Partial Replication - I think this would be nightmare to keep...
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: Is replication an option?
No matter which mode, Log Shipping needs exclusive use of the database to load the logs so users can't be connected at that time.
Putting the distributer on a different...
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: Is replication an option?
Transactional Replication won't add or change anything in the database but it does require that the tables being replicated have a primary key.
It will also install a Distribution database...
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: My MSSQL 2005 Server is too paranoid
I think you will also need to give the user IMPERSONATE permission although it looks like you are connecting as NewUser1. If that is the case you would Execute As...
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: WMI with SQL 2005
http://www.microsoft.com/technet/scriptcenter/sgwho.mspx
This is a link to the script center at MS. It has links to script blogs, etc. You might find your answer 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: Buffer Size Problem
DTS samples the first 8 (I think) rows and sets its' buffer size based on that sampling. I don't remember exactly where it is (I don't use DTS very often),...
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: Question of the Day for 25 May 2006
David is correct - the only thing that would come back is an error.
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: What happened to Copy Objects?
SSIS has a "Transfer SQL Server Objects" task that is similar.
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: TSQL and listing of user rights
I've used this utility that I found in an article on this site:
http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp
It works quite well
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: Validation in SQL Server 2005 Express?
Try a check constraint at the column level. I believe Express supports 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: Need to identify all DTS packages using a specific filename
I'm not very familiar with the way DTS packages are stored in the table but I know they can be saved to a VB file which is plain text. You...
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: Any way to List all SQL Server Instances in SQL Management Studio
#2 - No, but you can still use QA (isqlw.exe) on 2K5 (at least for the time being)
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: Installing SQL Server 2005 Enterprise x-64 bit on Windows 2003 SP1 cluster
I've run into a similar issue and from what I have found, IIS (5.0 or later) needs to be installed prior to installing RS. I haven't tried it yet as...
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: Outsourced = Laid Off?
What really gets my goat is the fact that business and congress either don't see or are ignoring the fact that it is the middle class in this country that makes...
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: Unable to begin a distributed transaction
once you start a transaction, the DTC is engaged. Be sure that DTC is installed and running.
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 - 226 through 240 (of 327 total)