Viewing 15 posts - 1 through 15 (of 112 total)
I'm not quite sure what you mean by only addresses are in the form of. That is an active directory string that will relate to the object in active...
August 16, 2013 at 6:46 am
What is the default database for the login?
SELECT default_database_name
FROM sys.server_principals
WHERE name = 'MSSqlDB2K8\sqlsrvAcct';
GO
Is the database online and in multi user mode?
Cheers
Chris
August 16, 2013 at 6:43 am
In short No. The below script will prove this. There is an great book by Kalen Delaney that explains locking in great detail. Link below;
http://www.sqlservercentral.com/articles/books/93946/
--...
August 16, 2013 at 6:31 am
I can't think of a reason why you wouldn't want to make use of database mail. I enable database mail on all the servers in our estate as part...
August 13, 2013 at 6:15 am
You can fail the database on the principal to the mirror make the change test it and fail the database back to the original principal.
Cheers
Chris
August 13, 2013 at 6:05 am
The query and job should run without error, as for why you have NULL values I don't know why you have them. If you run the SELECT without the...
April 18, 2013 at 7:53 am
I imagine ghost cleanup is run when you migrate as some part of the recovery process trigger it. It may be worth posting the question on twitter using the...
April 18, 2013 at 7:51 am
That will certainly impact recovery time, Below is a script that will create a script to update the initial log file size and the auto growth settings based on the...
April 18, 2013 at 7:19 am
You can run SET STATISTICS IO ON before your change, execute the query and review the results in the messages tab. Then run DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS to...
April 18, 2013 at 6:05 am
If you run DBCC LOGINFO('DatabaseNameHere') for the affected database how many records are returned?
Each record is a Virtual Log File (VLF) a high number of VLF's would impact recovery time.
Chris
April 18, 2013 at 5:59 am
If I understand you correctly, when you can't connect the services are not running? What happens when you start the services, can you then connect?
Chris
April 18, 2013 at 5:54 am
Rather than selecting into your temporary table have you tried creating the temporary table and specifying NULL in the definition of the column that fails in the error message you...
April 18, 2013 at 5:46 am
Just create a foreign key between the audit table and source table on that column that will do the trick.
Chris
April 17, 2013 at 12:16 pm
Great news, that is what we are here for 🙂
Chris
April 17, 2013 at 11:58 am
Viewing 15 posts - 1 through 15 (of 112 total)