I think that you missed my point. A cursor IS a while loop (well, not exactly but it needs it to be useful).

There's a different way to do that, but...

What do you think this is? A pizza?

WHILE @@FETCH_STATUS = 0

begin

-- my query

FETCH cr into @dbname

end...

I was on my mobile, but now that I'm back on the desktop, I can elaborate a little more.

SQL Server is identifying master as a linked server instead of a...

You have 3 dots instead of 2.

Have you noticed the vsb instead of vbs?

Does the account used by xp_cmdshell has permissions to execute the scripts?

Here you go:

A solution

Don't you hate those vendors? 😀

Have you tried changing the type of the step to an ActiveX Script or Operating System?

What is the problem that you have?

I suppose you're using...

Simple question.

Why do you want to stop app services to backup the DB? Backups can be done online.

You can try a case sensitive collation.

SET @SQL = 'EXEC (''' + REPLACE(REPLACE(@SQL COLLATE Latin1_General_BIN, '''', ''''''), 'GO', ''');' + + CHAR(13) + ' EXEC(''') + ''');'

For datetime columns, you should use a range to prevent the use of functions in your column. You might also want to have a computed column either for duration or...

Does this help?

Consuming JSON Strings in SQL Server by Phil Factor[/url]

ramana3327 (11/19/2014)

---

That is not related to parameter sniffing.

Why because we are passing 3 input parameters. Those are default parameters. We are not changing either in SP or Report also.

Just tested...

Even that option could filter something.

DECLARE @test-2 TABLE(

string varchar(30)

)

INSERT @test-2 VALUES ('dasfsa'),('%!·$%/'), (''), (NULL)

SELECT *

FROM @test-2

WHERE string LIKE '%'

SELECT *

FROM @test-2

--What about this?

SELECT *

FROM @test-2

WHERE...

It's not that we don't want to share information because we're jealous. If that were the case, we wouldn't be helping on the forums. The idea of not posting it...

Matt Miller (#4) (11/19/2014)

---

Sean Lange (11/19/2014)

---

DSNOSPAM (11/19/2014)

---

Thanks Luis.

I've been reading about possible performance hits. However, this is in a reporting/analysis environment, not on a production server, and it would...