SQL Server

Service Broker in sql server 2005

[strong]What is a real life application of service broker architecture in sql and how to use it?[/strong] [strong]Can anybody help me in understanding service broker with real life example?[/strong] Thanks in advance Software/Hardware used: sql server 2005

MySQL 5.0 advantages and disadvantages

what is the advantage and disadvantage of mysql 5.0?

AS/400 stored procedures

Is there a way to list the existing stored procedures on our box ? Those that wrote them are gone and documentation is sketchy. We found some by using any SQLRPG source as a clue but none of these were "create" routines (some were actual procedures). Seems like there ought to be an easier way. ...

How to open sqlserver2005 after installing

I have installed Sqlserver 2005 into mys system and how can i set a username and password to that.I am the only user to that computer.

Getting specific values from a SQL table to the ComboBox

How do I get specific values from a SQL table to the ComboBox in the running mode?

SQL autonumbering problem

I have a sequel db of users which is periodically updated by exporting to access, making changes, then re-importing amended table. After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.) Why does...

MySQL vs. Oracle

what is the major two comparison of mysql5.0 and oracle 10g?

Merge Replication with express versions

I am trying to do a merge replication with about 10 pda's and a desktop i do not want to use full blown ms sql due to cost, anyone any alternatives PDA's are running Mobile 6 and sql compact IF need be will change from MS sql to other

SQL Server datetime

Hi - When I run this: select cast ('461129' as datetime) i get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results. thx

Migrating C code db acess from sybase to sql server 2005 - newbie

I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

Function to find greatest numeric value across different fields

In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

SQLRPGLE - Prepare - Declare Cursor

I'm using Prepare, Declare SQL cursor in my SQLRPGLE program After Declare statement I receive SQL -312 - Which indicates to me that the SQL statement is not declared correctly. Is it something wrong with my query. I ran this query in SQL editor and went fine. I dun understand why not in the...

Capture SQL Server logged in db User name in Access 2007 Accdb

I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

SQL Server Database Restore

When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"? Software/Hardware used: SQL Server 2005

file user open exceptions for printer file

i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help Software/Hardware used: SQLrpgle

Can I add a local SQL 2005 instance to a clustered node

I have a 2 nodes (Active/Active) SQL 2005 Standard cluster. Since SQL STD only support two clustered instances, can I add a local instance to each node? I don't need this local instance to fail over. Is it possible to have the two clustered instances an two local instance one on each node?

sqlserver2005 on windows vista home premium(32 bit)

i have sqlserver2005 wid service pack 2 installed,it gives server names as-'user-pcsqlexpress'&'user-pc'. But wen using visualstudio2008,if i give this as the server name during database connectivity it does not recognise and the error msg says that d server doesnt exists.Please give me a solution

how i do save picture in data base vb.net

iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

SQL auto increment by group with INSERT..

Is it possible to define an auto-incremental coloumn which increments by 'group' ? I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text.  I intend to trigger updates,...

following error when logging into SQLPlus

When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 9i Personal Edition Software/Hardware used: P4 2.5ghz and windows 2003 server