Perhaps this has already been answered. If so, I apologize. I'm a newbie at this stuff. I have a DTS package to import some Visual Foxpro data. Yes, I said Visual Foxpro. :) The DTS package works beautifully when I rightclick on the package and choose "execute." And it works beautifully w...more >>

Hi, I'm semi-new to crystal reports & sql server and what i want is to extract data from a sql server file. I've been able to connect to sql server directly and get the info. i need but is there a way to just open the data file (in crystal reports) without making a server connection? ...more >>

Hello All, I am currently creating a browser interface for our thick client which was built on Visual Basic using COM ( a three tier environment). We support environments where the SQL database server is separate from the application server. The problem I am facing is this. When I ...more >>

I currently have 2 tables as follows: CREATE TABLE [CRPDTA].[F55MRKT119] ( mhan8 int, mhac02 varchar(5), mhmot varchar(5), mhupmj int ) GO CREATE TABLE [CRPDTA].[F55MRKT11] ( mdan8 int, mdac02 varchar(5), mdmot varchar(5), mdmail int, mdmag int, mdupmj int ) What I would li...more >>

I hosed myself, please help me somebody. We have a development server (SQL7) where the database is a restored copy of production (where we use replication, but not in the development environment). While we rebuild the server recently (so we could move off of NT onto 2000), everything loo...more >>

Hi NG! I wrote a stored procedure which at first deletes 100.000 rows and then inserts 100.000 new rows. There is a huge difference between executing this SP in the query-analyzer (runtime approx. 2 minutes), and scheduling this SP as an Job (runtime > 30 minutes!!!). Why? Whats the i...more >>

I have a 1:1 relationship between tables and am finding that the parent is sometimes mising the child. How do I query for what is not there? TIA ...more >>

I know that a query inside a called UDF does not show up when displaying the estimated query plan, but are the resources (CPU, DiskIO) used by a UDF that is call from within an SProc or embedded in a SQL statement included in sp_who2 and Profiler BatchCompleted? Also how performance drainin...more >>

I have a problem (who not?) with a function which i'm using in a view. This function is a function which calculates a integer value of a date. For example: '12/31/2004 00:00:00" becomes 20041231. This is very handy in a datawarehouse and performes superfast. But here is my problem. My calenda...more >>

Is there any method by which i can get the list of all sql server users? ...more >>

I have taken over a transactional replication setup that is being used for fault tolerance (I know, I know...). The scenario I am concerned with is where the publisher goes down due to failure, so we need to point our application at the subscriber and start updating the data there. We are not...more >>

I'm getting Not associated with a trusted SQL Server connection errors on a .Net windows service I wrote, when it's running on my application server. It's not a problem with mixed mode security. I'm set for mixed mode and I've been running the service on the app server for over a month with ...more >>

Hi, I'm converting an Access 2000 database to Sql Server and must be missing something obvious. Using the Import utility in Sql Server, the Access queries seem to get executed and the resultant data imported as tables. Oops! Using the Upsize lizard in Access 2003, the queries aren't even ...more >>

Hi All, Can anyone recommend any blogs that should be read on a regular basis? Thanks Michael...more >>

Could not initialize GWUTIL.DLL ...more >>

Using SQL2000, I have a DTS that takes data from MySQL to sqlserver, the catch is I want to specify a specific range of dates. How to use a global variable? At the moment I manually changes the dates and jobs run on a daily basis. sample sql statement from Mysql connection: select * from T...more >>

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 >>