I have question about licensing of MS SQL server. I read information about license per processor We are developing application provides large database and few services that make some functions with the data. This application is used by other third party systems (IS) as solution for our clients. I...more >>

Hello all, I got a application which is developed using VB6.0 as front end and MS-Access as backend. Now i would like to change the database from MS-Access to MS-SQLserver. How do I change the databse from MS-Access to MS-SQLServer? Regards Jack...more >>

Dim CnDisp Dim oRs ViewSizePg = 5 Set cnDisp = Server.CreateObject("ADODB.Connection") Set oRs = Server.CreateObject("ADODB.Recordset") The following yields no returned records in an ASP VB page yet, the SQL statement alone yields records in a pure query environment!! Why i...more >>

Sorry just a test ...more >>

I had Microsoft SQL Server 2005 Tools Express Edition Beta 2 installed at a previous point in time. Now the install for the release version fails. The message says that components of the beta product were detected and installation aborts. There is now record of beta software in the Add/Remo...more >>

Hi, Any help would be appreciated. I am looking for information about storing text messages sent by mobile phone in an Access or SQL Server 2000 database. Would anyone have articles,tutorials etc on this subject? Thank you David Kennedy ...more >>

Hello, In my SQL database, I've got 3 types of tables, which I think are used in almost every database. 1. A table which is designed by a dba/developer and contains static data. 2. A table which is designed by a dba/developer and contains dynamic data, depending on what a application us...more >>

I'm adminstering a SQL Server 2000 database on a Dell PowerEdge 1800 server, running MS Win2k3 Server Standard OS. The tape drive is Dell PowerVault 100 / DAT 72, SCSI interface. Dell included, and I installed, Veritas / Symantec BackupExec QSE, which I had been using to perform daily backup...more >>

I have this query which selects items from the News table I want to run a stored proc which cuts the HTMLBody column down too 100 chars and removes html can I do something like SELECT DateIn, Title, EXEC CutHtml(HtmlBody) AS CutBody FROM News ... ? ...more >>

I'm using an access project to view data from a Sql Server database. Is there a way to save the changes I make to the datasheet view (like column width, order, sorting) in the adp file? It used to ask me if I wanted to save changes when I closed a table but it doesn't anymore. Thanks, Mi...more >>

Hi, I have a table with "dates of birth". It is in smalldate format. mm/dd/yyyy (time) I need to select all record in which today is their birthday. Meaning the month and the day are the same as today's How can I make this 'select' ? I tried: Select * from users where dob = MMCo...more >>

we are installing sql server 2000 Enterprise edition on windows 2003 server. The thing we want to do is when we install sql we want the sql transaction log files to be in seperate drive because sometime they tend to be really big. can somebody please tell me how to do it thank you shoby ...more >>

How can i determine the reason of the first error ? It started somehow when the admin restarted the server..But he claims he did not do anything at all.. Sql Server Agent is logged on domain server as administrator not as local system .. Thanks 1-Windows cannot determine the user o...more >>

Is there a way to programmtically copy data from a database on one server to another database on another server without them being linked? I can do it through dts but not through t-sql. For instance, CREATE TABLE [dbo].[tblStuff] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Code] [varcha...more >>

I would like to know if I should replace all ntext datatypes in my current database with nvarchar(max) or is it only for use in stored procs? Is it possible and if so would it make the database size less? ...more >>

Are views faster than stored procedures if you're working with a complicated select query with lots of joins, etc? Or is it just easier to maintain. When should you use a view instead of a stored procedure? ...more >>

Hi All, I want to know when dbo.MSdistribution_history table will be created and where it will be present (under master database or any other database)? I think this table will be created when you enable replication on your SQL Server and will reside under master database. Please correct...more >>

I am trying to do the following: Objective: Check to see if a store has recorded 'Actual' sales at least once for each three month period starting 1.1.00 through 3.1.05. At least once for Jan, Feb, Mar of 2000. Then at least once for Feb, Mar, Apr. Then Mar, Apr, May, and so on through to t...more >>

Hi everyone, I am trying to setup a backup plan for a 10Gb database about to go into production. I setup a Database Maintenance plan that takes a database backup twice a day 6am and 6pm. And Transactional log backups every hour between 7am and 10pm. Is this the best way to take regular d...more >>

an someone please help. I get the error below on a regular basis which causes my PC to freeze. I am running a Win XP Pro SP2 box with 1GB of RAM and a 3.2Ghz Intel P4 processor on a Gigabyte mobo. Any help with be appreciated. Event Type: Error Event Source: MSSQL$SQLEXPRESS Event Cate...more >>

I have made a DTS package to export data from three tables to an Access database file. It works fine but I would like the exported data to overwrite the existing data. Currently it appends the data to the Access database. How do I specify that the contents of the Access database should be...more >>

You can easily enter a description at a table field. But how can I enter a description for the table itself?...more >>