Okay so a lot of people have posted a similar question, however I don't seem to be able to find a solution to my problem in any of them. So this is my situation. Yesterday I was working with my SQ...

I always find it confusing to add foreign keys to primary table in Management Studio. Lets say I have a Table1 { ID int, -- Primary Key Table2ID int, -- Refers to Table2's ID } Table2 { ...

I have several long queries in SQL Server Management Studio. If my connection is lost/broken (e. g. after Restore of the database), how can I reconnect my SQL query tab to the database? My context ...

I want to add a new trigger to my table. As seen in the picture, New Trigger button is not active. new index, new column, new contraints, new statics is active. I do not understand what is the p...

I can't use the most basic procedure, show, as it throws an error: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'show'. I used: SHOW DATABASES Please help me find a...

I have run into something quite odd, i haven't had this issue before, or maybe i'm missing something here. In SQL Server Management Studio 2012 i am trying to run a Query to create a new database ...

Inserting data into a Microsoft SQL Server database using Java, I got an SQL truncation exception. But the exception doesn't show which column had the problem value. Is there any way to find the e...