Viewing 15 posts - 1,756 through 1,770 (of 49,571 total)
Click the Edit menu in Management Studio. Select Intellisense (at the bottom) and then Refresh Local Cache. (Ctrl-Shift-R as a shortcut)
It's purely the delay in SSMS refreshing the...
February 21, 2017 at 1:37 am
Rankerg - Monday, February 20, 2017 12:25 PMusually we don't have test /development server so can I still enable debugger?
You can....
February 20, 2017 at 2:24 pm
And keep in mind that even if the DMV shows both are used (and it probably will), the smaller index may not be necessary and removing it probably won't hurt...
February 20, 2017 at 3:32 am
Debugging requires sysadmin permissions, and it is NOT something you want to be doing on production. Get yourself a development environment and test there. There's no good reason to be...
February 20, 2017 at 3:01 am
pietlinden - Sunday, February 19, 2017 12:57 PMCan you name the constraint when you declare it that way?
Yes you can. Just add...
February 20, 2017 at 12:08 am
Normally when I create tables with foreign keys, I'll specify the foreign key as part of the column definition. Keeps everything in one place.
egCREATE TABLE...
February 19, 2017 at 11:38 am
February 17, 2017 at 2:35 am
BLOB EATER - Friday, February 17, 2017 12:44 AMI so want to know.... its searching time I guess.
Nope, not online.
February 17, 2017 at 1:49 am
Aaaahhhhh!!!!!!
I'd rant, but the people in question might see this, and that would not be a good thing, so I'll just stick to AAAaaahhhhh!!!!!
February 16, 2017 at 2:49 pm
Siten0308 - Thursday, February 16, 2017 1:44 PMbig thanks SSChampion for your help 🙂
btw, the person who helped you is Perry.
Champion...
February 16, 2017 at 2:44 pm
Edit: Didn't notice it was SSIS. Should read properly.
February 16, 2017 at 6:52 am
February 16, 2017 at 3:53 am
Table definitions please & index definitions.
February 16, 2017 at 12:37 am
The error means that the login "my user" does not have access to the database named "Database name", check your DB security.
February 16, 2017 at 12:35 am
On a development environment, sure. Developers break development, they only inconvenience themselves.
Profiler permission on production, no way in hell. Profiler, the GUI at least, can cause severe problems...
February 16, 2017 at 12:32 am
Viewing 15 posts - 1,756 through 1,770 (of 49,571 total)