remove "@val=" from your query in sp_executesql()

Use sp_executesql() instead of exec(),

using sp_executesql(), you can specify @val as output parameter...

this has nothing to do with SQLServer, the problem is with Windows clipboard,,,

you can copy... fewer rows .. let's say... 5000 rows at a time..

Have you tried this?

select PtID, MedID, GenericMedName, MedChange from dbo.Pyxis

except

select [Hospital #], BASEITEMNUMBER, '', '' from dbo.HMM

order by pyxis.PtID

With MyTable

As

(

select PtID, MedID from dbo.Pyxis

except

select [Hospital #], BASEITEMNUMBER from dbo.HMM

order by pyxis.PtID

)

Select PtID, MedID, PX.AnotherColumn From MyTable

Inner Join Pyxis PX ON MyTable.PtID = PX.PtID

Yes, you can specify the size as initial size of the file.

you can set it to a larger value, so it will pre-allocate specified size.

well, you can also create a new file group on production database which will contain only one table,

then, you can perform a file group backup from production server,

and a...

Have you considered using SQLServer Replication?

No T-Log will not give you User Name,,

You might be able to find the approximate deletion time by applying T-Logs one by one,

but you won't be able to find user name, unless you have Audit Trace.

TB = TeraByte??

You can perform Full Backup Once a Week, Preferably on Weekends,

and a Transaction Log Backup Every Hour ....,,

A better approach is to divide the Database in multiple file...

I think what you are looking for is an INNER JOIN,

Try this query:

Select Table1.VehicleGUID, Table2.TimeStamp As [Battry Changed On] From GPSDataTable

Inner Join BattryChangeTable Table2 ON Table2.VehicleGUID = Table1.VehicleGUID

This means that "Test" User is unable to execute the Trigger,

Create TRIGGER Tr_ServerLogon

ON ALL SERVER WITH Execute As 'sa' FOR LOGON

AS

BEGIN

INSERT INTO AuditDatabase.dbo.LogonHist

SELECT ORIGINAL_LOGIN(),USER,@@SPID,GETDATE()

END

GO

1. Execute As 'sa' will make sure...

you can perform backup WITH INIT clause,

CAUTION: This will remove all the backups from the media set, which has expired or retain period is over,

You can set the Retain Days...

create partition function pf_customername (char(10))

as RANGE RIGHT

for values

('John','Paul')

A-I will go to Partition 1

J-O will go to Partition 2

P-Z will go to Partition 3