Here's what's going on. I have a 2 computers (x & y) running SQL2000. I backed up a copy a DB from x and restored it on y. I have a Stored proc that runs in under 2 seconds on both x & y when running it through Analyzer, but when I call this stored proc running it throuhg my C# winforms app (run...more >>

hello, i would like to loop through a record set and assign each value to the same string, (example i would like to return all of the first name in the authors table = Authors_total.) should i use a cursor or just a loop to do this? I have had some trouble with the syntax in a cursor. ni...more >>

Using JDBC, is there a way to call a stored procedure with multiple return values? Thanks. ...more >>

Hi all, I have the following tables: A1 == HostID Name RunID ------ ---- ----- 1 host1 NULL 2 host2 1 3 host3 NULL A2 == RunID SessionID ----- --------- 1 4 2 2 A3 == SessionID Name --------- ---- 4 Session1 2 ...more >>

Does anybody know how I can change the default value for a column? I was trying to remove the default value in order to add the new one afterwards. This is what I tried: alter table /table-name/ drop default for /column-name/ alter table /table-name/ alter column /column-name/ (/new-decl-w...more >>

Hi, I am evaluating Lumigent's Entegra for doing security and business audit of some of the critical database(s) in the company I work for. I would like to know what has been your experience in using this product for doing similar audits in your company, if you have also done such audits. ...more >>

Hello, I am relatively new to doing non-trivial SQL queries. I have to get data out of 8 diff views based on a parameter Name. There is a view having name-ssn pairs. All other views have SSN field. For a person there MAY NOT be data in all the views. I have to populate data into diff ...more >>

When I export a table from my local SQL Server to my web-host's SQL Server, the primary key never seems to export. This happens whether I use the "Copy tables and views..." option or the "Copy objects and data..." option. Anybody know why this happens? ...more >>

Hi Is it possible to use Visual Source Safe with SQL Server in order to keep track of all modifications done to stored procedures? What are the pros and cons ? Thanks, Eugene...more >>

I'm not asking a lot. I just want to know if I can connect from an Exchange server to a SQl server without having to use Access linked tables. Surely MS must have had a look at this but I can't find anything out there. Help appreciated. Ginters ...more >>

I have written a trigger that's supposed to go out and delete corresponding records from multiple tables once I delete a specific record from a table called tblAdmissions. This does not work and I'm not sure why... Here's the code that's supposed to run, let's say, if a user (via a VB 6.0 i...more >>

I have a quick question. I have not been able to find any information on database prioritizing. I have several databases on a single server(sql server 2000), but one needs to have processing priority over the others. Is it possible? If anyone has or knows of somewhere I can read up on this s...more >>

Is there a way to copy the structure from one database to another without affecting the actual data? For example, I added new fields and stored procedures to a db in my development environment. There are a lot of them. I now want to make the same changes to my production environment db but ...more >>

Front End: Access 2000 Project (.adp) Back End: SQL Server 2000 I have an application that keeps timing out. I have opened the DataLink properties in the front end (File, Connection, Advanced tab) and set the timeout to 999. But the connection still occasionally times out. Any ideas? ...more >>

I would like to increase the length of the column from LOCNumber VARCHAR(30) DEFAULT '' to LOCNumber VARCHAR(100) DEFAULT '' without losing any data currently stored in the field. And it has an index on it defined as CREATE INDEX LOCIndex ON BookData(LOCNumber) Thanks for any help...more >>

Hi all! I just tried to enable TCP/IP on SQL Server 2000 (trial, SP3a). The Server Network Utility shows it's already turned on, but after restarting the server doesn't listen to any TCP port, and in the eventlog it reports "SuperSocket info: gethostbyname(MSAFD Tcpip [TCP/IP]) : Error 11004....more >>

Greetings - I'm using an Access front end to a SQL Server (2000) databas=ADe. Via several steps, I create a temp table and manipulate the data=AD in it. I want to update the backend with this new data but my UPDATE =ADquery fails as my temp table is local and the SQL database doesn't know...more >>

I have website problems with mySQL data base, I have a website and was told the only way to change my password is within my SQL data base files and that it would be over my head buy the site maker, How can I do this ? I know my password now but it was changed today my the web site maker, I have had ...more >>

I'm trying to determine which user has locked a given record from VB6. I know I can use sp_lock and sp_who, and match up the data to determine which users have locked records in my database, however I haven't seen a way to match the specific user to the specific record. What am I missing here?...more >>

Hi, I copied the DATA directory from a backup ghost image to a new SQL 6.5 installation and, after fixing a problem with the directory structure (which caused the databases to be marked as "suspect") I was able to work with it in a normal way. Opening the company database wo...more >>

Hello group! I've just started using SQL Server 2000. I installed a while ago. I tried a lot to register a server but it only gives one message that "SQL server doesn't exists". My aim is to create desktop applications suing SQL Server. I don't need any networking facilities... I'm using Wi...more >>

Is it possible to exec a Cognos report from a SQL job? -- Message posted via http://www.sqlmonster.com...more >>

Hi, I'm in the process of implementing a multi-user system containing an adjacency list (tree structure). I'm using a TIMESTAMP field on each record in the adjacency list in order to tell when a node has been changed since the last read. Sometimes though, it is useful to flag a "parent" ...more >>

In the process of doing some routine monitoring/clean-up we've discovered that several (many?) users are apparently set to access our SQL Server 2000 database instances via the Named Pipes protocol. In readings and recommendations we've decided that our WAN would be best served if we use the les...more >>

I am using Microsoft SQL Server 2000 and have a question about our database design. Here is a sublist of tables and columns we currently have:- Employee ---------- Ee_Code PRIMARY KEY Ee_Name NOT NULL Branch ------------ Branch_ID PRIMARY KEY Branch_Name NOT NULL Is...more >>

Hi all, I have a table called PTRANS with few columns (see create script below). I have created a view on top that this table VwTransaction (See below) I can now run this query without a problem: select * from dbo.VwTransaction where AssetNumber = '101001' and TransactionDate <= '7...more >>

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 id 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...more >>

Hello, I have SQL Server 2000 Developer Edition. Where is SQL Server Network Utility? In Start menu SQL server group I have only Client Network Utility :| Is it a command line tool or sth? How to install it? tnx -- STEFAN ...more >>

Hello, How to determine, which ports do MS SQL Server instances listen to? I want to conect to sql server using PHP and I need to know exact port number. I suspect that my SQL (msde) server instances don't listen on default 1433 :] -- Stefan ...more >>

I'm having a ton of trouble with a dataset. It builds at design time, but fails at runtime, saying: --------------------------- Processing Errors --------------------------- An error has occurred during report processing. Cannot set the command text for data set 'ds_Legal_Entity'. Error dur...more >>

What is actually happening behind the scenes when you open a connection to sql server in code such as C# or vb.net. ...more >>

If I use BCP to export a very large table will that table be blocked for writes during the export process? I don't want to prevent users from accessing that table during the bcp process? Thank You, TFD. ...more >>

"I've created a customer table and I want to give each customer a unique id e.g 'ES001' But sql server won't let me I've looked at various books to no avail. My second question is when I delete a row from a table which had an ID of 2 when I put in a new row it gives the new row and ID of 3 how...more >>

I have a stored procedure that has some problems with slow performance. The procedure has 2 parameters @firstname varchar(100) @lastname varchar(100) These parameters can have values like a%, that is wildcard searches. The strange thing is that if one of the parameters has the value %, and ...more >>

Hi, Just found out that this error can be solved Server: Msg 7619, Level 16, State 1, Procedure usp_ft, Line 2 A clause of the query contained only ignored words. triggered when executing SELECT TOP 1000 * FROM ADS JOIN ADSFULL ON ads_adid = fads_adid WHERE (ADS_ADID IN (SELECT FADS...more >>

Can someome please advise what the equivalent query would be in Microsoft SQL Server ... I've tried a number of combinations with no success ... Thanks, Ralph Noble (ralph_noble@hotmail.com) ================ UPDATE INVENTORY INNER JOIN SALES ON (INVENTORY.BAR_CODE = SALES.BAR_CODE) AND...more >>

Hi, I've got a full text index which works fine, SQLSERVER2000/WIN 2000 SERVER. The system requires to update indexes immediately, so I use a timestamp field to enable this. No problems so far. Now, I've got a stored procedures which nearly daily inserts about 10.000 rows. When doing th...more >>

I'm looking for a tool that can extract only the schema from a database in a form that can be used to generate that schema in another empty database. This is to facilitate our disaster recovery processes where we need the objects only, not the data, and need to replicate this to our disaster re...more >>

How can I print the structure of a table from Enterprise Manager? Or is there another app that has a print option?...more >>

I've ready many of the posts on this and other newsgroups in which people describe working practices for source control of database scripts. We are looking to implement something similar in my current workplace. We have agreed that developers should not modify objects such as views or stored ...more >>

Greetings All, I was wondering if any of you would share some of your experiences regarding the task of loading a data store from an Oltp source. We are using Analysis Services in a BI product that requires data to be pulled from one of our products, an OLTP database. The design is to first ru...more >>

Hi, I would like to use database locking mechanism to control access to an external resource (like file system). What I need is 1. an exclusive (write) lock conflicting with any access to the resource (both for read and write) 2. non-exlusive (read) lock conflicting with writes only How this ...more >>

Hi, I've been creating a db application using MS Access and MSDE. Only two of us are using the application, and the server and the app both run great on my laptop (1.6 GHz Pentium M, 2GB RAM, W2KPro). Only problem is when I take my laptop home, my coworker loses access to the server. We r...more >>

They are corrupt. I cannot get the odbc driver applet for sql server to open when I click add and I cannot configure any existing ones. And the usage of the drivers fail. Other ODBC drivers work. Does anyone know how to reinstall the SQL Server set of ODBC drivers? MDAC wouldn't install, ...more >>

Hi all, I have a database with 40GB of binary objects stored in image columns in two tables. Our database server is also used for another 15 databases. SQL Server caches the image-column, causing the cache-hit-ratio to dramatically decrease, since fetching a couple of binaries from the ...more >>

Hello. Can you point me to books or good documentation that could help me in understanding in detail the dbcc showcontig output (and the output of other command that analize the status of a DB) and permit me understanding what is going on and taking appropriate action? Do you think a Micros...more >>

Is there any other way which is more simpler(shorter) to get the date part (I don't want the time part ) of Datetime than this ? Convert(nvarchar, DATEPART(dd,[Date]) ) + '/' + Convert(nvarchar, DATEPART(mm,[Date])) + '/' + Convert(nvarchar, DATEPART(yy,[Date])) As [Date]...more >>

Hi all, I have a stored procdure which does a select and returns the records directly -i.e. Not in output parameters e.g: CREATE PROCEDURE up_SelectRecs(@ProductName nvarchar(30)) AS SELECT * FROM MyTable WHERE [Name]=@ProductName In another stored procedure I need to do the followi...more >>

I need to conect my software from a remote client to a server, my standard connection: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=;Initial Catalog=MyDb;Data Source=192.168.0.100;Network=DBMSSOCN; and Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Pas...more >>

Hello all, I'm trying to write a stored procedure that will prompt the user for a date range and produce a report based on that date range and 4 incident types. I only need count how may times these incidents happen within the data range. The query looks like this SELECT incident, @Ente...more >>