Activity overview
Latest activity by rayherring
Your constraint is actually a column constraint. If you want it to be a table constraint you need to precede it with a comma. See the BNF in BOL for Create Table.
I know that it seems a unique constraint could only be a Table level constraint but the syntax clearly allows it to be defined as either a table or column constraint.
And just to add to confusion both forms create a table level constraint object [image] .
I imagine that SQL Prompt just treats your format is as part of the column definintion. Try it by adding a perceding comma and see how the format changes.
HTH / comments
Your constraint is actually a column constraint. If you want it to be a table constraint you need to precede it with a comma. See the BNF in BOL for Create Table.
I know that it seems a unique co...
But I like the feature [image] / comments
But I like the feature
I noticed that there are some deadlocks that spill out of the window and I can't scroll to parts. I have an "e_waitPipeNewRow" deadlock with 6 threads. The upper two process blocks are off the top of the screen. If I zoom out I can see they are there but I can read the Geeked Text. When I zoom in I can't pan up to them. [image] . / comments
I noticed that there are some deadlocks that spill out of the window and I can't scroll to parts. I have an "e_waitPipeNewRow" deadlock with 6 threads. The upper two process blocks are off the to...
SQL Backup could not access [HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(L
I have restored many backups on this particular server using the same credentials since day 1. Now this error appears.
I remoted to the server using the service account credentials and I was able ...
Personalized options get reset IntelliSense and SQL Prompt
Hi All, I have an SSMS issue. My Laptop is Win 10 Pro, 64Bit - Build 14393. SSMS is 13.0.16100.0 with IntelliSense enabled . I also use Red Gate SQL Prompt (Build 7.4.1.03). My issue is that my...
I have two issues related to this topic.
First, when I use SSMS 2008R2 to connect to the Compact Edition database I am prompted for a password. I have tried my Backup Agent account password, the SQL Engine Account password, and the SQL Agent password with no luck.
What is the password for this file and where/when/how is it set?
Second, when I tried to connect with SSMS 2014/2016 I don't see a entry for Compact Edition in the Connect dialog. Is this really true?
Thanks, / comments
I have two issues related to this topic.
First, when I use SSMS 2008R2 to connect to the Compact Edition database I am prompted for a password. I have tried my Backup Agent account password, the S...
I appreciate the difference between Announcement and Topic. However, the release announcements still take up a lot of real estate. Do you really need announcements for >10 prior releases? / comments
I appreciate the difference between Announcement and Topic. However, the release announcements still take up a lot of real estate. Do you really need announcements for >10 prior releases?
Thanks / comments
Thanks
Release Announcements
The version release announcements take up more than half of the initial page. Surely the most recent 2 or 3 announcements would be sufficient. Do you really need to post 12+?
This same issue is what prompted me to start depending on scripts and the extended stored procedure to refresh QA, Dev, and Staging environments.
It is a real pain when the GUI changes even the physical file names. / comments
This same issue is what prompted me to start depending on scripts and the extended stored procedure to refresh QA, Dev, and Staging environments.
It is a real pain when the GUI changes even the phy...