ProfessionalAmateur's user avatar
ProfessionalAmateur's user avatar
ProfessionalAmateur's user avatar
ProfessionalAmateur
  • Member for 11 years, 4 months
  • Last seen more than a month ago
  • Denver, CO
6 votes
1 answer
2k views

Newly discovered SQL Server Express has all databases inaccessible/offline

5 votes
2 answers
886 views

If I update a column record in a table, will indexes that do NOT have this column in it be affected?

4 votes
1 answer
49k views

How to find which tables and views a user has access to?

4 votes
1 answer
5k views

When executing a command via xp_cmdshell what user issues the command to the system?

3 votes
2 answers
1k views

DENY access to EXEC for a role

3 votes
2 answers
56 views

Is my Publisher database my actual source database or is it a new database?

3 votes
2 answers
3k views

Restoring database from a server that uses data compression

3 votes
1 answer
12k views

Does this mean the 'public' has full select, insert, update, and delete access?

2 votes
1 answer
6k views

Could I realistically use SQL Server Express as a distributor database for transactional replication?

2 votes
3 answers
5k views

Dropped the Distibution database before disabling publishing and distribution, how to proceed?

1 vote
1 answer
850 views

Questions about PostgreSQL backup/restores

1 vote
0 answers
56 views

Help understanding SQL Server Developer License when users test via webserver [duplicate]

1 vote
1 answer
81 views

SMSS will start for one user, but not another?

0 votes
1 answer
669 views

How does the Distributor know you have seeded/initialized your Subscriber using a backup?

0 votes
1 answer
610 views

How does security context propagate between schemas within a database?

0 votes
1 answer
2k views

Query with PIVOT fails with second LEFT OUTER JOIN to same table