Not natively. You could use something like server-level triggers that occur on a Logon event, but I'm not a massive fan of such things.

I haven't used SSMS 18 against any 2008 instances, but I still use it against a 2012 instance (which should be getting switched off later this year) and never had...

I find this untrue, if i am honest. The errors messages often...

Have you tried as shown in the above? Are you sure it's the EXEC that's actually failing and not the statement(s) inside the procedure?

Pass a list of strings to a stored procedure SELECT. User.fields_i_want. FROM User. WHERE. User_id IN (SELECT User_id FROM Group_member WHERE Group_id IN (@Search_param)) ORDER BY User_id ASC. EXEC...

• This reply was modified 2 years, 4 months ago by  Thom A.

Using single quotes around the literally should be all your need:

EXEC dbo.Integration_RetrieveMessageToProcess ?, ?, 'Billed';

If you do try this, as Ed asked, what error do you get?...

So how do you tell what parts of the name are what? If you can't tell, then SQL Server has no chance. Honestly, if you need names to be in...

I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram,...

Under General Configuration Properties in visual studio to target your version of SQL Server . you can find the sql server...

Why not refer to documentation for what is does? As for what is a good reason to use it in a VIEW, I'm not sure what you really mean....

Why are you using a loop at all would be my first question. Also, please don't put your content in a code block (unless it's code of course); it makes...

Sounds like the value is also in some kind of "time format" in your CSV file then, as is the column is a varchar, presumably the value in the text ...

So what's wrong with putting your subtraction expression in your outer query? Subtraction in T-SQL works like any other language: {Expression} - {Expression}.

The problem appears to be you8 are relying on the default schema of a user to change the behaviour of your objects; that is the real problem here. You should...

Some sample data (for the table you've provided DDL for), and expected results (for your different scenarios) will really help here. I wouldn't want to guess the wrong thing.