try to catch it in sql profiler

hi

is RE7 name of the database. if that is the case then should'nt it be RE7.dbo.[tablename].[fieldname]...

search this site and other sites u should get some scripts

Hi

Why dont u store the resultset that you get from the linked server query into a temp table and then use the temp table in the SQL query to do...

take a look at this. u will need to make some changes as per your requirements

declare

@name varchar(100)

declare

hi

A job can have multiple schedules. Disabling a job disables all the schedules in a job. Disabling a schedule disables only that schedule in a job.

If your job has...

hi

just a thought - would it help to use @@ERROR variable just after your "EXEC" statement.

its not possible to use Alter Table statement for altering multiple columns.

hi

user must be a member of sysadmin role

hi

Thanks, that certainly was the case. Is there any method of getting backup and restore information even while using history cleanup task ?

hi

i think (i may be wrong) that its got something to do with applying the latest patch to the OS/SQL server.

search the discussion forums in this site for more info....

hi

i have experienced a similar issue but i got the error while using import export wizard. I think i faced the same issue as yours but i cant remember correctly.

For the...

nice one brendt 

hi

where is this article? clicking on temp does not take me anywhere

in mssql also its "NOT IN" but it can be used only for a single field.

select * from table1 where (f1) not in (select f1 from table2 )