Please tell us where you heard that it was possible.

ramyours2003 (3/5/2015)

---

I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r2), can any one one sent me the syntax of...

Hi Jeff, have a quick read here and you'll see that the answer is 'yes'.

If you can find a DOS command to do it (DOS rename supports wildcards, I think), you should be able to use an Execute Process task to run it.

Well done.

Circular references are really bad news with DB projects.

As no one has responded, I will assume that I have not missed anything.

It's a grotty workaround because all of my CLR functions get dropped, created and schema-moved every...

If the layout for each client is the same and it's a one-spreadsheet-per-client thing, it would seem that SSIS is quite a good fit.

The trick, obviously, is in the design...

Or this?

select Customer

,Type

,DueDate1

,DueDate2

from dbo.myTable mt

where...

Is this problem specific to synonyms, or are you having problems with direct cross-database references too?

Have you checked the execution plan? Are there any unexpected implicit conversions happening?

* while executing this query im getting error. (like varchar cant convert to numberic)

* Here I have no clue in which column it is

* also dont know which row...

Works fine for me. Check the compatibility level of the database you are executing it in.

Not exactly what you want, but in SSMS you can right-click on a proc in Object Explorer and select 'View Dependencies' to see what depends on the proc (or what...

Not that link. The one on the word 'here'.

I am finding your question difficult to follow. Can you take a look at the first link in my signature and then provide your consumable sample data, with DDL and...