We also use synonyms as we have test and live systems (the database names are different).

We just point the synonyms to the right database (depending on the system) and off...

This is something we've been looking at as part of our load (just an idea at the minute).

We have a multi-part process to load our tables as follows:-

1. Load a...

Yup, it was just very odd.

No conversions anywhere.  It starts as a NULL (it's a filler field for now that doesn't contain any data but will be needed in the future) and stays as a...

• This reply was modified 5 years, 6 months ago by  richardmgreen1.

May be a data issue. The stuff getting loaded into the temp table is not stored as a date maybe? Hard to know not seeing the data. Check the...

Grant - I use local variables in all cases.  The normal for a stored procedure that needs parameters for our team  is to get the parameters (in whatever format) and...

Now it's gone odd.

I moved the "normal" code into a stored procedure and tried to alter the procedure and I've got the error:-

Msg 206, Level 16, State 2, Procedure usp_Load_MSDS101_Pregnancy_and_Booking,...

Thanks Grant

I don't think it's parameter sniffing (I hope) as I moved the stored procedure into a standard piece of SQL and it was doing the same thing.

I was using...

We did something similar to get all the files we'd uploaded using the attached script.

It download all the RDL files, all the data source files (.RDS) and (I think) any...

• This reply was modified 5 years, 7 months ago by  richardmgreen1.

Thanks John

Never thought of it like that so I've learned something else as well.

Cheers

Richard

Thanks guys

That will do for me.

Completely forgot about using sysname (but I didn't think it would get around SQL injection so I've learned something).

Cheers

Richard

Hi John

The query works as-is but I want to include the database and table names in the parameters.

When I alter the code (just to keep from altering the stored procedure)...

Steve - Thanks for that, it looks like we've only got one file in each of the filegroups.

tripleAxe - We do have full-text indexing but I'm not convinced it's used/necessary.

I'll...

Thanks for that.

I was going to do this first on our test database (after 2 backups to make sure that at least one of them is good!).

It's either that or...

Hi Jeff

As far as I can see, there is no reason for these files to exist (there are no partitions to any of our databases).

I did read that NDF files...