You cannot create indexed view if your view definition contains UNION.

You can use UNION ALL instead of UNION as UNION does a select distinct on the cumulative resultset.

In UNION...

Assuming your table (TestTable) has two columns

FileName varchar(255)

ExternalFile varbinary

to store the file within the table, you'd write something like this..

Insert into TestTable(FileName , ExternalFile)

Select 'abc', BulkColumn FROM OPENROWSET(

Bulk N'C:\FileLocation\abc.jpg',...

You can also create a dummy database with the same name as your original database, shut down sql server service and overwrite your data files with original files. Restart sql...

A user belonging to the windows administrator group will be able to connect to the server using any authentication mode.

You can also refer to http://msdn.microsoft.com/en-us/library/aa905171(SQL.80).aspx on authentication modes.

refer this part of code

AND D.TitleReferenceNumber like

CASE WHEN CHARINDEX(';',T.DTI_SHORT_LEGAL_DISPLY_TEXT) =...

Can u check the ascii code of the last character?

select ascii(right(companyinfo,1)) from company

if its 32, it's a space and should be removed using rtrim

if its something else, you need to...

select name from sysobjects where xtype='U'

Declare @tab1 varchar(255)

Declare Space_Cursor Cursor for

select name from sysobjects where xtype='U'

open space_cursor

fetch next from space_cursor into @Tab1

while @@fetch_status=0

Begin

PRINT sp_spaceused @tab1

fetch next from space_cursor...

i just copied/pasted that code.

use filepath of your choice

use sp_helpfile to determine the filenames and locations of database and log files.

May be the tempdb is on your C:

or logfiles from your production database are kept on C:

To move...

refer to the following msdn link.

http://msdn.microsoft.com/en-us/library/aa337114(SQL.90).aspx

This is happening at...

can u run this query and let us know the results..

select name, xtype from sysobjects where name='x_old'

The error message is self-explanatory. The new owner already has an object with the same name. in your case there is already an object x_old owned by dbo.

If your concern is to move the incremental data from your production server to the secondary server, you can setup log-shipping where all the changes are applied to the secondary...

You take backup of the log files to...