Urgent - Client Application Database Choice

Oct 31, 2006

We have a small accounting application which is currently based using DBASE database. We need to change the DB and considering SQL Express. However, is some one can clarify following, it would be very helpful:

1) Application is used mostly by standalone non-technical users. There are cases where more than one user will need to connect to DB.

2) We need to ensure that user can not modify database outside of our application. This is needed to ensure database does not get currpted or passwords lost and then no one can open the database.

3) Installation needs to be simple without providing any options to users except where to install database or point to already installed DB in case its a network environment where 2-3 users can be working on the same database.

4) Application is usually installed on normal desktop machines. So, DB should not load the PC heavily.

Please advice if SQL Express is the right direction even with these constraints? What are the other alternatives? We are open to have a small consulting project as well with someone who can guide us through these issues. Email to contact is rkabra101@yahoo.com



rick

View 1 Replies


ADVERTISEMENT

Access A Database From A Client Application

Oct 18, 2006

Hi all...

I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated)

The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site.

Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data.

So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure.

Is there a way to secure this password? I am worried about a user somehow extracting the password from the application and connecting directly.

Am I on the right track here? Any ideas appreciated!

Thanks,

Forch

View 4 Replies View Related

Deploy Database Application To Client Computer?

Oct 1, 2015

I want to deploy my database application to my client's computer. My application uses SQL Server 2014. My client has to run that software on a single PC. I was looking to download a lightweight version of SQL Server that can fulfill my requirements, so when I was looking for SQL Server downloads, I saw these files there, which file should I use in my situation

Express 32BIT WoW64SQLEXPR32_x86_ENU.exe
Express 32BITSQLEXPR_x86_ENU.exe
Express 64BITSQLEXPR_x64_ENU.exe
ExpressAdv 32BITSQLEXPRADV_x86_ENU.exe
ExpressAdv 64BITSQLEXPRADV_x64_ENU.exe
ExpressAndTools 32BITSQLEXPRWT_x86_ENU.exe
ExpressAndTools 64BITSQLEXPRWT_x64_ENU.exe
LocalDB 32BITSqlLocalDB.msi
LocalDB 64BITSqlLocalDB.msi
MgmtStudio 32BITSQLManagementStudio_x86_ENU.exe
MgmtStudio 64BITSQLManagementStudio_x64_ENU.exe

View 7 Replies View Related

User Not A Choice When Trying To Add To Db_owner Role For Database

Mar 14, 2008


How do I get a particular user to be a choice under the db_owner role for a particular database?
The user is listed under logins and even shows to be the db_owner for the database under the database access tab of the login properties. This is SQL 2000.
Thanks,
David P.

View 1 Replies View Related

VB.net Application For Client-Server

Apr 16, 2007

Hi folks,
I have an application designed in vb.net and it needs to Communicate with MS SQL 2005 database which resids on SERVER and The applicaton needs to run from Client PCs... When i install the Application on Server itself it works fine.... But when i Install it on any of the client Pcs it gives me the following error....

Unable to install or run the application. The application requires that assembly Microsoft.sqlserver.ConnectionInfo version 9.0.242.0 be installed in Global Assembly Cache (GAC) First.

Any help guys ???

View 3 Replies View Related

Client/Server Application

Sep 12, 2007

hie,
have a question. what tool is available to develop client/server application with db as ms sql server? is it only visual studio.
for example: i was using oracle 9i db with 9i developer as a total package to build applications. very easy with creating update, delete or new forms.
is it possible with visual studio or am i missing something?
i need to feel comfortable since i know sql server but dont know what to use for developing application.
many thanks,
farouque

View 2 Replies View Related

Use Reportiing Services From Client Application ???

Dec 11, 2007

Dear all,

I need to develop fro my customer a WinForm application which will display a list of report name available fro my customer, who will be free to select the desire report to print.
For that I was previously using Crystal report but as now I am in an environment where report services is included and can be used I have decide to test it and see if it cover my customer need.

I have use reporting service in one of my customer project but by dircetly accessing it through the ReportServer default interface but never from a WinFrom application.

How can I implemented the connection to reporting service, accessing report template and have access to print function as well as export to different format in my application ?

