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?
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...
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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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...
December 6, 2012 at 7:24 am
Couldn't monitoring tools such as SCOM accomplish what you are trying to do?
December 6, 2012 at 7:02 am
Viewing 15 posts - 511 through 525 (of 966 total)