madamcurie2005 (4/30/2009)

---

Hi

I have created a view on my server A which is caling a table from Server B. The table that its calling...

That seems to indicate a client-side, not a server side issue.

Here are some points to help you get started:

Do you have the Transaction log with too many VLFs ?

Is the recovery more of the DB set to BULK_LOGGED at bcp...

I don't think that's implemented in SSMS.

jpdlp (4/30/2009)

---

noeld (4/29/2009)

---

jpdlp (4/29/2009)

---

Example:

In the table [article table] , the column [article stock] is 5

subscriber 1 sells 1 unit and updates [article stock] to 4

subscriber 2 sells 2 units...

If it is in stand-by, it has to be in read-only mode so that next Transaction log backup can be applied.

And that is the expected...

I don't understand why you want to do that but here is a shot.

If that person using RDP is going to use SSMS you can set the default Isolation level...

ruchi (4/29/2009)

---

Hi,

We are trying to add one column with some default value in a table, which contains 25 crores rows of data. The query (Alter table command)is running from the...

jpdlp (4/29/2009)

---

Example:

In the table [article table] , the column [article stock] is 5

subscriber 1 sells 1 unit and updates [article stock] to 4

subscriber 2 sells 2 units and updates...

If the rebuild of a table starts at the last VLF you are likely to run out of space if the space is tight.

You should, BEFORE running the re-index, FORCE...

icarus (4/22/2009)

---

My co-worker proposed the idea of setting up a SQL 2005 configuration where we have two database servers, connection strings from the application servers will point to a DNS...

check service permissions on the share.

dallas13 (4/29/2009)

---

I have one database in my system,less frequently used with low transaction rate on them

We have sql server event alert for error number-9002 which indicates full log.

every sunday when...

if exists (select 1 from sys.columns c where c.object_id = object_id(@tname) and c.is_identity =1)

begin

-- identity column exists

end

else

begin

-- identity column does not exists..

end

But if you give us what you...

Heather (4/28/2009)

---

I'm seeing a lot to ASYNC_NETWORK_IO is activity monitor.

I know this related to the network or client being slow. The network seems fine based on the looking at...