Can anyone explain the difference between MS-SQL and MY-SQL servers....As I notice an outbreak of the network virus ref: Slammer.... ...more >>

Hi.. I'm very new to MSDE and I need to know if some things are possible to do and how. 1). how to attach a database if I have a database file x.mdf and x.ldf without using osql tool? 2). emmm.. maybe later...more >>

...more >>

I need to create a query to show the month as Jan, Feb ... instead of 1, 2. Is there a way to do this? This query works fine except I get the month number instead of Jan, Feb SELECT emLastName, emFirstName, emEmployee, emHireDate, DATEPART(m, emHireDate) AS HireDate FROM dbo....more >>

Hi, I am looking at MSDE as an option but unsure if it supports replication like SQL Server? Does it support all replication options as in SQL Server (e.g. Merge)? If so, I would assume it would replicatable with another SQL Server (from what I have read, MSDE is SQL Server minus the User I...more >>

I am learning Visual c# and have bought a book called c# Evolution which requires "any edition of SQL Server 2000", so I have downloaded the 120 day trial. However the AutoRun does not work and I can not see how to install it. The book offers no guidance, just says "open Enterprioise Manger a...more >>

Hi, I am unsure which version I need to purchase? I want to have the ability to synchronize a remote server with a local server. Here are my specs: Windows 2000 SP4 Management Console v1.2 SP4 C drive: 12G Total, 6G free D drive: 90G total, 66G free 4 physical hard disks in a RAID confi...more >>

I downloaded MSDE2000A.exe file from http://www.microsoft.com/sql/msde/downloads/download.asp. I unzipped this file. I used the following command in DOS window to install it. setup SAPWD="g0612s" /L*V D:/MSDELog.log TARGETDIR="D:\" DATADIR="D:\" But I end up with the following error messa...more >>

Hi, In Enterprise Manager, I want some user to have access in all the DTS but i don't want them to access table in the database. Can I do something like that. thank you -- isabca:)...more >>

How do I index external files (documents not stored in the database) using the full text possibilities in SQL Server 2005?...more >>

I have a maintenance plan to backup my database and the T-Logs. When I go to the directory were I set these to be backed up to I have the DB backups but there are no .TRN files for my t-logs. any idea why my maintenance plan wouldn't backup my t-logs...more >>

I have created a database logged in with my domain admin account which is now the dbo for my new database. I am trying to change the database owner to another user account. Can anyone tell me the easiest way to change the database owner?...more >>

Hi I would like to display the following information in respect of a specific database in one single report? 1. Database size 2. Number of tables 3. Number of rows in each table 4. Number of views 5. Number of stored procedures Is there a stored procedure or command I can use to display...more >>

Following is code I've written to help sort my data on three fields, then "rank" them based on the results. select a1.dealercode, a1.dealername, a1.firstname, a1.lastname, a1.region, a1.district,a1.groupsize, a1.promotionalprogram, a1.PPPPoints, a1.OSOPoints, a1.TotalPoints, a1.completed_m...more >>

Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql ...more >>

I am trying write an application that does what if scenarios. For example, change a few parameters and draw a graph of how that would effect inventory requirements for the next few months. I am new to SQL Server, so looking for pointers on how to implement this. Initially I was going to cre...more >>

i recently installed a program that uses msde/sql. how can i connect to my sql server? i get a prompt that no service has been selected, where do i select the service?...more >>

I need to add a description field in a table - the length of the field will vary for each record. What is the best datatype and field length to use in a case like this?? ...more >>

Hi, I have some data in another database which I need to be able to query periodically and import new records into my SQL Server database. At present I've got an access project which has linked ODBC tabels from this external database and from SQL Server and manages the transfer. What I'...more >>

Please make a recommendation for SQL Server 2000 for a beginner with very little programming background. I need something for a raw beginner. Thank you. ...more >>

Hi I have just converted an access mdb app to an access adp app with msde backend. I am very new to sql server. My question is how do I create replication for a few laptop users who would like to take away the app for a few days and when they come back would like all the new data (laptop & ...more >>

Hi, I am trying to call a remote webservice from within SQl server using CLR. However, SQL Server gives me an error saying that load(), loadModule() etc are disabled. Of what I can tell, C# needs to dynamically generate and load the XML serialization for the web service call. Does anyone kn...more >>

Is there a simple way to copy an entire database to another new one? I need to copy my production database to another for training purposes. Thanks for your help, Juan. ...more >>

I am using SQL Server with Northwind database. My intention is to display all forgien key references for a particular table. declare @objname nvarchar(776) declare @objid numeric declare @cnstid int declare @cnsttype char(2) set @objname='Employees' (select @objid=id from sysobjects wh...more >>

Hello: What is the difference between rebuilding index and dropping the index and recreating it? Any pros/cons in each? Thanks, Q...more >>

Hello: We have a table that has 3 indexes: one clustered and two non-clustered indexes. I am thinking to rebuild them, as some indexes may be corrupted. In general, is there any pros and cons in rebuilding indexes? Thanks, Q...more >>

We have created a database in SQL Server 2000, and now want to distribute this database to msde. Howe do we do this. First how do we get the database structure on msde and how do we get the users into msde. Is there any management tools for msde, like SQL Server/...more >>

Hello, I am new here so I am sorry if this question is a little bit novice:) Here is my problem, I am DBA with some 2 years expirience. I have an database wiht FULL recovery model: Data file is for now about 800 MB, adn Log file on separae disk is 1050 MB. So..I have my back up procedure ever...more >>

I want to write a statement to query object permisions in a database. How do I do this. Thanks in advance for any help. ...more >>

Hi, I am hoping that someone can help me with a question. I could be being a complete donkey, but my SQL experience is limited. I am working on a damage recovery guide for my business. We have a server running SQL 2000 Enterprise edition with a 30Gb database. I am trying to find out if ...more >>

Hi, I had a problem with one database. The hard disk of the server is damaged but I could get the files mdf and ldf for the database. I don't have a backup file, but I wonder if I can recover the database information with these two files. Thanks...more >>

What is " my sql server"and why do I need it ? -- like to be informed...more >>

This is very basic but so am I. I need to switch my database to a new hosting company. I have never used sql but both my old and new hosts have liscenses and will support existing databases but wont help me transfer. I have downloaded the trial version and just need to make a back-up of the...more >>

i am asp.net developer with c#.recently i confronted with a p roblem that is i want to execute a server control in side a script function ,ie when we are submitting a page the 'onclick' function will call say 'saveform()' function,Inside the saveform() function how i can execute a code similar...more >>

Trying to replicate Northwind on the same server in SQL Server 2000. Keep getting the message: [SQL Server Agent on "XXXXXXXXXXXX" currently uses the system account, which causes replication between servers to fail.] If I go ahead and enter the default when asked for a new system I get this...more >>

Hi all I am working on a mp3-Managment-tool with a SQL-Database. I got into troubles with a few files that have '[' and ']' in their filepathes or in any mp3-TagInfo. When I do some queries on these files e.g Select * from Musikdatei Where m_Dateipfad LIKE 'C:\Xavier-Naidoo - Ich kenne ...more >>

I want to do something like: SELECT * FROM table WHERE * <> 'NULL' Obviously I could do this on a field by field basis, but is there an easier way? -- J.B.Moreno...more >>

I am trying to link to another SQL Server from Linked servers. The problem is that I am seeing a lot of tables starting dtPropertiesm MSreplication_options ... sysxlogins But none of "my" tables. I am sure that users have full rights in both servers and I even tried us...more >>

I am an asp.net developer using c# and working in Winxp and wanted to use SQLserver2000 as back end ,while i am trying to install it shows amessage that only client components is possible to install.plz help me what ishould do to install the complete package...more >>

I installed MSDE 2000 with parameters SAPWD='ahoj' SECURITYMODE=SQL Installation was OK, I enabled all networks protocols in SVRNETCN.exe and restared server. osql.exe -L found 1 server: (local); But if I try to start osql.exe -U sa and write a password, osql says 'Login failed for user sa'...more >>

i installed msSQL2000 Enterprise evaluation and it is about to expire (120 days). purchased msSQL2000 developers edition and need to know if i can somehow just overwrite or whatever or if i have to uninstall dev. scary thought. i tried by loading dev sever cd and it did not find my present...more >>

Hi, I hope someone can help with this, I have just downloaded and installed a copy of MSDE 2000, on the pre-text that it would be similar to a standard edition on SQL Server, but this does not seem to be the case, after the install all I seem to have ended up is with a new service in my com...more >>

Hi, I'm having a big problem trying to create a query. I have two tables as described below: Table 1 Table 2 code code col1 col4 col2 col5 col3 col6 col1 has the same kind of data as col4, col2 has the same kind of ...more >>

Can someone help me how to add records from one table that has more columns to a table that has less and some column names not exactly the same. Is it possible to use a select statement to accomplish this? Thank you for the help....more >>

I am using MSDE2000A and in OSQL.exe I try this: 1> CREATE TABLE SomeTable ( 2> tk_Code INT IDENTITY(1, 1) PRIMARY KEY, 3> tk_Text NVARCHAR(MAX) 4> ) 5> go Msg 170, Level 15, State 1, Server TARKOVSKI, Line 3 Line 3: Incorrect syntax near 'MAX'. 1> What is ...more >>

I don't know what I am doing wrong but this create error: 1> CREATE TABLE SomeTable ( 2> tk_Sifra INT IDENTITY(1, 1) PRIMARY KEY, 3> tk_Tekst NVARCHAR(MAX), 4> ) 5> go Msg 170, Level 15, State 1, Server TARKOVSKI, Line 3 Line 3: Incorrect syntax near 'MAX...more >>

We have an data-intensive application that runs for several hours and produces a huge amount of data. The problem is that the transaction log gets very big very quickly and we have to frequently run a job to truncate, backup, and shrink the log. However, when the job is running we get connec...more >>

I need to populate many fields in a column of a table, now that I have the information that goes there. I can't repost the entire table with the new data because the table is now live, underlying a website, and new records are being added regularly. Some who are only slightly more experienced t...more >>

Hi friends, First of all sorry for my english. I'll be very happy if someone can help me. I am doing web page with vb.net and sql server, the problem is with registration. I am using user name and password which the user can set. The problem is that if I already have user with user n...more >>

Sigh. I am creating a View, and in it I need to calculate the values in two columns as another column. Before I run the calculation, however, I need to make sure one of the values is not 0, null, or empty. I'm having trouble figuring out how to do it, though. The field I'm testing is "money...more >>