If you want to give your user all read permissions, you could use: EXEC sp_addrolemember N’db_datareader’, N’your-user-name’ That adds the default db_datareader role (read permission on all tables) to that user. There’s also a db_datawriter role – which gives your user all WRITE permissions (INSERT, UPDATE, DELETE) on all tables: EXEC sp_addrolemember N’db_datawriter’, N’your-user-name’ If … Read more
SSMS only allows unlimited data for XML data. This is not the default and needs to be set in the options. One trick which might work in quite limited circumstances is simply naming the column in a special manner as below so it gets treated as XML data. DECLARE @S varchar(max) = ‘A’ SET @S … Read more
This issue has been fixed in SSMS 16.5 build 13.0.16000.28 with the addition of an option to preserve CR/LF on copy/save (more details) (Connect bug). Tools > Options Expand Query Results > SQL Server > Results to Grid Tick Retain CR/LF on copy or save Restart SSMS This will cause CR, LF, and CRLF to … Read more
Try: Edit -> IntelliSense -> Refresh Local Cache This should refresh the data cached by Intellisense to provide typeahead support and pre-execution error detection. NOTE: Your cursor must be in the query editor for the IntelliSense menu to be visible.
I was able to get the full text (99,208 chars) out of a NVARCHAR(MAX) column by selecting (Results To Grid) just that column and then right-clicking on it and then saving the result as a CSV file. To view the result open the CSV file with a text editor (NOT Excel). Funny enough, when I … Read more
[Since this question will likely be closed as a duplicate.] If SQL Server hasn’t been restarted (and the plan hasn’t been evicted, etc.), you may be able to find the query in the plan cache. SELECT t.[text] FROM sys.dm_exec_cached_plans AS p CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t WHERE t.[text] LIKE N’%something unique about your query%’; If … Read more
Microsoft should advertise this functionality of SSMS 2008. The feature you are looking for is built into the Generate Script utility, but the functionality is turned off by default and must be enabled when scripting a table. This is a quick run through to generate the INSERT statements for all of the data in your … Read more
Please check the ServerName which you provided. It should match with the below shown Name in the UserName textbox, and that name should followed with \SQLEXPRESS:
It is a batch terminator, you can however change it to whatever you want
It is taking the value of hs_id from the outer query. It is perfectly valid to have a query that doesn’t project any columns from the selected table in its select list. For example select 10 from HotelSupplier where id = 142 would return a result set with as many rows as matched the where … Read more