Database

I suspect the OP is either doing a training excercise or, Ghu forbid, writing something for a friend in need, one does not know retail and the other does not know software, fun times. Never underestimate the power of human stupidity RAH

Nathan Minier wrote: I just don't assume the technology that mucks with the data will be a UI :) "Any kind of client" then :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

I meant that dropping an index is less likely. Just like a sudden hardware change. Still possible, just less likely. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Yes I did it thanks a lot Rich Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

But that has to be some sort of record? ... a link to a 10 year old question :laugh:

Is this still a problem?

Problem solved. The key was that it wasn't saying it couldn't find msjter35.dll (the file was clearly there) it was saying it couldn't load it. After some digging, I discovered that msjter35 has a dependency on msjint35.dll and it was that latter file that was missing. I have no idea how the machine was delivered to me in this state, but copying msjint35.dll to SysWow64 solved the problem. Thanks for your interest. Keith

I presume that you mean when you are in an editor and start a new proc. Rather certain that Visual Studio provides that straight out of the box. Certainly has for a very long time for other languages like C#. There is or at least was something named something like 'template' which was invoked every time one created a file of a new type.

I tested your script in SSMS-2017. It gives me 9 records. BTW, perhaps you should scroll the "result" window to see the last row?

With as little information as you have supplied this may give you some ideas. select * from Employee where DepartmentID =( select top 1 DepartmentID from( select DepartmentID , count(*) C from Employee group by DepartmentID) x order by C desc) Never underestimate the power of human stupidity RAH

Thanks for your help and reply but I think the solution isn't to change the security setting on the email group - it is to ensure that the user authentication is completing successfully. This is what I have no idea about how to check. A reboot of the node may resolve it but I'd like to think it may be caused by a SQL Server user configuration setting that I can test/change and resolve without the need for a reboot. I'd like to understand more about the problem as I don't have much knowledge of diagnosing this user configuration/authentication.

John 13564154 wrote: Where is the wiki? Regards. We don't have one; I was referring to this[^] wikipedia article. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

I'd start with linkedIn

That doesn't answer my question. I just wanted to know if the ssms for 2016 (or most recent version) would let me work with the 2008 instances. ".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

Help with what? That's just the way that feature works. Prior to SQL Server 2016 SP1[^], there's no CREATE OR ALTER PROCEDURE statement. And as the documentation[^] says: "The CREATE PROCEDURE statement cannot be combined with other Transact-SQL statements in a single batch." Which means there's no way to do a CREATE / ALTER within an If block. So the only option is to execute a string. If you're willing to manually change the output, you can reduce the duplication slightly: DECLARE @statement nvarchar(MAX) = N'/****************************************************************************************************/ ... '; IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[Usp_Add_AddressCommunication]')) BEGIN SET @statement = @statement + N'CREATE '; END Else BEGIN SET @statement = @statement + N'ALTER '; END; SET @statement = @statement + N'PROC [dbo].[Usp_Add_AddressCommunication] ...'; EXEC dbo.sp_executesql @statement = @statement; "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Google for the following. Select computer and search. Create an account and look at full job descriptions. Should provide an idea. "Altus group" jobs However the functionality can be implemented in a variety of different ways. The specific technology does not limit it.

needAbreakNow wrote: and am tempted to just skip it Versus what? If you create a composition then that can be rather complicated as well. Perhaps you are comparing it to simple cases like when you want to add just one parameter? If so I would say that consistency of usage overrides the ease of one-off cases.

I think that Ascending is the default order for all SELECT clauses.