Tag Info

New answers tagged

0

If I do a Paste Special, I get two options, Text and Unicode, and selecting Text seems to work properly, where as Unicode does not. as per comment by @JonSeigel


0

If your database is in READ_ONLY(which sounds like it is the case based on your error messages), then you need all files (both log and data) to attach it per the Technet documentation. If you look under the FOR ATTACH clause, it explicitly describes that "for a read-only database, the log cannot be rebuilt because the primary file cannot be updated. ...


7

This doesn't really seem all that crazy, but note that some of the UI dialogs might not have completely up-to-date information (this is why we have things like DBCC UPDATEUSAGE), and rounding can also be involved in some of those calculations. Finally, the dialogs show you total space for the whole database, but unallocated space is only calculated for the ...


0

I have fixed this problem in SSMSBoost add-in that I develop: http://www.ssmsboost.com/Features/ssms-add-in-sql-editor-contents-history Autorecovery information is saved for all - saved and unsaved docs. You can even navigate through editor contents history and track executed queries.


1

You can do something like below : declare @timer datetime select @timer = getdate() select @timer as QueryStartTime --- here goes actual query select * from sysdatabases --- end of query select getdate() as QueryEndTime select datediff(ms, @timer, getdate()) as TimeInMS Even though SSMS will show you how much time it took to execute the query, I have ...


0

A possible solution could be to run your query in a stored procedure (which usually has the added benefit of speeding up subsequent runs of your query, since the execution plan will be stored) and at the end of your SP, write something into a log table you created for that purpose. (Classic candidates could be name of the SP and getdate(), or even a result ...


1

Instead of relying on SSMS (its flakey sometimes - you might have to refresh, etc), always use T-SQL. Below script will provide you comprehensive result of what permissions you have set (filter out as per your need) /* ****I cant find the reference, but very descriptive script(I have it in my repository for years now - very useful for auditing).**** ...


0

See my comment above. I used Process Monitor to trace the registry access and found it was getting an Access Denied while trying to write: 3:16:40.8405491 PM sqlservr.exe 8756 RegCreateKey HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer ACCESS DENIED Desired Access: Write I got around this by opening the Registry ...


3

This: SET SHOWPLAN_XML ON; GO SELECT * FROM sys.objects; GO Is equivalent to pressing Display Estimated Execution Plan on the toolbar (or hitting Ctrl + L). You'll notice that no rows are returned from the query, like there is when you use Include Actual Execution Plan (Ctrl + M). The spill warning is only a runtime warning. There is no way that SQL ...


6

It's definitely SQL Azure. You can easily recognize it as the icon is azure, unlike the green one for a regular SQL Server instance You can see the the video by Thomas LaRock here How To Connect to SQL Azure database using SSMS


4

I believe (and someone should hopefully correct me if I'm wrong) that you're connected to an Azure SQL DB hosted on Azure, rather than a SQL Server database as shown here



Top 50 recent answers are included