what is the recovery model for this database

Adam Bean (2/24/2014)

---

Hey all,

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...

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

You do...

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.

Are you receiving this after your domain migration?

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.

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...

bobyahed2dis (2/23/2014)

---

Hello All,

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...

n00bDBA (2/21/2014)

---

Hi all,

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...

Martin_Burton (2/19/2014)

---

I have a user that has db_datareader role on a database and explicit grant Connect and Execute permissions on the same database, there are no other permissions set.

My user...

pradeep.mohan (2/22/2014)

---

Hi,

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...

lsalih (2/21/2014)

---

never mind, I was not searching correctly for how to implement it. There are many articles out there:

http://www.sqlservercentral.com/Forums/Topic1058329-5-1.aspx

I just made backups, put sql server cluster resources offline. Asked...

bobyahed2dis (2/23/2014)

---

Hello All,

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,...

One step closer to my private pilots licence 😉