Apparently the view is either non-updatable or you are sending updates to columns that belong to multiple tables.

That's a way too open question.

You should read (A LOT) first about how SQL Server works.

Sure! 😀

lk (2/18/2009)

---

Hello:

I have a PhoneNumber field in which the entries begin with either W: for work or H: for home (e.g., H:607-544-3451). I want to display the field in a...

Scott answer should be all you need.

Have you tried it ?

If the entire...

These columns were propagated to the subscribers using ddl command replication ?

Looks like your job account on that step does not have the right permissions to access such object!

You must definitely should start using backup compression!

I agree with Ken, 1TB DB is a serious deal, get some help.

A sample:

USE master;

GO

ALTER DATABASE

MODIFY FILE

(

NAME...

How would it look if you wanted two rows ?

pzmrcd (2/18/2009)

---

Hi I have included Active Directory as a linked server to SQLserver 2005.

when I execute the following select query..

SELECT * FROM

OpenQuery(ADSI, 'SELECT givenName, sn FROM ''LDAP://DC=test,DC=com'' WHERE...

Joe (2/18/2009)

---

Thanks for your reply; your reply me a confidence; I will tune distributor; I am doing a pull down trans. repl; Distri. to subs. takes a long time; 7hrs...

winston Smith (2/18/2009)

---

Cool, careless of me to miss that in BOL. thanks.

Ok. so what im doing now is this:

alter database test_DB

set offline

Go

alter database test_DB

modify file

(

name = test_DB,

Filename = N'C:\DatabaseRestoreTest\Files_location\test_DB_temp.mdf'

)

GO

alter...

DECLARE @Inventory_Trans TABLE (Id INT,Description VARCHAR(800) )

INSERT INTO @Inventory_Trans ( Id, Description )

SELECT 1,'Transfer to location S034R6/MAIN RCVR...

Did you update the stats "WITH FULLSCAN, ALL" ?