Hmm..firstly I don't understand what the title of your post has to do with your question.

However, if you have a single mdf file, then that file is your primary datafile...

Evil Kraig F (9/4/2012)

---

For warehouses, particulary for cubes, you need to start with 'what questions do I want to ask of the data?' This will help inform you of...

I'm not even sure why you bothered to comment on this thread in the first place. Valerie's article was written in her capacity as founder of the Ada Initiative,...

mtucker-732014 (9/3/2012)

---

I havent been to a Defcon so cant speak from first hand experience.

Neither apparently can Valerie.

I read her article and she has plenty of second and third hand stories...

elham_azizi_62 (8/29/2012)

---

yes get command complete succesfully.

but when insert into identity table get error:

An explicit value for the identity column in table 'WOS_WorkOrderType' can only be specified when a column list...

Sounds like you have your partitioning covered by your natural, 'branchID' key so that's fine.

Each of your branches will be a publisher and can also be its own...

Your issue is with 'double-hop' authentication. When you're logged onto Server1,you are able to authenticate directly to Server2, but when you are connected to Server1 via your PC (using...

I just wanted to clarify, too, that taking any kind of backup has no effect on database mirroring.

Ok, so I do this...

SET IDENTITY_INSERT dbo.TestTable ON

and get this...

[font="Courier New"]Command(s) completed successfully.[/font]

What message do you get?

As I said in my last post, if you're running the code as a member of sysadmins then permissions are not a problem and you don't need to do anything.

Are...

Permissions are not the issue then if you're a member of sysadmins.

I'm not sure what else can be the issue; its a fairly straightforward process usually. ...

runal_jagtap (8/28/2012)

---

I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers & if...

Permissions issue? IDENTITY_INSERT requires that you are the owner of the table or are a member of db_owner or db_ddladmin on the database.

Have you correctly qualified the...

Hmm...an odd thing just happened. I know that I selected the correct answers for this question but then the response was that I'd answered it incorrectly and gave an...

GilaMonster (8/28/2012)

---

Well I wrote that...