117 reputation
4
bio website stackoverflow.com/users/…
location Illinois
age
visits member for 2 years, 1 month
seen Jan 27 at 14:30

I don't subscribe to social media norms... have a nice day.


Dec
18
comment Can I convert SQL Server 2008 full db to SQL Server 2005?
Simple web search returned a few artciles, this seemed most useful. sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx or sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/11/… Simply put it's a manual process.
Oct
3
awarded  Supporter
Sep
24
awarded  Autobiographer
Mar
17
comment Automatically keep synchronized copy of database
msdn.microsoft.com/en-us/library/bb902818(SQL.110).aspx compare and contract sync w/ replication. Depending on needs replication may be more robust than the sync solution or technet.microsoft.com/en-us/library/ms151198.aspx as lead in to first link
May
30
comment Execute output from query
Yes it's called Dynamic SQL and RDBMS.Execute(string) can execute dynamic SQL; but caution is needed as this allows SQL injection
May
30
comment Using something better than UNION for combining multiple queries
A better database model? if you're pulling in Like information why the seperation in the first place? could a field have been added similar to the table name to denote difference and "poof" all the unions are gone..
May
30
awarded  Editor
May
30
revised A database trigger is an alternative for?
added 120 characters in body
Feb
27
awarded  Teacher
Feb
27
answered A database trigger is an alternative for?
Apr
13
answered Setting up database structure for Students, Managers, and Administrators
Dec
20
answered Compare two oracle .dmp files