Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Newest
 Supporter
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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