Rottengeek (10/5/2012)

---

One thing I'm wondering about, however, is the impact to performance if connection pooling is not handled well, and how I can tell. I created an event notification...

The maximum concurrent connections is 32767 (its an integer) but due to connection pooling these tend to get recycled very rapidly.

You can monitor the number of concurrent connections using this...

No.

Perry Whittle (10/5/2012)

---

For an add file...

Konuri Dinesh (9/27/2012)

---

Dear Members,

my requirement like this

i have total 40 Servers, now i have to create one DB in one server then it should reflect in all servers i.e automatically...

It will. The only restriction is on certain datatypes and that the distributor needs to be equal or higher to the highest version.

http://msdn.microsoft.com/en-us/library/ms143241%28v=sql.105%29.aspx

If you had any published databases, try changing the the db option before running sp_dropdistributor as this is the standard process I follow.

USE [Database]; EXEC sp_removedbreplication 'Database'

GO

USE [Database1]; EXEC sp_removedbreplication...

No

Any sql server can be...

Have you tried adding a distribution database and then running sp_dropdistributor?

http://msdn.microsoft.com/en-us/library/ms189755.aspx

I apologize. I misread the original post that suggested there was an issue with permissions.

Data is not restricted on a permission basis. Either you can read the data...

Use this function to establish the permissions of both users.

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

GO

SELECT * FROM fn_my_permissions('Sales.vIndividualCustomer', 'OBJECT')

ORDER BY subentity_name, permission_name ;

GO

http://msdn.microsoft.com/en-us/library/ms176097.aspx

It sounds...

You could create a SQL Account with sysadmin permissions and use this to do the detach/attach. It should work if the service account has host admin priviledges but it...

nelsonaloor (9/27/2012)

---

We have a two node (NODE1 and NODE3) cluster (windows 2008) with SQL 2008 (INST1 and INST2) instance running on each node. The quorum setting is "Node and Disk...

If you use my suggestion, you could remove QtrPer...

Also I...

SteveEClarke (9/27/2012)

---

Okay - my challenge today, is that I need to create some labels for a "Picking List" ( BOM ) - One lable per component required.

Table ONE

WorksOrder

ParentPart

QtyToMake

Table TWO

WorksOrder

Component

QtyPer

View will...