HI
how to load a image file in to a sql server.
do we need c# code for it or can we use just a t-sql procedure to upload it.
In my application we don't have ant c# or other application. we have only t-sql
thanks
sandipan
If you are planning to use SSIS, the Import Column transform could be useful for this purpose.
Thanks.
the connection string in my application daynamic ..changed by changing the development environmet ..how can i load a data from file to sql server destination without hard coded the connection
thx
hi,
You could use xml files, registry entries or sql tables in order to save these parameters. (Package configurations when you click on the right mouse button) and then load them on demand.
|||Many links regarding package configurations can be found here: http://www.google.com/search?hl=en&q=ssis+package+configurations|||Begin here: http://msdn2.microsoft.com/en-us/library/ms137592.aspx
the connection string in my application daynamic ..changed by changing the development environmet ..how can i load a data from file to sql server destination without hard coded the connection
thx
hi,
You could use xml files, registry entries or sql tables in order to save these parameters. (Package configurations when you click on the right mouse button) and then load them on demand.
|||Many links regarding package configurations can be found here: http://www.google.com/search?hl=en&q=ssis+package+configurations|||Begin here: http://msdn2.microsoft.com/en-us/library/ms137592.aspx
I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or MySQL.
In the case of MSSQL, clustering is supported for failover only, not for
load-balancing. If you need load-balancing, then it can be implemented in a
middle-tier.
Simon|||> I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or
MySQL.
> In the case of MSSQL, clustering is supported for failover only, not for
> load-balancing. If you need load-balancing, then it can be implemented in
a
> middle-tier.
What do you mean middle tier?|||"Shabam" <info@.pcconnect.net> wrote in message news:<9oKdnTRxs9oRou7dRVn-uQ@.adelphia.com>...
> > I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or
> MySQL.
> > In the case of MSSQL, clustering is supported for failover only, not for
> > load-balancing. If you need load-balancing, then it can be implemented in
> a
> > middle-tier.
> What do you mean middle tier?
I mean an application server, such as WebSphere, WebLogic, Microsoft
Transaction Server etc., which sits between the web server and the
database server. Clients connect to the application server, which
manages all the database connections, so you can use the application
server to spread database access across several physical databases.
Simonsql
Hello,
How is load balancing working in SQL Server 2000. We want to have two different servers as a back end for our web based eCommerce application. Is this possible? While there be any modification requirement in the application?
As long as both servers are ODBC-DB or OLE-DB compatible you can do this using Enterprise Manager or T-SQL code. It happens on server side.
Linked servers are listed under the security node under each server in EM. (Left hand pane) Right click node and select 'New Linked Server'
|||Both servers are SQL Server 2000. What I am trying to achieve is to have a backup for our SQL Server so that if one of them is down, the other is still alive and serving the application. Is this possible? If I have linked server, does that provide me what I need?
Yes Motley is right.
Clustering will give the impression of two or more servers acting as one and thus provide high-availabiltiy.
A SQL Server cluster however do not balance the SQL load and will not provide scalability.
Hi there,
i need a database for my Windows CE application which i can update from a desktop application.
I tried the SqlCeConnection. This works good on the device, but i found out, that i need a sql server on the desktop or someone else to get access to the device server. This is a problem for me, because i cannot insall such a sever on the desktop.
So i searched and searched....I found infos about the ole connection, but i cant find the namespace?!?
Can anyone give me a hint what the best solution could be?
Im using Visual Studio 2005 and a CE device.
Thanks a lot
You can use VS 2005 'Add New Datasource Wizard' under Data menu OR in Server Explorer ==> Add Connection to update the database on device. Also, with introduction of SQL Server Compact/Mobile/Everywhere Edition, you can copy the database file to a desktop and you can use System.Data.SqlServerCe.dll that is installed on desktop (If not installed, download and install this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=898913&SiteID=1).
Thanks,
Laxmi
im trying to make an we application, that from it i can create a database and table to the server
i created the database.
but i want to create the tables too, but the problem is how can i list the data types of the sql server in the aspx page so i can create the tables with columns of requuired types.
Kind Regards
Mahmoud ManasrahI believe you could use the collection System.Data.SQLTypes. I don't know that you could bind directly to the collection, but you could iterate through it adding it to a bindable object (like a dataset for instance). HTH|||thank you
its a cool idea, this is what i was looking for
but im trying to do the code to iterate through this collection, but still didnt reach it
can u tell me how can i write the code
Kind Regards|||How about
foreach(Object myType in System.Data.SqlTypes)
if (myType.GetType().Name.Substring(0,3) == "Sql")
I haven't tested this, just maybe a starting point.
Hi
I want to know the Store Procedures called when i run my application.We want to disable / drop the store procedures that are not called. Is there any Trace Template available to do so . We ar e using Sql Server 2000
thanks
You can run the Profiler for that:
File->New->Trace, then in Events tab choose "Stored procedure" event classes, then select only "SP
After a period of time->Stop selected trace (red button)
Hello,
I use SQL Server Management Studio Express. When I want to connect to some server the application form offers me several servers that I used to connect to in past. Where can I manage this offer (delete some obsolete servers).
Thanks
hi,
I do think you find it in
C:\Documents and Settings\YourName\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
.. but, if it is, my advice is not to hack it..
regards
I have created an application that uses reports published via SQL reporting services. I have a form with a report viewer control on it and above that I have a drop down list box. I want to fill the list box with available reports from the server and allow the user to select the report they wish to see. The report list could change so I don't want to hard code any report names in the list The problem I am having is that I can't figure out how to get a list of available reports from the server.
Thanks for any help offered.
Check out this article:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listchildren.aspx
BobP
|||You may have to alter this for your system but you can try the query below.
selectdistinctnamefrom dbo.Catalog
where policyroot = 0
andpathnotlike'/Data Source%'
andpathnotlike'/Model%'
orderbyname
|||
Thanks to both of you, now I have options because I used both and they work (with slight modifications).
I modified the query as follows and it gives me just the reports
selectdistinctnamefrom dbo.Catalog
where policyroot = 0
andtype= 2
orderbyname
I just didn't realize it was in the Catalog table, I swore I looked but I guess not.
Thanks again
