Forum Replies Created
Viewing 15 posts - 271 through 285 (of 327 total)
-
RE: HashBytes function
FYI - I just did a cut and paste from your post on 2 servers and both worked.
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: Change Password
From BOL:"Execute permissions default to the public role for a user changing the password for his or her own login"
If the user is already logged in, then the user can...
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: SQL Server Failover Solutions
Yes - you can have an active/active arrangement. Just be sure to factor in performance degradation when you are trying to balance the nodes and determine how much is acceptable.
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: SQL Server Failover Solutions
Log shipping does require some manual intervention.
My experience with 2 way clusters for HA has been positive. In most cases, if the active node goes down, the failover 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.
-
RE: SQL Server Failover Solutions
I guess I needed to be more "definite"
. What is the time frame for failover? Do you require High Availability (this would...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: SQL Server Failover Solutions
Please define what you believe to be a failover situation.
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: Should we change collations ???
Don't forget to check the applications that access the data. Changing collation may "break" something in an application.
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: Maintenance issues with quoted identifiers ???
If you have SP4 installed, have a look at this :
http://support.microsoft.com/?kbid=902388
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: Maintenance Plans for 2005
"It is probably similar thing with the database backups that have identifiers that this is a backup file. Any other file with extension BAK was not deleted."
I'm fairly certain 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: Maintenance Plans for 2005
On the off chance that all you want to know is where to find the number of days to keep before the plan will delete the backup files, it's in...
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: Maintenance Plans on 2005
It looks like sysdtspackages90 contains a row for each maintenance plan. At least it does on my databases. I just have some test stuff and very littel else so it's...
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: Maintenance Plans on 2005
Maintenance plans are still stored in MSDB. Sysdbmaintplan_jobs contains the job_id linked to the maintenance plan.
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: SQL Server Registration in SQL server Studio 2005
If I remember correctly, right click on Database Engine in the Registered Servers window and the menu should have "Previously Registered Servers" in it. Any SQL 2000 servers that were ...
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 script permissions for stored procedures
This is very different from 2000 (why should this be the exception :mad
Open up Object Explorer, right click on the database that has 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: DO I need SA rights for running Symantec''''s Backup Exec
I don't know anything about the Symantec product but you might try using the db_backupoperator role with the account. If it doesn't work, it may give more information about what...
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 - 271 through 285 (of 327 total)