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