Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 32626
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
1
vote
0
answers
324
views
Phantom insert query
I have a log table which I have to clean up a bit because it is growing very fast.
While deleting some historical data I reached count zero for that condition on which I have deleted the entries. 5 m …
- 51
1
vote
0
answers
2k
views
Deny permissions for master in SQL Server
I created a new database on a SQL Server 2008 R2 instance and a login/user for it. I have set the user to db_owner so he can't view any other databases on that server but he can see and query the mast …
- 51
2
votes
2
answers
608
views
Deadlock occurring on database, SQL Server 2008R2
Last few days I had major problems with my production site, turns out deadlock occurred, every half an hour maybe 50-60 of them. To do a quick fix in order to keep the site running I set : ALLOW_SNAPS …
- 51
1
vote
2
answers
97
views
Known vulnerabilities for when a guest executes a stored procedure on SQL Server
I have a production database with crucial business information. Meanwhile, my company is involved in a project with some other company and we have to exchange some information on a regular basis. How …
- 51