Is there any step by step procedure somewhere ? could not found

thnaks for your help
regards
serge

View 6 Replies View Related

Converting An Application To SQL Native Client

Oct 19, 2007

I am currently modifying an existing application (which uses OLE DB Consumer Templates to access a remote SQL db) to utilize SQL Native Client instead. Does anyone have any experience making this change?
Am I correct in my assumption that all I have to do is:
change my included headers from 'sqloledb.h' to 'sqlncli.h'
and
change CLSID_SQLOLEDB to CLSID_SQLNCLI?
I am still including the 'atldbcli.h' header and therefore still using the OLE DB Consumer Templates.
Can I continue to use the Consumer Templates along with SQL Native Client?


View 4 Replies View Related

ReportBuilder.Application Will Not Work On Client On Network

Apr 10, 2006

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [4/10/2006 11:34:29 AM] : Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [4/10/2006 11:34:29 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application 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.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Does anyone know how that I can get the reportbuilder.application to run on a client on the network. It seems that if I have to remote into the actual server to get the report builder to work would be pointless for users on the network. I get the 401 Unauthorized all the time. Any comments would help.

Jordanb412

View 3 Replies View Related

How To Access Output (Inserted.ColName) From Client Application ?

Nov 6, 2006

I am using SQL Express 2005 and VB .net Express.

Question 1:

How can I get the result stored in Inserted.ColName (by Output clause of insert command). In the documentation (BOL) for SQL 2005, there is written "returned to the processing application for use" in Output clause (first paragraph).

Question 2:

How to store Inserted.ColName into local variable when insert command is running in stored procedure.:

View 8 Replies View Related

Where To Build Client Application For SQL 2005 Standard Edition

Jul 24, 2006

Hi,
I have a database working on SQL Server 2005 Standart Edition and i want to create a client windows form aplication.
My problem is where to do it? Im trying to use MS visual basic 2005 express edition but it doent support SQL Server 2005 Standart Edition, it only supports SQL 2005 express edition.
What should i do ?
And in the visual studio 2005 that comes with the package of SQL Server 2005 standart edition there is no project of a winodws form.
Please help

View 8 Replies View Related

**Urgent** Remove SQL 6.5 Client

Feb 20, 2002

I cannot see to find how to uninstall SQL 6.5 client from a users PC..
Please can somone advise..

Many Thanks
Darren

View 1 Replies View Related

How To Set My ASP.NET Application To Access SQL Server 2005 Using Client's User Credentials?

Jan 29, 2007

Hi guys,I'm not sure if I'm just bad at googling but I can't seem to find a way to set an ASP.NET 2.0 web application to connect to SQL Server 2005 using the current client's user credentials. My web application is using Integrated Windows Authentication so its Page.User.Identity is set to a DOMAINusername value... I want to pass that to my connectionstring or have my connections pick up the identity automatically and use that Identity when accessing the db server.Oh and another thing, my IIS Application Pool is using a specific Identity itself, so I don't know if that might affect the above.Hope someone could help. 

View 2 Replies View Related

SQL Server 2012 :: Return Multiple Messages To Client Application?

Jun 9, 2014

I have a procedure where after processing, i am required to send multiple message to calling application.

For ex:

create procedure test as
(@a as int,
@b as int
@c as int )
/*
some transformations */
print 'variable a is' + @a;
print 'variable b is' + @b;
print 'variable c is' + @c;

I am only providing a sample of return messages, but in reality there a lot more messages where a string and a parameter value need to concatenated.Unfortunately print is not allowing to concatenate parameter value.I can use RaiseError, but these messages are not really any error messages.

i tried to concatenate all message and output it using OUT type parameter, but the length of all messages combined exceeds 10000 characters.

Is there any other alternate to send these messages out to application?

View 1 Replies View Related

SQL Server Runs Out Of Resources Or Is It My Client Application. Handle Count = 96k

Jul 20, 2005

SServer PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAMSQL Server 2000 v 2000.8.00.76 (sp3)MS Office 2k3MSJet ms04-014 (latest ost sp8)MDAC v2.8 RTMADO 2.1vb6.exe / ADO 2.0I think this is a SQL Server/ADO problem as I have 2 applications withsame problem.My access database uses a timer based function to insert records intoSQL Server using ADO and stored procedures. Access also uses DAO ,Jet/ odbc to linked tables on SQL Server for many other tasks/forms.All is well when Access 1st run but after a few hours or so the Accessapp grinds to a halt.Upon checking the task manager the mem usuage upto 160MB and handlecount upto 86,000 ! (cpu process % is low).After the "Access Fail" if I stop/start access only, performance isnot returned, I have to stop/start SQL Server.It would seem that allconnections from this PC to SQL server are badly affected, it is nottied to the client application that had the problem.As I could not work out where the problem was I took the Accessfunctionality into a VB6 app, using ADO 2.0, thinking this shouldsimplify matters with Jet and ODBC out of the way.I now have the same problem with the number of handles increasing withevery new timer based function.* code snippet example *If Not OpenConnection Then 'we have not been able to open aconnection to SQL serverCall procLog("Connection failed to SQL server")Exit FunctionEnd If'gVar.cnnSQL is my public ADODB.ConnectionSet cmdSQL = New ADODB.CommandWith cmdSQL.ActiveConnection = gVar.cnnSQL.CommandText = "MyDB.dbo.insert_tblMyData".CommandType = adCmdStoredProc.Execute RecordsAffected:=lngRecs, _Parameters:=Array(lngID, dtDate,intCategory,strNationality,strNotes,strName)End With* code snippet *** After the "Access Fail" if I look at one of my clients, running thesame Access app on another PC, it seems normally responsive when usingone my bound forms to browse the data from same SQL Server **Any ideas anyone ?

View 3 Replies View Related

SQL_SSMEE Failed And Trying To Repair While Lauching Our Mobile Client Application.

Jul 24, 2006



Event ID - 1001 and Event ID - 1004.

Source - MsiInstaller

Error Description for Event ID - 1001:

Detection of product '{8670F53C-8AD7-4F34-BDBA-17B38A18CB65}', feature 'SQL_SSMSEE' failed during request for component '{6EC5DFBD-F6B5-4F02-8432-BFB8B03562B8}'

Error Description for Event ID - 1004:

Detection of product '{8670F53C-8AD7-4F34-BDBA-17B38A18CB65}', feature 'SQL_SSMSEE', component '{180F515D-F56C-40DD-9D71-CC532EA8E286}' failed. The resource '' does not exist.

While opening our SAP Mobile Client Application, in the task manager MSIEXEC.EXE is running and trying to repair the application and this will cause our application to take time to lauch. In the Event viewer, whenever we try to lauch our application we are getting this event id's. Can you please kindly provide a solution for this msg.

Regards,

Thiyagarajan.R

View 1 Replies View Related

Installting Sqlserver 2005 On The Client Machine For Windows Application

Oct 24, 2006

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

View 3 Replies View Related

All The Ids In Temp2 Should Have Same Client And Drug (was Need Sql Help - Urgent)

Oct 10, 2006

I have following tables

Temp1

ID Client Drug
3889aa A
4998cc A
4998dd B
8011ff C
8011gg A

and Temp2

ID Client Drug
8011ff C
8011gg A



I have a conditional loop which changes the values of these 2 tables. I populate temp2 by getting all the similar ids from temp1. e.g: first time 3889 then 4998 then 8011.

my task is, all the ids in temp2 where temp2.id<>temp1.id should have same client and drug. if 8011 has client bb and drug B then 4998,3889 should also have client bb and drug B in them.

if 4998 has client dd and drug B then 8011, 3889 should also have client dd and drug B and so on. means all the records in temp1 should contain similar clients and drugs in them in actual table. I'll need to add the missing client and drug for the ID where its misiing in actual table.

After this process my actual drug table will look like:


ID Client Drug

3889 dd B
3889 cc A
3889 aa A
3889ff C
3889gg A
4998 dd B
4998 cc A
4998 aa A
4998ff C
4998gg A
8011 dd B
8011 cc A
8011 aa A
8011ff C
8011gg A


How can I achive this goal. Please help...

View 1 Replies View Related

SQL 2012 :: Connections Not Getting Closed By Client Application And Impact Feedback Request

Mar 31, 2014

I have been investigating the number of connections activeinactive to a certain database server and I have stumbled across an application which seems to not be clearing its database connections.For one instance of a client there was >70 sql connections which eventuated from the closing and reopening one 1 screen in the culprut app. Once the application was closed all of the connections are recycled but its evident that within the application itself it is not correctly reusing already existing open connections.

I have raised a point with the main programmer that we need to investigate more into how the application is managingot managing its ADO .NET connections to SQL.

I am starting with doing some reading here URL... and I was hoping to get some more information about the possible impact of excessive sql connections on the SQL Server itself. Our organization is quite lucky in that our SQl Servers are Overspecced given their workload, bearing that in mind I would like to dig a bit deeper to get some stats if I can to highlight the scope of the issue to the managementprogrammers.Our SQL server peaks at 6500 processes and a good 70% of those are due to this applications mis-management of its sql connections.

View 6 Replies View Related

Warning Msg In Application Log Urgent

Feb 10, 2004

Hi all,
Sql server 7.

Under event viewer->application log i am getting the below error continously. Pls help

Regards,Event Type: Warning
Event Source: SQLServerAgent$abc
Event Category: Printers
Event ID: 208
Date: 2/9/2004
Time: 9:23:03 PM
User: N/A
Computer: abc1
Description:
The description for Event ID ( 208 ) in Source ( SQLServerAgent$abc ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: SQL Check, 0xAF04DFE7917DEA489F33D8A38E8A0793, Failed, 2/9/2004 9:23:00 PM, The job failed. The Job was invoked by Schedule 31 (6.x schedule). The last step to run was step 1 (Step 1)..


Waiting for ur reply
TIA
aadil

View 3 Replies View Related

Urgent SQL Server Client Tools Question

Oct 11, 2007

I have to go back east.. I am going to be working remotely.
We still used SQL Server 2000 at work..
Will I be able to use SQL Server 2005 Express edition to remotely connect to and modify stored procs and tables?
 
what are all my options??

View 1 Replies View Related

URGENT: Problem With VS Application Hangup

May 15, 2007

Hello, over night I got problems with Visual Studio (Business Intelligence Platform) accessing the SQL Server. I think i automaticly received a patch that caused that problem. I had no problem deploying projects or accessing reports from Report Manager. As soon as I wanted to access the database from VS (through data or preview) the application hang up. I checked the database and everything is allright. I googled and a guy who expericenced a simular problem was recommended to uninstall and install SQL Server. At last I did the same but now I am even experiencing problem with installation.The installation stops when configuring components i. e. Visual Studio IDE and then nothing happens.





The logg says the following: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727gen.exe install "Microsoft.VisualStudio.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /NoDependencies /queue:3 /execonfig:"C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe" /nologo
05/15/07 07:32:14 DDSet_Status: LANGID: 1033 .



I cannot abort the installation process.





I am very thankful for your help!



/luskan

View 1 Replies View Related

ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer

May 5, 2006

Hi All,

I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.

I would now like to install my application on another workstation and connect remotely to the database located on my development machine.

The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?

Thanks!

View 6 Replies View Related

[urgent]window Application Integrate SQL Report Service

Apr 24, 2008

i am new for SQL server report service, i have a project that need to generate report and integrate or shown on my window application,
so i have a few questions as follows:


1) do i need to add web reference ( report ) to my window application?.
2) how can i preview and print .rdl report within my window application?
3) how to automatically printer report? can this be done by within a store procedure or trigger or in window application?


