6,756 reputation
11248
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 10 months
seen 4 hours ago

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


8h
comment Problem Getting Simple Replication to Work in SQL Server 2008/2012
With SSCM you might actually try setting to local system (applying and restarting) and then put it back to the account you want it to be. It does not necessarily apply the permissions to everything by just applying a password.
14h
comment Backup table is larger than original table
Can you script out both tables and see that they are in fact the same (data type, length, etc.), just to make sure?
1d
awarded  sql-server
1d
comment How to recover Database System MDF and Ldf files and transaction ldf lifes
@Att, where Mark is coming from is the fact that there are to many unknowns (i.e. an encryption activity) in this situation on our side for us to come into complete understanding of what was actually done on your production server, and to get us to that level of understanding in your situation and then provide a solution that will get you back up and running is not a format for this Q&A site.
1d
reviewed Approve suggested edit on How to pass output of one stored procedure to the input of another
1d
comment Finding Microsoft Access Database Connection
Also can be ODBC connections local on the client machines either system or user DSNs.
1d
awarded  Revival
1d
comment Backup table is larger than original table
Execute DBCC UPDATEUSAGE, is same size returned?
1d
answered What is my database name?
2d
comment Clustered Column store table Delete error
I am not seeing an error noted in the question.
2d
comment How to recursively find gaps where 90 days passed, between rows
Include the definition of the UDF that you have so far.
Nov
20
comment Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to 4G?
You might run DBCC UPDATEUSAGE (DB) as SSMS will sometimes get out of sync for those numbers.`
Nov
19
answered Run a PowerShell script on a different server - from inside a SQL Server job
Nov
19
comment Need some questions to show some trends
If you can't come up with your own questions about that dataset pick another one. There are datasets out there on almost everything with weather to baseball.
Nov
17
comment SQL Server 2012: stored procedures permissions
Connect is not a permission for procedures, only the database. Are you referring to execute permissions?
Nov
16
reviewed Close SQL Delete duplicate rows based on column
Nov
16
reviewed Close Question about logging architecture
Nov
16
reviewed Close Choose a Data Synchronization Technology SQL Server to SQL Server
Nov
16
reviewed Close How to load multiple values in cell from Excel to SQL Server many to many table
Nov
16
reviewed Reject suggested edit on With SSD's and in memory tables, does a snowflake schema become preferred over a star?