Viewing 15 posts - 511 through 525 (of 966 total)
Is SQL running on the same machine that SSMS is installed on?
What are you typing in the Server Name field when trying to connect?
Joie Andrew
"Since 1982"
December 28, 2012 at 2:20 am
I would say it depends on how long your full backup takes. If it takes 20 minutes to do a full moving the full backup to 1215 will just cause...
Joie Andrew
"Since 1982"
December 28, 2012 at 1:24 am
SSMS fails to open, or it fails to connect to a database function, like Database Engine, Reporting Services, etc? I ask because these are two very different things.
If it opens...
Joie Andrew
"Since 1982"
December 28, 2012 at 1:08 am
What has it grown to so far? What is the size of the log file for the distribution database? What recovery model is the distribution database set to? If it...
Joie Andrew
"Since 1982"
December 28, 2012 at 1:04 am
You have another process going on at the same time that has a lock on a resource that is deadlocking with your log backups and SQL deemed it was easier...
Joie Andrew
"Since 1982"
December 28, 2012 at 12:55 am
Are you using a service account or a local system account like Local System or Network Service? How did you set the credentials for the SQL Server Service? Through the...
Joie Andrew
"Since 1982"
December 28, 2012 at 12:49 am
I thought one of Paul Randal's SQL Q&As for TechNet magazine back in the day had something on what technologies could be mixed with the different databases used in replication....
Joie Andrew
"Since 1982"
December 27, 2012 at 5:54 am
How many scripts are you talking about? If it is not too many you can open up the scripts in Management Studio, connect to the SQL 2005 instance and start...
Joie Andrew
"Since 1982"
December 27, 2012 at 5:27 am
You can also run the following:
EXEC sp_helpdb 'TempDB'
And check that the path that it shows the tempdb_log file is at is there and the file is there. If the path...
Joie Andrew
"Since 1982"
December 27, 2012 at 4:32 am
I have not used it but did see a short demo of ERStudio from Embarcadero when looking for tools for a migration project. It could do what I needed at...
Joie Andrew
"Since 1982"
December 26, 2012 at 7:21 am
I'm attempting (unsuccessfully) to reset a password, the issue is that the column with the passwords in is encrypted. I don't know what key was used to encrypt the data...
Joie Andrew
"Since 1982"
December 26, 2012 at 3:13 am
I do not believe so.
Automatic failover requires the following conditions:
The database mirroring session must be running in high-safety mode and must possess a witness. For more information, see Synchronous...
Joie Andrew
"Since 1982"
December 26, 2012 at 3:08 am
I know that we use it in our environment for a HA scenario, but cannot speak for an industry as a whole. If you are looking at upgrading soon you...
Joie Andrew
"Since 1982"
December 26, 2012 at 3:03 am
Which question exactly was not answered?
Where are login audits stored?
SQL Error log, if you configure auditing successful/failed logins through the instance properties. This is the same for every version of...
Joie Andrew
"Since 1982"
December 6, 2012 at 7:24 am
Couldn't monitoring tools such as SCOM accomplish what you are trying to do?
Joie Andrew
"Since 1982"
December 6, 2012 at 7:02 am
Viewing 15 posts - 511 through 525 (of 966 total)