Comments
Sort by recent activity
Okay, problem solved! There was something wrong with my license at Red-gate. So they gave me an extra license for the DLM Automation Script product. Problem solved ... / comments
Okay, problem solved! There was something wrong with my license at Red-gate. So they gave me an extra license for the DLM Automation Script product. Problem solved ...
Hi Eddie, You are absolutely right! I was of the impression that if I had the application installed on my PAS then it wasn't necessary to have it installed on my PSS. Thank you very much for the answer and the explanation. Case closed! / comments
Hi Eddie,You are absolutely right!I was of the impression that if I had the application installed on my PAS then it wasn't necessary to have it installed on my PSS.Thank you very much for the answe...
Keith_J, I recall that I had the problem on a database on a server, which was a copy of another database on the same server. Basically I had backed up a database on server and restored it with another name on the same server. Is that the same issue? Because if it is, it might give Red-gate a hint about what the problem is. I never got the problem solved - but the problem only exists on the one, copied/restored db. / comments
Keith_J,I recall that I had the problem on a database on a server, which was a copy of another database on the same server.Basically I had backed up a database on server and restored it with anothe...
Lenka wrote:
I just installed SQL Management Studio 2016 and updated my SQL Prompt to 7.2.0.260. SQL Prompt works fine for the snippets and for the SQL built-in functions, but it no longer shows any of the objects in my database or their columns, in either 2012 or 2016.
Having the same problem. Sometimes it seems to restart MSSMS and then it works for another 15-20 minutes. Now and then the all suggestions (like ssf) are gone but right now it is "only" my database objects (table names, column names etc).
I even had a strange experience where pressing the ENTER key would paste my text from the clipboad into my script and pressing other keys also behaved oddly. A restart of MSSMS solved that.
Using MSSMS 2012 version 11.0.6020.0
and SQL Prompt 7.2.4.291 / comments
Lenka wrote:
I just installed SQL Management Studio 2016 and updated my SQL Prompt to 7.2.0.260. SQL Prompt works fine for the snippets and for the SQL built-in functions, but it no longer show...
I know this is an old post, but I have taken the liberty to improve it a little. Now you will be prompted for the cursor name, so you dont have to copy/paste it down through the code.
DECLARE $CURSOR$--@Variables
DECLARE <Cursor_Name, varname, Cursor_Name> CURSOR
FOR /*Select Statement*/
OPEN <Cursor_Name, varname, Cursor_Name>
FETCH NEXT FROM <Cursor_Name, varname, Cursor_Name>
INTO --@Variables @FETCH_STATUS = 0
BEGIN
/*SQL Statements*/
FETCH NEXT FROM <Cursor_Name, varname, Cursor_Name>
INTO --@Variables
END
CLOSE <Cursor_Name, varname, Cursor_Name>
DEALLOCATE <Cursor_Name, varname, Cursor_Name> / comments
I know this is an old post, but I have taken the liberty to improve it a little. Now you will be prompted for the cursor name, so you dont have to copy/paste it down through the code.
DECLARE $CURS...