Ack, good catch 😀

The reason I used master was that I didn't want to...

alex meunier (10/24/2016)

---

Update:

using SSMS 2008R2 remotely, I'm able to create the maintenance plan.

So it would seem that the issues would be with SSMS 2016, there would

be a prequisite that ...

cphite (10/17/2016)

---

Hey all--

Does anyone know of any exceptions for table replication?

We have a large inventory table that we use - around 4 million parts - that is maintained on one...

Sue_H (10/4/2016)

---

SSRS separated from IIS on SQL Server 2008 - generally just goes through http.sys now.

When you say Bridge server - is this a vendor specific bridge server? Or...

Well, it's at least a place to start looking 😀

It's actually not that unusual a request... they may simply need to justify *any* access to production, and that includes you. They need to be able to tell...

Either way...

naveen.neerukattu1228 (4/19/2016)

---

Hi All,

i am little bit confusion about Maintance plan and sql job.

i want to take backup in schedule basis. so which option will meet my requirements?

creating job in sql...

GrassHopper (4/8/2016)

---

I have a sql table with about 10 columns. I link the table to an ms access application. When I open the table in ms access and...

I always format my code.... I'm not a stickler about it, but to me it's just way easier to read that way.

I tend to stick with mostly lowercase, with...

wallywizard (3/11/2016)

---

sorry let me rephrase....I dont have an item that ends both S and B at the same time.

There are tons of items, I am only looking to pull items...

Is it possible that some *other* database on your server (or some other instance??) has an active database with those file names?

I've had cases for example on our dev server...

TomThomson (12/2/2015)

---

I find the idea that code can be so scary that no-one will touch it hard to understand. Either the code does what is wanted, or it doesnt....

Just out of curiosity, what is the CPU doing during these backups? Do you see one or more cores at full utilization? If so, it could be that...

Jeff Moden (11/18/2015)

---

cphite (11/18/2015)

---

jbrandenburg (11/17/2015)

---

I have been working very closely with the storage admin. He has confirmed things appear to be setup properly. The SQL server and the...