Viewing 15 posts - 3,136 through 3,150 (of 26,490 total)
You need to try this:
exec(
January 24, 2017 at 3:02 pm
SQL-DBA-01 - Tuesday, January 24, 2017 1:51 PMStill the same error. I think one quote at the end is missing.
January 24, 2017 at 2:30 pm
January 24, 2017 at 2:10 pm
You may not be looking for a solution but it would help to see the query. Can you recreate the issue in a sandbox (empty) database? If so, can you...
January 24, 2017 at 1:46 pm
Edited my post above.
January 24, 2017 at 1:43 pm
Try this:
set @v='
SELECT *
FROM OPENQUERY([' + @param1 +'], ''EXEC master.dbo.procedure @sysservername =''' + @param1 + ''')'
January 24, 2017 at 1:41 pm
Unable to pass the servername in the @param1 variable. It just does not work....
January 24, 2017 at 1:38 pm
January 24, 2017 at 11:58 am
Just one small problem with the code posted above using sys.dm_db_partition_stats , it doesn't take into account the possibility of actual partitioned tables.
January 24, 2017 at 10:57 am
January 24, 2017 at 9:02 am
January 24, 2017 at 8:29 am
January 24, 2017 at 8:18 am
Just so you know, you really haven't provided enough information to really help you with an answer. You have the benefit of having access to your servers, databases, and coworkers...
January 23, 2017 at 1:52 pm
Favor, please.
Please explain what it is you are trying to accomplish, and then explain why the results of the query are wrong, and how you expect the results...
January 23, 2017 at 1:34 pm
Viewing 15 posts - 3,136 through 3,150 (of 26,490 total)