Hi, I'm thinking of developing an application, that in some cases might exceed the 4GB limit per database of SQL express 2005. From my point of view, it should be fairly easy to "upgrade" from express to server, but are there any things that i should take into consideration? Cheers, ...more >>

I am trying to restore a database, I can't use the wizard as it says I should be a SA user ! when using EM you can right click and use Tasks-restore, but it won;t allow me to do this so I have created the following using sql analyzer under the SA login as : restore database cc_boston_dev f...more >>

Hi all I know it's possible to add a column to a table, via the ALTER TABLE statement. Can I do the same with views? e.g ALTER VIEW <view_name> ADD <column_name> datatype I need it to create a "virtual column" which I only need for a certain view in my Programm. I don't need the colu...more >>

I been setting up servers for a year now, and have never setup sql , can some one help me here, this is a true weakness area of mine and need to configure and understand SQL, ODBC and anything else!!! thanks ...more >>

hello I need quick SQL help and your help is much appreciated. I have two coloumns in a table as "START_TIME" and "END_TIME". the data type is DateTime. I want to create a view with an additional column to dispaly difference between these two times as "xx Hours xx Minutes xx Seconds" ...more >>

OK, I'm a total greenhorn. In SQL Server 2000 Dev I have a stored proc which returns its value via an output parameter. In Query Analyzer, how can I 'see' this value? When I execute the proc, the print window says the proc ran correctly, but I don't see the value of the output parameter...more >>

I've been asked to create an online database for my organization with Access as the front end. I'm pretty good with Access and moderate with SQL. In the database, I was told that different users need to have access to certain tables and columsn in those tables. Some users need to be able to creat...more >>

Hi, I'm a new user of Microsoft SQL Server(i'm using the 2000 version). I need to know how to add or update a record in a table in SQL Server from an MFC(VC++) aplication. I've tried to do this but i'm getting an error-"Recordset set as read-only". What should I do to add/update the table ...more >>

I am looking for a simple way to display Usernames of those logged into a simple site I have. Data is coming in from mySQL. Do I need to add a TINYINT to my DB which will switch as they login in and out, or is there a simpler way to show which users have logged on? Thanks! -- Respect...more >>

I am new at this and I am stuck... I am trying to backup an entire database and restore it on the same SQL server with a different name. I have this in the Query Analyzer BACKUP DATABASE merchant TO DISK = 'c:\merchant.bak' RESTORE FILELISTONLY FROM DISK = 'c:\merchant.bak' RESTOR...more >>

Dear all, Someone has sent me some code to amend a table med_records but query analyser is refusing to process it telling me: Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'COLUMN'. I cannot fathom why? Many thanks in advance. ALTER TABLE med_records AD...more >>

Hello All I am new to SQL real new I have downloaded SQL 2005 Bata and loaded it on to a Windows 2000 Server. I do not see any way to access it. I see it running is in services. Am I missing something ? Tony ...more >>

Hi, I have a table that contains orders from cliente. Suppose that each client has more than one order, I would like to write a SELECT statement that returns the order with the oldest date from each client. for example: Table: idClient idOrder orderDate 35 100 ...more >>

Can anybody suggest a good paging logic in SQL Server 2000, which will work with any query? I am looking for a generalized solution, not for a single query or a single table. I am looking for a RowNum like field in Oracle. Is there anything like that in SQLServer 2000? The paging logi...more >>