ps: view reprot manager, ---- http://localhost/reportserver$SQLEXPRESS
ask me name & password? what name should i type in sa? or Administrator or ?



many thanks,

C




View 4 Replies View Related

What Is The Best Sort Order Choice ?

Jul 5, 2000

In Sql6.5 we use binary sort order for a best performance (I think). I hear that it should be highlighted that the case for binary sort order being the fastest method of sorting and searching a database no longer applies at SQL 7.0
Is it right and why ????

View 1 Replies View Related

Weird Optimizer Choice

Jul 20, 2005

I'm very puzzled by the choice of NC index being made by the optimizerin this example. I don't actually think it should use an NC index atall.I have:Table: CustomerStatus_TSingle data page19 recordsClustered Index on CustomerStatusID:CREATE TABLE [CustomerStatus_T] ([CustomerStatusID] [int] NOT NULL ,[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[Description] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[Code] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[CodeAlt] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[Ordinal] [int] NULL ,[Default] [int] NULL ,[Display] [bit] NOT NULL ,[StatusType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[DateCreated] [smalldatetime] NULL ,[DateUpdated] [smalldatetime] NULL ,[DateArchived] [smalldatetime] NULL ,CONSTRAINT [PK_ROMS_CustomerStatus] PRIMARY KEY CLUSTERED([CustomerStatusID]) ON [PRIMARY]) ON [PRIMARY]If I run the following query, it does exactly what I expect and scansthe clustered index:SELECT customerStatusID, [Name] FROM CustomerStatus_TWHERE dateArchived IS NULLAND Display = 1AND StatusType = 'Q‘and gives the following QEP and IO statistics:|--Clustered Index Scan(OBJECT:([Reach_Roms].[dbo].[CustomerStatus_T].[PK_ROMS_CustomerStatus]),WHERE:(([CustomerStatus_T].[DateArchived]=NULL AND[CustomerStatus_T].[StatusType]='Q') ANDConvert([CustomerStatus_T].[Display])=1))Table 'CustomerStatus_T'. Scan count 1, logical reads 2, physicalreads 0,read-ahead reads 0.If I now put a NC index on the statustype column:create index ix_nci_statustype on customerstatus_t(statustype)the query plan changes to:SELECT customerStatusID, [Name] FROM CustomerStatus_TWHERE dateArchived IS NULLAND Display = 1AND StatusType = 'Q‘|--Filter(WHERE:([CustomerStatus_T].[DateArchived]=NULL ANDConvert([CustomerStatus_T].[Display])=1))|--Bookmark Lookup(BOOKMARK:([Bmk1000]),OBJECT:([Reach_Roms].[dbo].[CustomerStatus_T]))|--IndexSeek(OBJECT:([Reach_Roms].[dbo].[CustomerStatus_T].[ix_nci_statustype]),S EEK:([CustomerStatus_T].[StatusType]='Q') ORDEREDFORWARD)Table 'CustomerStatus_T'. Scan count 1, logical reads 7,physical reads 0, read-ahead reads 0.For some bizarre reason, the optimizer thinks that a NC index lookupon a single-page table, which ultimately costs 7 IOs, is cheaper thana table (or Clustered Index) scan of a single page. Why? Theshowplan cost also shows that it expects the NC index to be cheaper(which is presumably why it goes and uses it), but even after runningUPDATE STATISTICS on the table it still chooses the same idiotic queryplan.Any thoughts, or has anyone seen similar behaviour before, and cananyone please explain it to me?p.s. I don't actually WANT to put a NC index on this table, but Inoticed the behaviour by accident which is why I'm asking the question:-)

View 3 Replies View Related

Is Clustering Ever A Better Choice Than Mirroring?

Nov 8, 2007

clustering sounds expensive and arcane. Is it ever a better choice than mirroring for high availability? Perhaps when the size of the db copy is too prohibitive under the mirroring option?

View 1 Replies View Related

Temp Table Vs View - Which Is The Better Choice ?

Jun 1, 2007

If There are very lots of data to retrieve to show in any inquiry forms.each inquiry forms need to use a lot of table. There are two methods I thought First, Prepare data to Temp table when arise any transaction and Program then retrieves data from temp table. Second, Create view for retrieving data  Which method is the better choice ? How ? (More fast, More performance or More flexible ? )  Please advise me....   

View 1 Replies View Related

Development Tool Choice For SQL Server

Nov 16, 2006

Is VB.net the most logical choice of a RAD tool to use with MS SQL Server? Is VB.net strictly for web apps or can you use it to create projects that run as executables off the server?

JustStartinOut

View 12 Replies View Related

Any Other Choice Than Left Outer Join??

Apr 13, 2008

i have three tables company as co, Procurement as po,contracts as cr
Co_id as primary for co
co_id forign for po
co_id forign for cr

i want the query to get me only one record for every co_id if it has a company in certain PO or CR ( i used max fnctn to get me only one record)

result:

CO_ID,PODOCNO,CRDOCNO
----- ------- -------
1 350 400
2 355 1064
3 NULL 500
4 600 NULL

I used the left outer join in this manner


SELECT CO.CO_ID, MAX(PR.DOCNO) AS pO_DOCNO ,MAX(CR.DOCNO) AS CR_DOCNO
FROM COMPANY CO lEFT OUTER JOIN PROCUREMENT PR ON OG.CO_ID=PR.CO_ID lEFT OUTER JOIN CONTRACT CR ON CO.CO_ID=CR.CO_ID
GROUP BY OG.CO_ID


the result is ok but the problem its taking infinte time if i add more tables to the outer join, i have more tables and each with huge number of records

any better way to do this ?? its true performance is a big deaaaal

View 8 Replies View Related

Sql Server To MSDE - Good Choice?

Jul 20, 2005

Hi - I have a rather unreliable host just now - but they offer .net, sqlserver and SSL for a reasonable price.Problem is, the domain is hosted on a shared server - and it keeps goingdown apparantly because of code which is less than clean, on somepeoples sites. (ie. not closing connections etc).I am considering moving to a decicated server - but at this point intime, cannot afford a full SQL Server licence for it - however, thededicated server does offer MSDE. Is it acceptable to go back to usingthis from SQL Server - for a currently low hit site - ie. around 500hits per day.Does MSDE offer stored procedures (I don't use views or triggers)? CanI just take a DTC backup/export of my current SQL Server database, andrestore it to the MSDE one?What would be the cut-off point for using MSDE?Thanks for any info - also, if anyone knows why UK companies charge somuch more dor dedicated servers, than US companies - I'd be interested.Thanks, Mark*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 2 Replies View Related

Is Enterprise Edition Is A Good Choice?

Apr 15, 2008

Hi,

I created a application in VB and backend database for this is SQL Server 2005. So far I was working on "SQL Express", as a testing one. I have almost 20 Tables and also lot of stored procedure. From the programming point of view, the database is not that much of large. The size grows only when the pictures are added to the database. Its not a client/server application(only desktop application).

If i install Enterprise Edition, will it Consumes large space and memory into the client machine. What about performance issue.

Right now i have two editions SQL Express and SQL Enterprise Edition.

Which edition you would like to suggest on the basis of information provided as above.

Thanks.

Best Regards
Kashif Chotu

View 6 Replies View Related

Mutiple Backup Is Good Choice?

Feb 9, 2008



Hi,

I am using a stored procedure to take backup of my database from the Visual Basic Programming.

Before i posted one of my thread with the same thing, so i was recommended to go through with DMOSQL do deal with SQL server with Visual Basic Programming. For me, this takes some time to understand the complete concept.

Because of urgent i am using stored procedure to take backup with the following:

---------------------------------------------------------------------------------------
ALTER PROCEDURE dbo.BackUPBLMSDB

(
@RP nvarchar(200)
)

AS

declare @backupfilename nvarchar(200)
set @backupfilename=@RP
BACKUP DATABASE [BLMSDB] TO DISK = @backupfilename WITH NOFORMAT, NOINIT, NAME = N'BLMSDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
---------------------------------------------------------------------------------------
Example @RP="D:ackupBackup-1 09-02-2008 11-24"


Every time i am passing a parameter with somename and dateandtime(System).
Example

Backup-1 09-02-2008 11-24 2900KB
Backup-1 09-02-2008 12-30 2900KB
Backup-1 09-02-2008 18-10 5400KB
Backup-1 09-02-2008 22-00 2900KB
Backup-1 09-02-2008 22-00 2900KB

I would like to clear my doubt, is it a good practice to take backup with different names. The above one i store four backups . If the system crashes and i created the new database with the same schema without any data present in the tables, can i restore previous backup database to the newly created database.

Moreover, The first two backups contains "2900KB", the third one is "5400KB" after the data is being modified. Look at the fourth one it is "2900KB". Why the size is being reduced to "2900KB" after taking backup eventhough i didn't delete or added data into the database.



Hope you will solve my problem.

Thanks.



Best Regards,
Kashif Chotu





View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved