Look at using openrowset and inserting into the table not the view passing in the parameter.

INSERT INTO myTable(ProjectID,FName)

SELECT @ProjectID, FName

FROM OPENROWSET(BULK N'C:\Text1.txt', .....)

GO

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

bubby (12/3/2012)

---

I have to SQL Server and one has version,

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c)...

Do not cross post it fragments replies

http://www.sqlservercentral.com/Forums/Topic1391939-1550-1.aspx

Sounds like you need to do some transaction log management.

What is the output of this query

select recovery_model_desc, log_reuse_wait_desc from sys.databases where name = 'testdb'

And some reading material

Managing Transaction Logs -...

We need the execution plan as a SQLPLAN file.

We also need the CREATE VIEW definition

We also need the CREATE TABLE definition of all the tables in the query and or...

It hits the first true condition then terminates the case statement.

SQL doesn't know how it is licensed, due to the number of possibilities that a server can be licensed. It is up to the company to ensure that they...

The .Value is missing from the ID field.

Fields!ID.Value = ".....",

Dont know if the following will help Wayne

http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/74c9a963-2ad2-4e38-b1f0-e5b8035e5ae2/

All you will need to do is to qualify the DB name when executing it from within the same proc

Take the below code, DB1 calls DB2 and passes in the...

No as the row is not bigger than 8060 bytes to use row overflow

This restriction is relaxed for tables that contain varchar, nvarchar, varbinary, or sql_variant columns....

No, not for SQL 2000

If it was 2005 or above you could add in the COPY_ONLY clause.

No as it has to be the row which overflows, not the page. The row is not overflowing as its 4100 bytes, for row overflow to occur the whole...

Yes, doing a backup outside of the logshipping process will cause a break in the log chain causing restoration problems on the secodary, until you restore the logs or do...

sanket kokane (11/30/2012)

---

ScottPletcher (11/29/2012)

---

Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row...