Use Attach Database method. BTW, You cannot have mdf or ldf files in CE edition. There are actually sdf files.

Off course, its possible & very simple to do.

Just go to SSMS > Right click on the Database > All Tasks > Shrink > Files (In file type...

Check in sysjobschedules & sysschedules tables in msdb database.

Cross Post...Continue discussions here

You need to create a linked server using sp_addlinkedserver procedure

EXEC sp_addlinkedserver

@server='TestServer',

@srvproduct='',

@provider='SQLNCLI',

@datasrc='YourServer\InstanceName'

Then, create linker...

Is the friend_id a reference to users table? (which i think should)

SELECTT.userid, U.username, T.friend_id, F.username As friendname, T.request_status

FROMfriends T

INNER JOIN users U ON T.userid = U.userid

INNER JOIN users F...

It says that you're dividing a number by zero, which can't be defined...

How could I miss that?:hehe:

Thanks Gail for the catch. I do agree with what you have suggested.

Adding included varchar(max), nvarchar(max), varbinary(max), or xml (max) columns...

Create a non-clustered index on columns server, customer and add audit_output as include column.

You are not having enough quotes in the case block of the open query statement. You need to add 4 quotes instead of two as the statement is the...

Setting up a linked server is the right way to go, anyway, try adding IMEX = 1 to the provider string, which will make treat the column as textual...

Go to Management Studio > Query > Design Query in Editor

Or something like this?

SELECTTOP 5 T.*

FROM( SELECT itemid, MAX( dateaccessed ) AS SNO FROM tblhits WHERE username = 'testusername' GROUP BY itemid ) T

ORDER BY SNO DESC

RichardB (12/6/2007)

Not the function I'd worry about - more the update of 4 billion + records...

When creating or altering views, the statement CREATE VIEW should be the first one in the batch.

Its definitely not a good idea to create views in a procedure.