I'm looking for someone to either redesign the Northwind Access customer database supplied by Microsoft (I've modified it some myself and have been using a similar system for two years). Alternatively, write a completely different system using SQL instead of Access. I must be able to modify all ...more >>

Dear Group Some but not all of the dates are incorrect converted (incremented by 1 day) with the following SQL statement. SELECT DISTINCT CONVERT(datetime,cast(ReturnedByDate AS int)) AS ReturnedByDate, CONVERT(varchar(10),ReturnedByDate,104) AS LabelReturnedByDate, ReturnedByDate FROM i2b_...more >>

currently my select produces the following output: "a", "b", "c" I would like it to be: a | b | c does anyone know of a way to eliminate the double quotes and substitute the pipe for the comma ? thanks, ...more >>

Hi, Does anyone know how I can connect to an MSDE db using VB with a read-only file? The file will be on a CD, and is actually just archived data off a SQL server. I would like to package my app on a CD along with the data file and allow users to pop in the CD and run the app, assuming they alr...more >>

I have a database that is being used as sort of a reports data warehouse. I use DTS packages to upload data from all the different sources. Right now I have it truncating the tables and appending with fresh data. I was considering using updates instead and my question was which is more efficent?...more >>

Hello all, I am trying to correctly model the relationship between products and versions within my db. The problem I have is how to store the version data. I need to collect the following information: 1) Major Build Number (int) 2) Minor Build Number (int) 3) Build Number (int) 4) SP number...more >>

Using SQL against a DB2 table the 'with' key word is used to dynamically create a temporary table with an SQL statement that is retained for the duration of that SQL statement. What is the equivalent to the SQL 'with' using TSQL? If there is not one, what is the TSQL solution to creating a temp...more >>

Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with the error. LazyWriter: warning, no free buffers found. After that I have to restart the SQLServer service to get things up and running. How can I prevent this from happening? Thanks, Ray ...more >>

Does anyone know of a quick reference I could provide to the it security folks at my work that outlines what file extensions, ports, and dll's sql server uses? They've gone hog wild with 'security' software here to the point that they invariably end up shutting down one behavior or another with...more >>

How do we pass on the step1 output file to step2 of the same job? I would like to know the current job's output file programmetically, instead of hard coding it. Any idaes would be appreciated. Thanks ...more >>

Can anyone tell me if it is possible to move the data directory of SQLServer from the application server where SQL runs to another system (the file and print server) in the network? regards Joop ...more >>

I am creating database with script sql file running in command prompt. The database files are created but database is not shown on SQl Server .. wat am I missing here? The databse script is CREATE DATABASE Budget ON ( NAME = Budget_data, FILENAME = 'c:\mssql7\data\Budgetdata.mdf', SIZE = ...more >>

How can I create a new database on sql server using OSQL command in command prompt. I have the sql file for database creation and I use the following command C:\> osql -S servername -U sa -i db1.sql it prompt my for password n i enter it since sa has a blank password but after that it returns...more >>

I am kind of confused about the way SQL Server 2000 handles the hints that users supply with their SQL statements. >From BOL, it seems that one can specify them with "WITH (...)" clauses in SQL statements known as table hints. Sometimes, multiple uses of this form in a statement is OK. Then ...more >>

Hello -- Is there a way to configure 2000 so it will save a view layout after I change it in the diagram pane? Thanks for any help. Larry Mehl ...more >>

I have the following code but do not know the best way to return the = updated DataTable back to the database. I believe I can use the Update method of = the Data Adapter, BUT if true, I also believe I have to 'long-hand' write = code for each individual column data that's being added......thi...more >>

i have win xp and i trying to install ms sql server 2000 Enterprise Edition on it but after i try to do this i get a following message "Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only clients components will be available for installat...more >>

I've written several survey systems in which the majority of the questions have the same or similar responses (Yes/No, True/False, scale of 1 - 5, etc). But this latest survey system I'm working on has 8-10 sections, with a variety of question attributes and answer scales. Some items have jus...more >>

I have to create database usign OSQL. i am usin a command like this C:> osql -E -i db1.sql But it doesnt create database and returns error saying user login failed for administrator whereas I have no user for SQL server n it uses by default . I also tried with sa username by entering it with...more >>

Folks, Sorry 'bout this. I'm sure it must be an FAQ, but I can't find the answer after many hours of looking :-( I don't know the SA password any more. Is there a mechanism for setting (or resetting) this to a known value? My assumption is that the encryption is sufficiently strong that ...more >>

Hey, could any one help me with sample sql statements to get user wise / date wise activities happened in the database by analysing log ( or database ) ? My aim is to get output of INSERT, DELETE, UPDATE statements fired by db users, date wise. Thanks in advance, ...more >>

Hello. How to execute add users window, backup wizard and other windows from Enterprice Manager on client machine? Does MDAC or sth is able to do this? bye... -- __ __ |__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve |__// |__|| | \\ \__// / \\ +------------...more >>

I need to log all users connecting to any database on my SQL Server 2000 cluster. Anyone know how I can accomplish this ? Ta, CJ. ...more >>

Hi ; I m trying to create Merge Replication. I was able to create the replication on the same machine, however my aim is to use client machine and do all the neessary work on the client machine and then synchronize to the server. Thus, I have installed client version of SQL 2000, I connected ...more >>

This is my query select ano,max(date),a_subject from MY_TAB where table_name='xyz' and ano=877 group by a_subject,ano order by a_subject ANO max(Date) A_Subject 877 2005-01-20 00:00:00.000 Subject_1 877 1900-01-01 00:00:00.000 Subject_2 877 2004-12-20 00:00:00.000 Subject_3 877 2005...more >>

I have the following situation. One set of data has 274 rows (set2) and anther has 264 (set1). Both data sets are similar in structure as well as values for both of them were extracts from the same parent table. Hope the info would substitute DDL. I need to find the "gap" rows between these ...more >>

Hello -- I think this is the term for what I want (something that could be generated in ACCESS using a pivot table, or, maybe Yukon). We have data for sales by sales people in sales regions. More than one person sells in a region. We want to display data as follows: ...more >>

I have a field in a table that contains ten digit value representing a datetime. Is there any way to convert it to default datetime format Thanks -- Message posted via http://www.sqlmonster.com...more >>

I need to create a C/C++ function using ODBC interface to get the string length of a column in a table. What is the proper function to use ? ...more >>

Dear group, kindly please answer me my newbie question :-) I want to connect to a remote SQL-Server using sp_addlinkedservers and "openquery". I tried and tried and I couldn't get it to work. Then i found out, that it works with a different server which doesn't have the '-' character withi...more >>

