Like Jo said, I wouldn't just go changing your clustered index without considering the effect...

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

"Time" is part of the clustered index, but the clustered index, as stated in the first post, consists of total of 4 columns (bigint, int, varchar(255), datetime, in that...

So do you have index on Time ? Does it contain any other columns and INCLUDE the rest of the columns in the SELECT? Without the query, DDL of the...

Are you able to share the execution plan (Paste the Plan)? This'll help us understand what the RDBMS is up to, and see if there are any helpful indexes....

ALTER LOGIN YourLogin WITH DEFAULT_LANGUAGE = BRITISH;

Obviously changing the name of the LOGIN and language you need...

Not being American teaches you quickly that the format...

Have you tried using an unambiguous date format? '2021-11-01 00:00:00.000' is ambiguous with datetime. Try '2021-11-01T00:00:00.000' or just '20211101'.

The documentation you've link is for the Find (and Replace) tool, is that what you are using? I admit, :b does not work for me for tabs or spaces either,...

Pitfuls? A couple would be how to maintain it...

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 3 years, 1 month 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?...