Viewing 15 posts - 241 through 255 (of 295 total)
Both! We use SSMS for developing/testing. When a project is ready to go into UAT, the changes from development are put into the project in Visual Studio so that they...
March 27, 2015 at 7:48 am
The correct number is zero!
March 23, 2015 at 9:10 am
In case it helps anyone with a similar problem, here is the closing summary from MS support.
Technical Summary : on one of your server, the observed EXECUTE permissions didn’t match...
January 20, 2015 at 1:26 am
As an antidote to Jeff's quick interview technique; the shortest one I ever had was for a contract position. My backside had barely touched the chair when the interviewer asked...
January 9, 2015 at 1:50 am
As I said, we've had to take the stance that we're not going to spend more time on it. This was the latest MS response (they think the problem may...
January 8, 2015 at 2:42 am
It is a member of other groups with server logins, but none of these are linked to users in the database. The permissions, etc. currently in the database are a...
January 8, 2015 at 2:25 am
Just in case someone else stumbles on this thread, I thought I ought to update it. The problem has been escalated through several layers of Microsoft support to no avail....
January 8, 2015 at 2:01 am
It also depends on the industry your company is in. Some, such as finance, require a clear separation of duties between those who develop software and those who release it...
December 11, 2014 at 1:18 am
You should be able to do what you are trying to do; I've done this myself before. Having created the local temp table in one stored procedure, it will be...
December 9, 2014 at 1:23 am
If they're allowed to specify the "from <table> join <some other table>" part, then it's not just the lack of a WHERE clause that you need to worry about. I...
October 21, 2014 at 7:54 am
Anyone else feeling a bit sorry for OP? He's just starting out, asks a question and ends up in the middle of an esoteric sh1t-storm!
October 20, 2014 at 2:05 am
You don't have #table or @table in your original post so it clearly isn't the whole procedure. Please post the full definition of the stored procedure and the definition of...
September 5, 2014 at 7:42 am
Ignore - should have re-read the question!
August 8, 2014 at 7:44 am
My guess (based on bitter experience); it is an audit table populated by an AFTER UPDATE trigger and something is updating the source table without a WHERE clause.
August 7, 2014 at 8:03 am
Could it have been a before/after test for the addition of a primary key or unique index? It would fail if the table has either.
August 7, 2014 at 7:44 am
Viewing 15 posts - 241 through 255 (of 295 total)