Will this be OK?

.. where @userid = 0 or u2.id = @userid

Regards

Piotr

Hi,

You should use sqlcmd utility. You can pass the name of the file as variable into the script.

Regards

Piotr

I think the last sentence pertains to the partitioning column.

If I issue this command

alter table test alter column one bigint

I get this:

[font="Courier New"]Msg 5074, Level 16, State 1, Line 1

The...

Yes, there is procedure sp_start_job, you can have a look.

HTH

Piotr

It looks like Reporting Services is passing the parameter formatted in such a way SQL Server cannot implicitly convert it. This may be caused by your regional settings or locale....

Great, good to know that you have this problem off your head 🙂

So you run the loop within a procedure on the remote server, right?

Regards

Piotr

I agree, sliding window might be a good solution, unless there are foreign key constraints on other tables referencing this one. Nathan, do you have any triggers on this table?...

I think it is definitely worth a try.

Regards

Piotr

Your're welcome 🙂

But how many rows do exist in the table? Looking at the example you posted I would think you delete half of the table each day.

I ran a...

Maybe you could add a procedure on that remote server that would execute the loop locally. Also, how many rows are there in the table? Linchi Shea wrote about a...

Hi Brian,

You can possibly use synonyms for all tables that you reference in views. If there are not too many of them, you could have one set of synonyms for...

Try to find file sqlncli.msi on the installation disk. Right click it and then choose Install. It happened to me once too, that setup of something related to SQL Server...

You don't have to apologize David, I bet you have knowledge many of us here have no clue about. One cannot know everything. 🙂

Regarding your problem the most important thing...

C'mon, this is Express edition installed by an app probably. Who would ever know there are any databases to back up there? The app should take care of it. It...

The database should be still there. Try to search your local drives for files with .mdf extension.

Then when you find them, try to figure out which one is for your...