186 reputation
6
bio website
location
age
visits member for 1 year, 10 months
seen Nov 10 at 17:41

Jul
23
answered Cannot Connect Using SSMS to Local SQL Server 2008 R2
Jul
23
comment Cannot Connect Using SSMS to Local SQL Server 2008 R2
There's a couple of possible solutions here: blogs.msdn.com/b/sql_protocols/archive/2009/03/09/…
Jul
23
comment Cannot Connect Using SSMS to Local SQL Server 2008 R2
If your app is still connecting to the server correctly then I wouldn't consider re-starting the service, as the issue is likely on the workstation you're running SSMS from. Try connecting specifically using TCP/IP (not named pipes) and see if the same issue occurs, there is an option to select the protocol under the connection properties tab of the connection dialog window.
Feb
8
comment SQL Server: reset all database tables
In our environment we always keep a baseline db with barebones lookups populated, every deployment we do starts with that baseline db, and all schema changes are synced to it. We also have the scripts to recreate this db and the lookups in source control, for versioning.
Feb
8
comment Quick way to validate two tables against each other
Is SSIS an option? It'd be fairly easy to read in the one table and do a lookup against the other.
Feb
5
awarded  Custodian
Feb
2
comment Who changed the size of the transaction log?
Here's an example of using the default trace to find out about log growth: strictlysql.blogspot.ca/2011/01/…
Feb
1
awarded  Scholar
Feb
1
accepted Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
Jan
30
revised Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
added 129 characters in body
Jan
30
answered Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
Jan
30
revised Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
added 205 characters in body
Jan
30
comment Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
@JonSeigel, yes we are using SqlDependency, and quite possibly incorrectly. I've added some additional information to the question regarding that.
Jan
30
revised Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
added 1357 characters in body
Jan
30
awarded  Supporter
Jan
29
awarded  Student
Jan
29
asked Error: 9245, Severity: 16, State: 1. / During the last time interval XXX query notification errors were suppressed
Jan
28
comment Primary filegroup is full SQL Server 2008
Do you have more physical disk space available? If so, check the SQL Server error logs and see if there is additional information on why the autogrowth failed.
Jan
23
awarded  Teacher
Jan
23
awarded  Editor