Microsoft's free version of their popular enterprise software, SQL Server. Targeted at smaller installations, SQL Server Express cannot be used on databases larger than 10GB, and cannot use more than a single processor.

learn more… | top users | synonyms

0
votes
0answers
27 views

Got error with lookup transformation in sql server 2005 BIDS

I have query to seperate the current and history DB's ** select , year(doj) from source where year(doj)<=(year(getdate())-3)* Here the moved data(<=2011) from current DB should be deleted and ...
0
votes
0answers
50 views

The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and sys.fulltext_catalogs

I am using sql server 2008 and when trying to restore .bak file I'm getting this error: The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and ...
0
votes
0answers
88 views

Import remote SQL Server 2008 Express database to local SQL Server 2008 Standard database

I would like to create a SQL Server agent job that would run every 10 minutes. The job would check for new records in a table on a remote database (linked server already created), if exist the job ...