New Technology
May 12, 2008If u know sql server. whats the next best technology to learn?
mysql, oracle or any frontend language?
Thanks Plesae only experts.
ADVERTISEMENT
Technology Used To Access The Database?
Aug 5, 2005in the world of .Net and J2EE , what is the Technology used to access the database ?
View 5 Replies View RelatedBackwards Technology(SQL 2005 - SQL 2000)
Feb 29, 2008Hi ALL
In my script below. I'm trying to update a SQL Server 2000 DB with data from SQL Server 2005. I've written a Cursor to call tables from information schema. Compare the data between 2005 and 2000 then Insert into SQL 2000 Table. But I'm getting The multi-part identifier "c.ID" could not be bound.. Can you please help me to resolve this.
DECLARE @TableName VARCHAR(255)
DECLARE @Sql VARCHAR(1000)
DECLARE TableCursor CURSOR FOR
SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES
WHERE Table_Type = 'Base Table' and Table_Name like 'L_%'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @Line VARCHAR(1000)
SET @Line = ''
SELECT @Line = @Line + 'c.'+ c.Column_Name + ' , '
FROM INFORMATION_SCHEMA.TABLES T
JOIN INFORMATION_SCHEMA.COLUMNS C
ON t.Table_Name = c.Table_Name
WHERE t.Table_Name = @TableName and t.Table_Name like 'L_%'
SELECT @Sql = SUBSTRING(@Line, 1, LEN(@Line) -1)
SELECT @Sql = 'SELECT'+ ' ' + @Sql
SELECT @Sql = @Sql + 'INTO dbo.L_BrokerTest'
SELECT @Sql = @Sql + ' '+ 'FROM'+ ' '
SELECT @Sql = @Sql + @TableName + ' ' +'A' + ' '
SELECT @Sql = @Sql + 'LEFT JOIN'
SELECT @Sql = @Sql + '[Blake-DBN12].Staging.dbo.'
SELECT @Sql = @Sql + @TableName + ' ' +'B'+ ' '
SELECT @Sql = @Sql + 'ON' + ' '
SELECT @Sql = @Sql + 'A.ID <> B.ID'
--PRINT @Sql
EXEC (@Sql)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
Need Direction On SSB Replacing Existing Technology
Oct 24, 2006Hello, I have an existing suite of applications in my company where remote laptop users enter data into a local database instance. There are several different applications with several different databases (some users run application A and C, others run A and B and D, etc). All of this data needs to make its way into both their local databases, and to the front office database. In addition, some of the data goes out of the front office to other end users (supervisors get data from people under them).
Currently, we get the data back and forth by creating text files full of SQL statements that are run on either the end user servers or the main server, and we zip and ftp these SQL Script files back and forth.
I am looking into the benefits of replacing this process with a Service Broker application, but I'm still too much of a newbie to understand how this might work. What should my messages contain? Should they contain the same SQL statements that are currently in the script files, and then a SSB process would grab the SQL and run it? Or should the message types be more specific to each application?
any pointers to articles that go beyond "here's what SSB is" would be appreciated.
matt tagliaferri
Is Ssis The Only Technology That Can Read/write Raw Data Type Files?
Sep 21, 2007I'm contemplating a sql server archive strategy that rolls really old data off any sort of dbms and onto low cost media like dvds in a non relational archive format. I dont want to ever worry about these archives spanning different versions of sql when i go to retrieve a range of data that happens to span sql versions (eg one disc was sourced from 2005 another by 2008 but my report needs a union of both).
So I'm thinking about neutral/efficient formats for these archives and a live homegrown catalog that can determine exactly what disc(s) need to be mounted based on passed from and to date parameters...all so that the data that might span discs (and versions and maybe even schemas) can be merged and loaded into my sql version d'jour's "throw away" archive database for a one time report or other unplanned activity.
I remember raw data types being very convenient as an ETL format for our customers who have ssis, but wouldn't want our sqlexpress customers to be left without the archiving capability. Do the "things" that read and write raw data files really originate in some special T-SQL command that all sql editions can use, or is it strictly an ssis thing?
InstallingSQL Server September 2005 Community Technology Preview ...errors
Oct 11, 2005Hi,
I am trying to install Microsoft SQL Server September 2005 Community Technology Preview.
I get the generic error saying "SQL Server 2005 setup has detected incompatibe components...."
So I checked the C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSQLSetup0020_Core.log file
which says
C:SQLENT2005Serverssetup.exe Version: 2005.90.1314.0
Running: LoadResourcesAction at: 2005/9/11 13:3:29
Complete: LoadResourcesAction at: 2005/9/11 13:3:29, returned true
Running: ParseBootstrapOptionsAction at: 2005/9/11 13:3:29
Loaded DLL:C:SQLENT2005Serversxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2005/9/11 13:3:30, returned true
Running: ValidateWinNTAction at: 2005/9/11 13:3:30
Complete: ValidateWinNTAction at: 2005/9/11 13:3:30, returned true
Running: ValidateMinOSAction at: 2005/9/11 13:3:30
Complete: ValidateMinOSAction at: 2005/9/11 13:3:30, returned true
Running: PerformSCCAction at: 2005/9/11 13:3:30
Complete: PerformSCCAction at: 2005/9/11 13:3:31, returned true
Running: ActivateLoggingAction at: 2005/9/11 13:3:31
Complete: ActivateLoggingAction at: 2005/9/11 13:3:31, returned true
Running: DetectPatchedBootstrapAction at: 2005/9/11 13:3:31
Complete: DetectPatchedBootstrapAction at: 2005/9/11 13:3:31, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__1952" returned false.
Running: PerformSCCAction2 at: 2005/9/11 13:3:31
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Product "{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1314
The Product Name is "Microsoft SQL Server Setup Support Files (English)"
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
I understand that I need to uninstall "Microsoft SQL Server Setup Support Files (English)"
But when I try to do that I get
"A network error occured while attempting to read from C:WinntInstallerSQLSupport.msi"
how do i fix this...
SQL Server 2005 Express Does Not Load On AMD Turion 64 Mobile Technology CPU Computer
Mar 24, 2008I have a user who is trying to load SQL server 2005 Express on a new Acer laptop computer. The computer has the following:
Windows Vista Home Premium 32 bits
AMD Turion 64 mobile technology CPU
1790 MB of RAM
When the user tries to load SQL server 2005 Express it does not load. The user after the load is getting an €œUnhandled exception has occurred in your application€? when he tries to run the application.
Does anyone know how to fix this problem?
Thank you,
Photomultiplier