117 reputation
4
bio website stackoverflow.com/users/…
location Illinois
age
visits member for 1 year, 9 months
seen Dec 5 at 19:20

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


2h
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
Dec
14
comment Which queries are running and what tables are they accessing?
stackoverflow.com/questions/55899/… would show the tables.
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