select *

from Audit

where detail like '%2%[0-9]%'

I cry foul!!! As James Lean has pointed out, the INFORMATION_SCHEMA.ROUTINES returns both stored procedures AND functions!!! Without the additional filtering, it would be analogous to saying that "SELECT *...

What's the datatype of [Inventory Posting Group]? What values are contained in it? Are any of them 'B'?

I ran into the nvarchar(max) issue where the returned value is NULL. If I run code (four part name) at the linked server, it returns the text; if I run...

Here is what I came up with. It does return an extra line of data and I'm not clear which one of us has the correct output. C'est la vie!

;with

SummedByYearMonth

as(

select

AccountID,

InvoiceYearMonth,

sum(Amount)...

One of the answers is "Error" and it does throw an error. The answer listed as correct is "220" but the results are:

"Msg 220, Level 16, State 2, Line 2

Arithmetic...

exec sp_who2

Here's another way:select uc.UserName, uc.CurriculumKey -- Select the user's...

from UserCurriculum uc

where exists ( ...

In re: "it's the selectivity of the data that is what the SQL engine uses to determine whether to use an index or not."

For SELECTs that would be true but...

I think your task is complicated, in this instance, by the fact that you need to be local to the SQL Server when accessing the file system, which a CREATE...

Bring it online first, take the backup and take it back offline.

Is the list of databases static or are you going to need to modify the job step every time a database is added or dropped from your server? If it's...

You could return the two calculated values via parameters by using the "OUTPUT" keyword.

For SQL Logins, there are check boxes in SSMS that define whether the password expires and if it needs to be changed on the first usage. Set these appropriately and...

We did something similar to Gianluca's trigger code. The solution works well for us but allow me to make a couple of suggestions:

1) We define the set of Users who...