Reputation
346
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 7
Impact
~6k people reached

  • 0 posts edited
  • 1 helpful flag
  • 16 votes cast
Sep
24
awarded  Autobiographer
Apr
25
answered Distributed MS SSAS database?
Nov
22
awarded  Commentator
Nov
16
answered Option do not show schema names in SQL Server Management Studio
Sep
22
comment log file problem after query execution
If the log file does not shrink you can refer to log_reuse_wait_desc in sys.databases to determine what is preventing the shrink operation
Aug
10
answered Can connect to SQL Server remotely by port number but not by instance name
Aug
3
answered Cannot connect into WindowsXP on VMWare Fusion by IP
Jun
23
awarded  Yearling
Nov
24
answered MSSQL Certification 70-432
Nov
24
comment MSSQL Certification 70-432
I used the MS Press book which had quite a few mistakes and required extra reading to cover some areas. Also end of chapter questions where out of sync with the chapter content. Haven't used the book that mrdenny worked on but it's got to better than the MS one.
Aug
24
comment Index rebuild stored procedure fails while calling temporary table
How did you get on with this?
Aug
20
awarded  Citizen Patrol
Aug
16
comment Index rebuild stored procedure fails while calling temporary table
Just re-read your question and think this may not be relevant. Still leaving up just in case.
Aug
15
answered Index rebuild stored procedure fails while calling temporary table
Aug
12
comment Migrate SQL Server
Much better answer :)
Aug
12
comment Migrate SQL Server
Data files/Backups do not vary with architecture
Aug
12
answered Migrate SQL Server
Aug
12
comment Automatically add user to newly created database
I might be wrong but won't this add the user to all new databases on the instance too, just as adding to Model would?
Aug
12
revised How to set FK to all tables in SQL Server 2005?
added 57 characters in body
Aug
11
answered How to set FK to all tables in SQL Server 2005?