Viewing 15 posts - 3,526 through 3,540 (of 9,253 total)
what is the recovery model for this database
February 25, 2014 at 2:36 am
Adam Bean (2/24/2014)
When opening .sql files, I get a connect to database engine prompt every single time. Never had this problem before and not sure when it started or...
February 25, 2014 at 2:27 am
why would it affect performance, it basically tells sql server not to use the new style of identity maintenance and act like a sql 2008 instance in that respect
February 24, 2014 at 7:33 am
nikhil.desai1 (2/24/2014)
Hi,What will be the best option for DBA to physically locate Witness server at PROD site or at DR site in Database mirroring ?
Thanks and Regards,
Nikhil P Desai
You do...
February 24, 2014 at 5:44 am
It forces identities in sql server to behave as it did in previous versions. The trace flag is added to the service startup list to persist it on service restarts.
February 23, 2014 at 11:51 pm
Are you receiving this after your domain migration?
February 23, 2014 at 4:05 pm
It sounds like the datafiles still exist on disk. Rather than creating a new database, try Attaching an existing database and browse to the disk files.
February 23, 2014 at 4:02 pm
I have worked with a few applications in the past that all required elevated privilege. This is a typical candidate for ring fencing to a separate instance.
If the application is...
February 23, 2014 at 3:58 pm
bobyahed2dis (2/23/2014)
thanks for coming back to my post,
i'm using the cursor as i need to cycle through the records one by one
TEMPMONTHLYMATCHES_REPORTEDMONTHS contains the following;
APP_ID = unique serial...
February 23, 2014 at 12:30 pm
n00bDBA (2/21/2014)
ive had log shipping break due to the copy failing as there wasnt enough space on the drive.
My first re-action is stop the log shipping jobs...
February 23, 2014 at 11:44 am
Martin_Burton (2/19/2014)
My user...
February 23, 2014 at 10:52 am
pradeep.mohan (2/22/2014)
After domain migration all mirroing connection is disconnected, how can i recover this i found windows event log
"Database mirroring connection error 2 'DNS lookup failed with error: '11001(No such...
February 23, 2014 at 10:30 am
lsalih (2/21/2014)
http://www.sqlservercentral.com/Forums/Topic1058329-5-1.aspx
I just made backups, put sql server cluster resources offline. Asked...
February 23, 2014 at 10:26 am
bobyahed2dis (2/23/2014)
I'm very new to sql this is my first attempt, I am trying to use cursor with dynamic sql to identify the column name to insert values into,...
February 23, 2014 at 10:24 am
Viewing 15 posts - 3,526 through 3,540 (of 9,253 total)