Which SQL Server Is Better... File Type Or Registered Server
Feb 23, 2006
Eventually with hosting in mind, what are the pros and cons of designing one's backend as a file ( within the Website directory) as compared to creating the database onthe egistered SQL server of the development machine?
e.g. If I go thru SQL Server express 2005 and create a new db say MyDb, it creates it on the default SQL server of my machine, (without prompting for the DB files physical location.. I'm sure one would have to search)
Is it the same as choosing between MSDE Vs SQL Server 8 in the VS 6.0 era? oris there more than meets the eye? Any known best practices, performance issues etc?
Thanks
----------- Too many clicks, spoil the browse -------------
View 4 Replies
ADVERTISEMENT
Feb 17, 2006
Hi all, i encountered this problem.. whenever i tried to create publications it always prompt me this error msg "sql server replications does not support nicknames,such "." or "(local)". i know i need to delete the registration and register a new server with a different name.. i just want to double confirm whether deleting the registration will affect the databases or not ? :
View 1 Replies
View Related
May 31, 2008
Hi all,
I am not sure this is the right place to post this, but I could find a better place.
I uploaded a document in the SQL Server (image datatype), but I was not able to save file Type since there is no field for that, and cannot change the database.
Now I download the saved file. Is there any way to extract file Type from the saved file (like from file header?) and open it with an appropriate program such as doc file with MS Word?
Thanks,
J
View 3 Replies
View Related
May 7, 2007
Trying to use OPENROWSET in 2005 to pull data from a 2000 server.
I have created a linked server named "ABC". But when I execute OPENROWSET I get an error message back:
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "ABC" has not been registered.
This is not my comfort zone, so any advice on what settings I need to use is appreciated.
e4 d5 xd5 Nf6
View 7 Replies
View Related
Nov 1, 2002
Scenario: I register a remote (across the internet) SQL server in Enterprise Manager with SQL Server authentication using the "sa" account. Does this mean that whenever I connect to it, my "sa" username and password gets sent un-encrypted (cleartext) across the internet?
My guess is, yes, and that the only way to avoid this is to set up a VPN between my local LAN and the remote SQL server.
View 2 Replies
View Related
May 15, 2006
I have SQL Server 2000 installed on one hard drive. I just installed SQL Server 2000 to another hard drive. I'd like to be able to transfer all the registered servers (including the group they belonged to) to the new SQL Server. Is there an easy way to do this? Otherwise, it seems that I have to go to "Client Network Utility" and register each server again, which are a lot of servers.
View 2 Replies
View Related
Jun 12, 2006
Under sql 2000 I needed to register my sql server before I could begin working with it under Enterprise Manager. Under sql 2005 I usually setup the server under "Object explorer" and work with it from there. So what does registering a server under sql 20005 do? Why is it needed?
TIA,
barkingdog
View 4 Replies
View Related
Mar 14, 2014
Is it possible to write a stored procedure that will be used registered server?
For example I have registered server named 'Test Servers' and I want to use it in stored procedure
View 3 Replies
View Related
May 9, 2008
Hi all: I am getting the following error when I try to review the deployed reports on localhost.
"An error has occurred during report processing.
An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server."
I checked the report manager, and for "connection type", there is a warning message as shown below:
"The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly."
I will appreciate any help in this regard.
Thanks
Reez
View 1 Replies
View Related
Jul 23, 2007
SP2 for SQL Server 2005 x64 has been less than happy for me.
The initial problem, mentioned in another thread, concerned SSIS client which stopped liking Data Flow components. It was solved by a removal and reinstallation of the client tools.
However, there now seems to be a problem with making use of the Teradata oledb provider within SSIS. Prior to the installation of SP2 there was no problem.
I create a new SSIS package
Add a Data Flow component
Within the data flow add an oledb source
Create a new connection - using the Teradata oledb provider
Test the connection (it works!)
Use SQL something like "select * from some_teradata_table_on_the_TD_server"
Click on columns, wait a second, a list of columns is returned
Add a SQL Server destination (with a new SQL Server connection)
Connect the two components
Save the package
Click go
The TD oledb source component turns bright red and the error is "class not registered"
I have uninstalled the TD oledb provider (and underlying TD components) and re-installed (32-bit and 64-bit) - no change
Any ideas?
- KjM
View 7 Replies
View Related
Aug 3, 2007
Hi All,
I have SSIS package which loads excel data in SQL server. Now when I execute the package by double clicking it(GUI Utility for Dtexec) or by running it in SSIS Editor it works great.
However if I run it using the command line dtexec.exe then following error arises. Note that machine on which I am executing does not have Microsoft Office installed and is 64 bit.
Error: 2007-08-03 16:53:27.42
Code: 0xC0202009
Source: PkgExtract Connection manager "SRC_Connection"
Description: An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2007-08-03 16:53:27.42
Code: 0xC020801C
Source: Data Flow Task - Extract Data Excel Source [1860]
Description: The AcquireConnection method call to the connection manager "SRC_Connection" failed with error code 0xC0202009.
End Error
Error: 2007-08-03 16:53:27.43
Code: 0xC0047017
Source: Data Flow Task - Extract Data DTS.Pipeline
Description: component "Excel Source" (1860) failed validation and returned error code 0xC020801C.
End Error
Any pointers or help is greatly appreciated.
Thanks
Sid
View 11 Replies
View Related
Oct 29, 2007
I am attempting to deploy a sample report (SQL 2005 Workgroup w/SP2) and I am receiving the subject error message when I attempt to view the report on the web server. We are using SQL Server 2005 Workgroup Edition connecting to an Oracle database.
Is this a limitiation of this version? In report designer, I am able to select Oracle as a connection type. If I try to create a data source at the server, "Microsoft SQL Server" is the only option available. If I look at the ReportServer config file, I see many other data connection types available. Did I miss a step, or is this a Workgroup Edition limitation (it's not documented as a limitation that I am able to find)?
Thanks in advance...
View 1 Replies
View Related
Jul 3, 2007
Hello
I have recently downloaded Orcas beta VS product and had no previous version of VS before. The install went clean and I have been able to generate Window apps and web apps with very little issues; however, I have one issue with running a web app using the "view in browser" option for checking an aspx page for validity. If I use the default Northwind database provided and generate an aspx form using the "DataSet" toolbox widget, the tool prompts for the datasource etc. required to generate the required code. I can select the Northwind database and select the desired columns from one of the tables. Once completed, I build the project (clean build) and then select the "view in browser" option to verify the results. The result is an error page indicating a server error ->
Failed to find or load the registered .Net Framework Data Provider.
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: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.
I created on odbc connection to an iSeries(as400) box and was successfull in displaying the table on the webpage! I looked into the web.config file and it appears that all the required XML data is present. Any help would be appreciated as I am fairly green when it comes the .NET world.
Thanks
View 5 Replies
View Related
Sep 10, 2007
I have one column in SQL Server 2005 of data type VARCHAR(4000).
I have imported sql Server 2005 database data into one mdb file.After importing a data into the mdb file, above column
data type converted into the memo type in the Access database.
now when I am trying to import a data from this MS Access File(db1.mdb) into the another SQL Server 2005 database, got the error of Unicode Converting a memo data type conversion in Export/Import data wizard.
Could you please let me know what is the reason?
I know that memo data type does not supported into the SQl Server 2005.
I am with SQL Server 2005 Standard Edition with SP2.
Please help me to understans this issue correctly?
View 4 Replies
View Related
Aug 13, 2007
Hello,
I'm trying to build a integration service package importing data from XML files and directs this data to different MS SQL server 2005 Database tables.
Can someone suggest me what is equivalent(mapping) data type of DT_UI8 in Sql server 2005 for Integration Services.
Or how to consume DT_UI8 fields in SQL server 2005.
View 2 Replies
View Related
Oct 23, 2006
Hi All,
I am manually replicating parts of a SQL Server CE database (running windows mobile 5.0) to a centralized SQL Server 2000 database.
My program is throwing an exception whenever I try to insert an image data type into the 2000 server from the PDA. I am using parameterized queries.
Error is as follows:
[error]
System.Data.SqlClient.SqlConnection.OnError()
at
System.Data.SqlClient.SqlInternalConnection.OnError()
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at
System.Data.SqlClient.TdsParser.Run()
at
System.Data.SqlClient.ExecuteReader()
at
System.Data.SqlClient.ExecuteNonQuery()
at
PDASync.Database.ExecuteIDRemote()
[/error]
The code for my ExecuteIDRemote method works fine for other queries. It also works if I remove the image column from the offending query.
Does anyone have any suggestions? Thanks.
View 1 Replies
View Related
Oct 20, 2006
Hi,
i'm
running Microsoft SQL Server 2005 express edition. I'm trying to create
a new SQL server mobile database for my smartphone. when i launch
Microsoft SQL Server 2005 express edition, i was prompted to connect to
a server. But i can't choose Server Type as 'SQL mobile server'. My
server type is greyed out as 'Database engine'. i've already installed
SQL server mobile SDK and SQL server mobile tools.
i was following this guide :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/road03242004.asp
My
2nd question is how do i go about exporting a desktop version of a
database to my smartphone? I need to convert it to the mobile version
first right?
Any help would be greatly appreciated!!
thanks!!
View 1 Replies
View Related
Oct 19, 2006
Hi,
i'm running Microsoft SQL Server 2005 express edition. I'm trying to create a new SQL server mobile database for my smartphone. when i launch Microsoft SQL Server 2005 express edition, i was prompted to connect to a server. But i can't choose Server Type as 'SQL mobile server'. My server type is greyed out as 'Database engine'. i've already installed SQL server mobile SDK and SQL server mobile tools.
i was following this guide :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/road03242004.asp
My 2nd question is how do i go about exporting a desktop version of a database to my smartphone? I need to convert it to the mobile version first right?
Any help would be greatly appreciated!!
thanks!!
View 3 Replies
View Related
Mar 24, 2008
Hi All,
Please some one help me...
I have to insert a csv into one table in sql server. But the problem is the file is in one server and SQL SERVER 2005 is in other server..
how do i insert the file....
please help me.....
View 1 Replies
View Related
May 19, 2006
I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.
Following is the text of the error details:
TITLE: Microsoft Visual Studio
------------------------------
Error creating package
------------------------------
ADDITIONAL INFORMATION:
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
BUTTONS:
OK
------------------------------
I found a similar post that suggested that they try the following:
regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll
But msxml6.dll could not be found.
I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.
My concern now is what is the likelyhood of this being the only file missing from the installation.
I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.
Thanks.
Marshall
View 12 Replies
View Related
Jul 20, 2005
Hi,Could some please tell me whether Microsoft provides Type 2 and Type 4jdbc driver ? For Type 4 MS providescom.microsoft.jdbc.sqlserver.SQLServerDriver driver. What is thecofiguration required for type 2 driver and what driver class filesrequired ?Its very urgent to me please reply.Ajay
View 1 Replies
View Related
Mar 12, 2008
Hi
I posted this on the sql server security forums too. Here is the error that i get when i change the type of the step to ssis
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Additional information:
An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.(Microsoft SQL Server, Error: 3930)
This error pops up right after i change the type of the step to "SQL Server Intergration Services Package"
I have made the following configurations:
The user group (windows group) that the user belongs has the following roles in msdb :
db_dtsadmin
db_dtsltuser
db_dtsoperator
SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole
i have made a proxy to sql server agent which has the following subsystems :
"SQL Server Integration Services Provider" the proxy is tied to the same login which has those SQLagent and dts roles in msdb database.
Im using windows authentication and the user that logs into the sql server is in the same group that i have set all of the rights.
Ps. Clearly im missing some role or right somewhere because as soon as i give the group sysadmin role then all the users in that group can create SSIS steps in the agent.
Ps. Ps. I have been living under the impression that i dont have to give sysadmin rights to people that create ssis packages and schedule then with the agent.
View 3 Replies
View Related
May 23, 2000
I'd like to know what is the equal type of the type MEMO in ACCESS.
Thanks.
View 1 Replies
View Related
May 4, 2007
I am using SQL server express as my web site's backend and need tostore more than 8000 characters in a varchar field. When I useVarchar(Max) the field contents are saved but appear as a singlesquare in my recordset. What am I doing wrong? The data appears inthe table, but does not appear in my recordset. If I switch thefieldtype back to VarChar it works, but only up to 8000 characters.How do I store more than 8000 characters AND display it through arecordset on my pages?
View 1 Replies
View Related
May 1, 2008
Hello,
I have installed all the required installations for SQl Server CE, however when I open SQL Management Studio, the server type option is greyed out and I do not have the option to select SQL CE server type.
I have installed SQl Management Studio Express edition (if that helps.).
Please suggest.
Regards,
Arjun
View 5 Replies
View Related
Jun 2, 2007
In Oracle you can declare like this
DECLARE v_EMPRecord EMP%TYPE;
which is ColumnName%TYPE or I think it's %ROWTYPE, may be both.
Makes life easy for Stored procedure developer
Do you know any thing same we have in SQL Server 2005, should be?
View 2 Replies
View Related
Feb 26, 2007
Hi,
I have a stored procedure which uses:
DECLARE @Tmp TABLE ( Row_ID INT IDENTITY(1,1), Property_ID INT)
And I'd like to reuse the table in the stored procedure and have attempted to empty the table by calling
TRUNCATE TABLE @Tmp
But this doesn't work. How else can I do this? I don't want to use
DELETE FROM @Tmp
Because this doesn't reset the Row_ID, and I'm using the Row_ID in a WHILE loop. Any ideas?
View 3 Replies
View Related
Mar 12, 2007
Hi guys,anybudy know the thing as title?And does sql server has the func. to transfer plain txt to encryt. text? Cheers, Elton
View 2 Replies
View Related
May 15, 2007
Does anyone know if there is any type of audit trail mechanism used in SQl Server 2000 or 20005?
In our production environment, some of our stored procedures, views and data in our tables has changed. It would be nice to have a footprint of what was changed by whom and one.
For our code we use source safe but for SQL Server I am not aware of any type of auditing mechanism.
View 1 Replies
View Related
Nov 3, 2007
Hello, I have worked with SQL Server 2000 but now we have a requirement where I need to write values from an asp.net form into an XML type in SQL Server 2005.
I have never used XML as a type in SQL Server 2005. How do we write xml into xml type.
For example the structure of XML is something like:
<application>
<applicationID = "value"></applicationID>
<customerName="value></customerName>
</application>
I have to write this kind of XML into the XML type and later retrieve these XML values and populate the form again.
Kindly suggest. Thanks a lot.
View 1 Replies
View Related
Feb 27, 2008
Hello All!
Can anybody tell me how to add a date data type into SQL Server? I have a web application that collects data from users, and one of the data collected is the date. I would like to save that date as a date only and not as a datetime like SQL Server wants me to.
My first understanding is that, since SQL Server only allows a datetime data type, this is why it appends a time whenever a date is saved in or it appends a date whenever a time is saved in.
How do I accomplish this task of saving a date as a date only or a time as a time only? Is there a way to add a date or time data type w/in SQL Server? Or SQL Server just doesn't allow for it?
Any help is appreciated!
View 4 Replies
View Related
Feb 19, 2004
I need to store some HTML, well over 8000 chars in SQL Server, what would be the best data type to use?
Thanks
Simon
View 1 Replies
View Related
Aug 20, 2004
Sorry if this is a dumb question.
I have a SQL Server TEXT Data Type field which stores a long description.
However when I update it from C# (ASP.net) through a textbox, it seems to cut off a part of the data if the number of characters is a big size (+- more than 577 characters).
I pass the data from then textbox to a string, but as soon as I run the Create/Update stored procedure that gets passed the string field, it seems to chop off the string.
What am I doing wrong?
Should one rather use a SQL Server string field for descriptions (+-1000 characters long) or should one use the TEXT field for this purpose?
Which one's performance is better?
View 1 Replies
View Related
