Hi Folks,
My understanding is that Microsoft acquired the rights to use and re-badge Sybase as SQL Server and since then have engaged in a substantial re-write as part of their commitment to it.
Is this correct and can anyone give me some dates ?
Thanks very much
B.Dimple
Senior DBA
The SQL SERver 2005 Standard Edidtion install CD and the MSDN CD distributedat the SQLServer Launch in Chicago are blank. Has anyone else had thisproblem and or requested replacements? If so, how.thanks muchMo
View 1 Replies View RelatedHi,
I want to build a task that does 3 things automatically at a fixed time interval:
1) Refresh the data (copy newly inserted data from a datamart to a datawarehouse)
2) Run a program (exe) to produce some external reports
3) Refresh an OLAP Cube with the new data so that users can access it
Basically, using SQL Server Agent, setting up steps 1 and 2 was pretty straightforward (for step 1, the main point of entry is a single sp).
I ran into some trouble figuring the easiest way to complete step 3. I created a DTS package with one object that updates the Cude on my server. This seems to be working fine. Then, I created step 3 in Agent and chose 'CmdExec' as the type of command. I then referenced the external exe 'dtsrun' to execute my DTS package.
Everything seems fine but I'm not sure I used the "best" way of doing things. Since the SQL Server Agent and DTS manager are both SQL Server tools (so is the Analysis services), I'm wondering if there wasn't an easier (thus more robust) way of completing my 3rd step?
Anyone? How is this done where you've worked?
Thanks,
Skip.
After re-installing SQL Server Express 2005 and the Toolkit BIDS will not launch. Windows is looking for a file devenv.exe. Does anyone know how to get around this problem?
View 5 Replies View RelatedLooks like I sucessfully downloaded SQL Server Express Edition w/Advanced Services SP2 on my Vista-based notebook. Took care of the prerequisites from downloading with Vista. I see the Configuration Manager, and Error and Usage Reporting. But......How do I launch SQL Server Express please?
Thank you!
Sandra Shokite
Hi
I am trying to use Association Viewer Control in
Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.
"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"
Is there anyone here who use
"Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ?
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
i am using VS2005 Version 8.0.50727.762 (SP.050727-7600)
and SQL Server 2005 SP2
thanks from now.
Cem Ãœney
Dear All,Access adp on sql-server 2000After upgrating to A2003 updating data with 1 perticular combobox causes theprogram to hangs without any error-msg.Traying to change te combobox recordsource i get this error:This version of Microsoft Access doesn't support design changes to theversion of Microsoft SQL Server your project is connected to. See theMicrosoft Office Update Web site for the latest information and downloads(on the Help menu, click Office on the Web). Your design changes will not besaved.The solution in :http://support.microsoft.com/defaul...kb;en-us;313298tolks about SP 'dt_verstamp007' but I have SP 'dt_verstamp006'What should I do.Is the failure of the combobox also caused by the absence of dt_verstamp007???Filip
View 2 Replies View Related
Hi,
I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:
******************************************************************
Your current SQL Server is not a supported version.
Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10
You need to upgrade to SQL Server 8.0 before continuing.
******************************************************************
Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?
Assad
Hi all,
I am trying to launch ReportViewer in a new browser window, using the attribute: target='_blank'.
Can someone tell me how?
Here is the complete URL for the report .
http://SServer1/ReportServer?/Primary Members/Detail Report&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&UserName=sobo1
I have a Question about this Version!
Is this true that only one Person can query the Server at the same time? ( 1CAL Lizense)
I wrote a .Net Appllication and now the Appllication need acces to the Server to Query Tables.
In the "Rush Hour" it is possible that more than 100 Person make Querys from that Application to the SQL Server at the same time.
I don´t understand the CAL Lizens because the SQLServer Express allows up to 20 connection!?
The SQLExpress is for free and allow more connections than a paid Version?
Or is a difference between connection ( through the Appllication) and Connection through the Management Studio ?
Thanks for HELP!!
Pseudocode
I have a query that executes just fine except that it won't recognize varchar(255) ( or any other value within the () ) and if I leave it off like this: varchar, then it executes but it leaves that value as 1 and that is just not very useful for my purposes. This also happens with anything else that requires () to add length such as char(), or nvarchar(), etc... Any ideas?
View 1 Replies View RelatedHi folks
I attended one of the SQL Server 2005 "Ready to Launch" parties a couple of years ago and was given a complimentary SQL Server Standard Edition CAL along with a copy of the SQL Server 2005 Standard setup DVD.
As there's no mention in the "Ready to Launch" pack of an included Server license I was wondering whether it is possible to install a copy of SQL Server 2005 on a standalone server and use the single CAL in a Production environment without having to purchase a Server license? The pack does include a Product Key - is this the Server license?
Thanks
Chris
Hello,
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server "
I keep getting this when trying to copy stored procs from one db to another on the same server. I am using the DTS wizard. I have been able to copy the tables but I need the sp's too, and there are too many to copy one at a time.
Help!
TIA,
Bruce
Pls tell me about the adjact difference between sql server 2005 and sql server 2008.
Why to upgrade for Sql Server 2008
In VS 2005, when we choose database connection, we can choose one of the above. My question is in what situations should we choose MS SQL Server Database File (SqlClient), and when should we choose Microsoft SQL Server?
I want to deploy a standalone desktop application with a backend database. Which backend database should I should and which of the above connection should I choose?
Thanks very much for your information.
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Hi
We are checking VB 9 (Orcas).
we connected to database created under with sql server 7. with this code
Public cn As New ADODB.Connection
Public Sub OpenDB()
cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")
End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).
Rgds
Pramod
hello all member
View 14 Replies View RelatedI'm not asking a lot. I just want to know if I can connect from anExchange server to a SQl server without having to use Access linkedtables. Surely MS must have had a look at this but I can't findanything out there.Help appreciated.Ginters
View 1 Replies View RelatedI installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally
View 10 Replies View RelatedI have just installed sql server 2005 but, now I have two types of server name: Microsoft SQL Server Developer EditionMicrosoft SQL Server Express Edition Which one should I use? Does it matter??thanks..
View 1 Replies View RelatedHi everyone,
Primary platform is Framework 2.0
Our vb application throws .dtsx by means of the usual methods.
When I want to run packages allocated in my Windows folder I use LoadPackage; when I want to run packages allocated in my MSDB I use LoadFromSqlServer and at the end of the day when
I want to run packages allocated in my File System SSIS folder I use LoadFromDtsServer.
Drawbacks come here according a "new sort of SSIS packages". I'm talking about those packages which are imported from Sql2k from
Database Engine->Management->Legacy->Data Transformation Services.
How do I launch this kind of SSIS packages??
I'm totally stuck with this. Or maybe the problem is easier: the ones aren't ssis but dts????????????????
Thanks in advance for your input,
does anyone know an easy way (or any way for that matter) to run a DTS package from an asp.net page?
I inherited a computer from a co-worker who left. On it she installed SQL Server 2005. The help system is chock full of references to the various and sundry tutorials that come with the product, but I can't find so much as a syllable about how one actually accesses those tutorials.
When I select Start, Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Tutorials, SQL Server Tutorials, it simply launches one of the help screens. That screen, and the ones it contains links to, describe the tutorials topics in great detail, but nowhere is there any explanation of how you actually launch the tutorials.
What am missing here?
Hi all,
I'm trying to launch a SIS package from a VBA macro in excel...now I launch the dtexec.exe from a shell but a have this error:
Started: 10.14.33
Could not load package "Package1" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
Source:
Started: 10.14.33
Finished: 10.14.49
Elapsed: 16.594 seconds
but all credential are correct...
any ideas ???
thanks in advance
Wolly
I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:
- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Here are the things I have checked/tried:
Ensured the .NET Framework Reliant components are enabled in the browser
Running the browser with a user account that is local admin on the workstation
MIME settings on IIS server look ok
I am not seeing any access denieds on my workstation (checked with file and regmon)
I am not seeing any failures in the security event log
For the test that I am doing, both the user account, workstation and server are in the same domain
Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?
Thanks
I need to know a few things about this..
1. What do I need running or available on SQL Server machine (presuming an Oracle client)
2. Has anyone done this and perhaps can give me some quidance?
3. Any concerns about going from outside a firewall to the Oracle instance?
Architecture is probably going look like this:
SQL -> ON INSERT Trigger -> business logic -> Call Oracle Procedure
Any help is appreciated, thanks!
JTGIS
Hi all. How can I create a Stored Procedure that will launch a DTS package that I have already built dynamically ?
I have a string already built and I need to put it in a SP because my application is php (linux) and the database is SQL Server on a Windows machine.
I will use php to execute the stored proc, which is the only way to access it.
My string looks like this :
C:Progra~1Micros~380ToolsBinnISQL.EXE -S [MyServer] -U [Username] -P [Password] -Q "ISQL_Batch 'D:DDFIImporteIMPICAFI.bat [user] [Schema] [Pwd] '" -n -d [database]
(Words in [] are only to show that I will put other values)
Thanks
CFGilles
Poor me :o I have to share a home PC now so cannot have things my own way. When using my own PC I had SQL Server 2005 dev edition run on start up. Now I am sharing it seems rather churlish to not have it start on demand.With 2000 you got a little icon in the taskbar that indicated the status of SQL Server and a quick right click -> start was all you needed to get the little fella up and running. With 2005 you need to go all the way to configuration manager and start it. I have four options:#1 - a few mouse clicks to start SQL Server via configuration manager (unacceptable - imagine all the wasted time and RSI!)#2 - bat file to start SQL Server (ok)#3 - more sophisticated little app that shows the status of SQL Server in the taskbar and allows me to start it (nice but a pain to put together)#4 - something much spiffier which one of you gurus can let me in on I am sat on the edge of my little seat in anticipation :)
View 1 Replies View RelatedhiI have a scenario where I have created a stored procedure wich task isto search in my database with certain criterias. For each record fromthis search, I want to run a couple of other stored procedure.Here is some code:decare $myid nvarchar(15)select id, desc, customer from project where customer = 'cust1'--------------------------------------------HERE IS CODE MISSING----------------------------------------------for each of the records returned, I want to run 4 stored procedureswith the id as parameter.beginexecute StoredProcedure1 $myidexecute StoredProcedure2 $myidexecute StoredProcedure3 $myidexecute StoredProcedure4 $myidendThe problem is I don't know how to get hold of the result set and loopthrough. Maybe you can help me.regardsRoger
View 6 Replies View RelatedI am having problems launching the Report Builder. I click the button and nothing happens. I did see the other suggestions about re-installing the .NET 2.0 Framework but that did not help. I tried to launch it directly from the address bar and I am getting the same reponse as when I click on the Report Builder button. I can access the Report Builder from other machines and it works fine. I did just recently install IE 7 and I tried to uninstall it and go back to IE 6 but I got the same results.
Any help would be appreciated.
Thanks Tim
I've SQL instance used for Telecom Software, that SQL instance kept to run automatically consume 2 GB RAM and slow my machine..How could I configure it to lunch only when I open my Telecom Software and to close when I exit it.
View 9 Replies View RelatedI use one-way Transactional Replication on 38 servers with same configuration.
On one server I have problem with OSQL.EXE path.
On
Publication properties ->
snapshot ->
Additional scripts ->
Before applying the snapshot, execute this script:
Is set preinit script (C:ReplDataReplPreInit.sql).
On Distribution agent properties -> step "Run Agent"
I set additional command for log problem.
command= -Output C:ReplOutFile.txt -Outputverboselevel 2
Here is part of ReplOutFile.txt:
--------------------------------
The osql command is: "C:Program FilesMicrosoft SQL Server80ToolBinnosql.exe" -U"***" -P"***" -i "\STROSBBReplDatauncSTROSBB_antikor_DataCDB20060908104051ReplPreInit_0.sql" -S "BTSVR" -d "AntikorCDB" -o "C:WINNTTEMPReplPreInit_0.sql_20060912150416.log" -b -X1
Launching osql to apply the script 'ReplPreInit_0.sql'
[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 3, ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x00)}
Agent message code 20130. Failed to launch 'osql'
[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 4, 0x01, 0x01)}
Adding alert to msdb..sysreplicationalerts: ErrorId = 1233,
Transaction Seqno = 00000491000618f4007000000001, Command ID = 4
Message: Replication-Replication Distribution Subsystem: agent STROSBB-antikor-BTSVR-1 failed. Failed to launch 'osql'[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_repl_alert(3, 1, 1233, 14151, ?, 4, N'STROSBB', N'antikor', N'BTSVR', N'AntikorCDB', ?)}
ErrorId = 1233, SourceTypeId = 3
ErrorCode = '3'
ErrorText = 'The system cannot find the path specified.
--------------------------------
Problem is that the path to osql command in log ReplOutFile.txt is
C:Program FilesMicrosoft SQL Server80ToolBinn
but SQL is installed on path
C:Program FilesMicrosoft SQL Server80ToolsBinn
Diferences is between Tool vs. Tools
I think that when server create OSQL command for preinit sql script he use STATIC path to osql.exe and there is my problem.
Where is this path stored and can I change it?