Sounds like you need to grant the execute permission to the user (or a group that they a part of) for the stored procedure in question. For example, you could grant access thus:
Instead of ‘2013-04-12’ whose meaning depends on the local culture, use ‘20130412’ which is recognized as the culture invariant format. If you want to compare with December 4th, you should write ‘20131204’. If you want to compare with April 12th, you should write ‘20130412’. The article Write International Transact-SQL Statements from SQL Server’s documentation explains how to … Read more
I had this problem with an ASP.NET MVC app I was working on. I realized I had recently changed my password, and I was able to fix it by logging out and logging back in again.
I have tested the following and this does work. The answer by gordyii was close but had the multiplication of 100 in the wrong place and had some missing parenthesis.
Optimistic Locking is a strategy where you read a record, take note of a version number (other methods to do this involve dates, timestamps or checksums/hashes) and check that the version hasn’t changed before you write the record back. When you write the record back you filter the update on the version to make sure it’s … Read more
I’m getting this error msg 8115, level 16, state 2, line 18Arithmetic overflow error converting expression to data type int. with this SQL query
Use the INFORMATION_SCHEMA.TABLES view to get the list of tables. Generate Drop scripts in the select statement and drop it using Dynamic SQL: Sys.Tables Version Note: If you have any foreign Keys defined between tables then first run the below query to disable all foreign keys present in your database. For more information, check here.
To start with you can’t do this: The HAVING clause can only contain things which are attributes of the aggregate groups. In addition, 1, 2, 3 is not valid in GROUP BY in SQL Server – I think that’s only valid in ORDER BY. Can you explain why this isn’t what you are looking for:
Try ISDATE() function in SQL Server. If 1, select valid date. If 0 selects invalid dates. Click here to view result EDIT : As per your update i need to extract the date only and remove the time, then you could simply use the inner CONVERT or EDIT 2 : The major reason for the error will be in your … Read more
I have a website on HostGator and a dedicated server of my own running SQL Server 2008R2. The connection string I use is X.X.X.X,1433 which points to the IP address of my dedicated server. I have made the firewall settings on my server so that I can use SSMS & log into SQL Server from … Read more