I have XP workstations and windows 2003 SBS. I setup an ODBC for an application (tried both User and System DSN), but after a few usage, I get the following error: Connection failed: SQLState: 'HY000' SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context. A...more >>

Hi., Can restore master database and other databases from one server to other. I cant restore master database. i stared server in single user mode, and restore master database. it says successfully restored and server stoped. I cant up the server... :( Regards dishan ...more >>

Hi, I have several big tables with rows more than 25 mil rows and to update/delete/insert data in these tables, it can take minutes. I use BULK Insert/DELETE/Update with osql. While I run one of these updates, if I try to select, it seems like both read and write get locked. Shouldn't SQL res...more >>

I have a situation where I have an app that uses a sql server (msde) database. The app will be used in environments where no one should be able to manipulate the data except the developers (app admins) - not even site database admins. When the application and msde is installed, a default instanc...more >>

What I'm looking for is a list of roles a particular user is a member of. the closest I've found so far is sp_helprolemember without any arguements. but this gives me all the roles and all the users. I want this same list filtered on a specific user. something like sp_??? 'user' ...more >>

In SQL Server is there a way to know when a procedure was last modified? I only see the "Create Date" column on the Enterprise Manager. Thanks Experts! ...more >>

I have two problems. (1) After rebooting server, someone frequently failed at the first login. But sometimes later, even only a few minutes later, the 2nd login will be ok. Why? (2) the SQLAgent jobs are in general ok, but only the jobs generated by maintenance plan are not running. Why? Thanks...more >>

I am in the process of evaluating some SQL Performance Monitoring /DBA tool to purchase (For SQL Server 2000). I have the following list of software that I came across and have to finalize which one to recomend for purchase by my company. Quest Central=AE for SQL Server Performance Center by ...more >>

Does the order in which Joins are peformed (from left to right) matter whether inner or outer when it comes to performance. Assuming that all indexes are the same but the size of the tables is different? For example let's assume we have 5 tables, TABLE1, TABLE2, TABLE3, TABLE4, TABLE5. For ...more >>

hello all. please tell me why the following update staement doesn't work. what i want to do is update tblmaster.mcol2 based on the value of tblheader.hcol2 hcol2 values: 1 = add ( tbldetails.dcol3 * tbldetails.dcol4 ) to mcol2 2 = subtract ( tbldetails.dcol3 * tbldetails.dcol4 ) from mco...more >>

Right now both of these reside on my C:, but templog is over 3 1/2 GB. 1) What do I need to do to move both of these to another drive on the same system? 2) Is there an easy way to purge or compact templog, or just set a size limit for it? Thanks, Scott ...more >>

Dear All, I have one field in my table which shows the day of the week. It is showing Sunday = 1 Monday = 2 Tuesday = 3 But i want Monday is the first day. I know i can use DATEFIRST to change it but it works in Query Analyzerbut when i come and see my table it is showing the old setti...more >>