Hi, I have SQL Server 2005 installed on my dev system. I am working on an app that i would like to distribute SQL Server with. SQL Server EXpress edition seem to be ideal for this. My questions are: -If i installed Express Edition, Can both SQL Server 2005 and Express Edition coincide peac...more >>

Hello, I have a SQL 2000 installation on a small partion that I would like to move to a second larger partion on the same disk array array with the config as follows: d: full installation of prod and test instances with data and log files 100 GB e: empty partion with 204 GB which I want to mov...more >>

OK, I tried this: USE Alert_db; BULK INSERT funds FROM 'C:\\data\\myData.dat' WITH (FIELDTERMINATOR='\t', KEEPNULLS, ROWTERMINATOR='\r\n'); And I got the following errors. Msg 4864, Level 16, State 1, Line 3 Bulk load data conversion error (type mismatch or invalid chara...more >>

Hi, I'm running SQL Server 2000 on a Windows 2003 server. It's serving several small web site databases. About a month ago my automatic backups stopped working, and whenever I try to edit or set up a new maintenance plan or export or import data through Enterprise Manager, I get the foll...more >>

Please consider the following example. CREATE TABLE test ( an_ndx int NOT NULL primary key identity(1,1), a_var varchar(48) NOT NULL, last_edit_timestamp datetime NOT NULL default CURRENT_TIMESTAMP ); CREATE TABLE test_history ( an_ndx int NOT NULL, a_var varchar(48) NOT NULL, ...more >>

Hello. I want to ask about the possibility of copying both a table structure and it's contents from a SQL server table to a table within MS access. The problem cannot be solve with a permanent table structure at the target location. The names of the columns are essentially data with the applic...more >>

I'm implementing some database formatting and I need that values within a column have certain limits ... let's say for example, they shouldn't be <0 or >10000, but in the case I'm inserting values bigger then 10000 I would like that MSSQL "clip" this value to the upper limit (10000 in this case)...more >>

The following data set is building inspection visits. It consists of multiple visits (2+) made to the same building on the same day. I want to get a list of visits made to the same building on the same day, but by different employees, and for different visit codes (eg records 5-6, or 9-11)...more >>

Hello, Could you help me please to solve the prblem with connecting to SQL Server from .NET development environment? I have the following error: "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact tha...more >>

Hello, What is uniqueidentifier as a data type? Also what is the data type for setting unique STRINGS ((nchar, nvarchar), for example to be used for emails and user names in a user registration system). SQL Server does not allow me set primary keys for columns where data types are not IN...more >>

Several prominent researchers are conducting a survey and looking for 500 respondents by Friday on the topic of enterprise architecture and software development. Here is the link to the survey: http://www.surveymonkey.com/s.asp?u=845572436515 After completing the survey, results are displayed ...more >>

Hi, I am writing code for the subject version and am trying to find the equivalent of SELECT SaveDate FROM Performance WHERE IDENTITYCOL = IDENT_CURRENT('Performance') In other words I need to return a field in the last row of a table. v7.0 does not recognise IDENT_CURRENT Any offers?...more >>

Hey, I was wondering if it was easy to migrate from SQL Server 2005 Express to SQL Server 2005 Standard? If so, do you know how I can go about doing the migration of data? Thank you. Sincerely, Eldhose Cyriac ...more >>

Here is one such function: CREATE FUNCTION my_max_market_date () RETURNS datetime BEGIN DECLARE @mmmd AS datetime; SELECT max(h_market_date) INTO @mmmd FROM holdings_tmp; RETURN @mmmd; END One change I had to make, relative to what I had working in MySQL, was to insert 'AS...more >>

What I would LIKE to do is noted in the subject line. What I'm finding is that "edit SQL" appears to only be an option if I am creating a table. If I select "append to" the option to edit SQL shades itself as unavailable. The reason I'd like this is that there is a datum in the flat file that ...more >>

Not sure if there is anyway to do hots on sql server .From all I have heard an EMC can do clones and fractures in order to implement a hot backup or some kind of it in sql server. Seemingly the DBA has to do something to enable the fracture of the clone . Is anyone familiar with this ? Your in...more >>

I am having a issue with a customers server. the specs are: 2003 server sql 6.5 log file size is 1998MB (customer increased this 2 times this week) Log space avail:600mb In EM i try and truncate the log file... but the free space never increases. Also there is no maint. plan on this databas...more >>

Hi, I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to 2000. I am only choosing to update a single database, not system objects. The Upgrade wizard connects to SQL 6.5, checks the db, creates the db on SQL 2000 with all tables and imports users from SQL 6.5. The pro...more >>

I volunteer for a non-for profit group and they have alot of names in a multiple databases. the problem is that some people are in multiple databases. and if they send out a mailing from multiple databases some people get 2 and 3 of the same thing. my idea was to either make or find a program th...more >>

hi, how do i change the table's owner as dbo using sql server 2000 query. kalai ...more >>

In MySQL, I use "LOAD DATA INFILE 'my_path/data_file.txt'" to load data from a plain text file. Of course, the actual statement is a bit more complex once one considers the various options (e.g. comma delimited vs tab delimited, record termination strings, &c.). My problem is that I have yet ...more >>

Hello, I am trying to migrate data from a DB2 database to SQL Server 2005 database. Does anyone know about any migration tool that does that? I have heard about DB2 Migration Tool kit, but I think you can only migrate data to a DB2 database with that. Thank you. Sincerely, Eldhose C...more >>

Hi, I am new to MS-SQL and I have a problem. Actually I have made similar queries on Oracle, but now I failed on MS Sql. First of all I am using SQL Server 2005, but I think it is not that much important because my question is related something fundamental. I want to compare the result (whi...more >>

Any assistance is appreciated. I would like to know if there is a way to specify the path for database log files to be located during the SQL2005 Standard installation. Under the Advanced button there is the ability to specify a different path for data files but nothing for logs. Thanks in ...more >>

database has been recently upgraded from ms sql 2000 to ms sql 2005. are there anything I need to be aware after upgrading to ms sql 2005? for my experience, i got an error if i use column alias in ORDER BY clause which was fine on ms sql 200. thanks ...more >>

We're planning to migrate our db to new and more disk drives, faster RAID levels and more dedicated disk usage(e.g. placing the translog on dedicated disks). The db server runs on Win2003. Right now we're thinking about what file system to use on the new drives. We opt for performance, but exp...more >>

I am trying to change owner of all tables in a database. How can I do it? ...more >>

Hi, I have a prod database (main bread & bread DB) and have a small access database that sales team is using... I created a login inside SQL 2000 and gave db_read permission and SELECT permissions... and public. Role of public is EXEC store procs and view some systables... I linked those ta...more >>

1) In several tables, in my MySQL version, I created columns using something like the following: `ab_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, This allowed me to ensure that when a record is either added or edited, the value in the field is set t...more >>

Hello, I tried to make what one reply advice to recover the disk space after DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table but nothing changes. Any other solution? Ignacio ...more >>

Understand, I have developed a number of applications using RDBMS, including MySQL, PostgreSQL and MS Access, but this is my first experience with MS SQL. I'd bet my bottom dollar that MS SQL supports what I need, but I just haven't found where it is explained in any detail in the documentation...more >>

Hi. I have a table with the following *COLUMNS*: PIN# # of weeks when Overtime > 8 Overtime Week 1 Overtime Week 2 Overtime Week 3 .. .. .. Overtime Week 52 I need to calculate the # of times when in column "Overtime Week X" for the current PIN# appears a number >=8, and write in ...more >>

I'm having trouble accessing SQL2005 Standard Edition as a second instance of SQL Server where the first instance is SQL 2000 Enterprise Edition. I installed SQL 2005 as a named instance "SQL2005". The server is running Windows 2000 SP4 ON A 32-Bit machine. When I look in Services I see the S...more >>

Hi All, I have two database that are duplicates of each other - but are on different servers. I need to write a script that will do a select from one table and then compare it to another select of that table - but on the db on the other server. Is it possible to do that in a script? I...more >>

Hi all there, I'm a newbee to this forum. I've a question, is there any limitation on "IN" clause in select query. for example : "SELECT EMP_ID, EMP_NAME FROM EMPLOYEE WHERE EMP_ID IN ('EMP1001','EMP1002','EMP1003', etc, etc, so on)". I've read at some documentation that there is a limitat...more >>

Hi, I have a problem, when I want to access to my SQL Server Express database from my ASP.NET application. My workstation ID is KITOLAP-HP My username is user01 Now I built the following connection String (VB.NET): Dim workstation As String = System.Environment.GetEnvironmentVariable("compu...more >>

Hi, I need to add 48 hours to a specific date (datetime data type) then check if the time is past 5pm. So for example the time is 7pm. If this is the case I need to set the time to 5pm the next where the final date and time will be set to a new datetime variable. Can anyone help?? E...more >>

Hello everbody, Our system is using Sql Server 2000 on Windows XP / Windows 2000 We have a text file needs to be imported into Sql Server 2000 as a table. But we are facing a problem which is, Sql Server claims that it has a character size limit ( which is 8060 ) so it cant procceed the import...more >>

Hi Gurus, Our system is using SqlServer 2005 on XP.( On my machine,only this application access SQLServer.) The sqlserver memory is configured to 128MB (Min)~512 MB(Max) After our system get started, sqlserver takes about 100M memory. After the system runs for a while, the memory used by sq...more >>

Hello, I'm trying to accomplish 3 things with one stored procedure. I'm trying to search for a record in table X, use the outcome of that search to insert another record in table Y and then exec another stored procedure and use the outcome of that stored procedure to update the record in table Y...more >>

Our shop is expanding use of SQL Server, both 2000 and 2005. We have Litespeed on some boxes to handle the backup/recovery jobs. Can I ask what are considered the best tools for monitoring SQL Server, in terms of things like performance monitoring, tuning and auditing if it is possible to get al...more >>

With reason of the enormous effort carried out to visit the Argentinean city of C=F3rdoba, to participate in the Meeting of MERCOSUR, in the closing of the Summit of the Towns in the historical University of C=F3rdoba and in the visit to Altagracia, the city where Che lived in its childhood and ...more >>

Con motivo del enorme esfuerzo realizado para visitar la ciudad argentina de C=F3rdoba, participar en la Reuni=F3n del MERCOSUR, en la clausura de la Cumbre de los Pueblos en la hist=F3rica Universidad de C=F3rdoba y en la visita a Altagracia, la ciudad donde vivi=F3 el Che en su infancia y unid...more >>