I am looking to make a program using express edition Visual C#. I want my application to interact with Microsoft SQL server, create tables, inserts, lookups, the normal. First I would like to read the documentation,and now to the point of my post. Due to the (recently pointed out) ineptitude...more >>

Use the Northwind database Products table as an example. Purchasing dept gets a report showing when inventory items on hand qty are below the reorder level. easy enough: Select ProductID, ProductName, SupplierID, UnitsInStock, ReorderLevel from Products where (UnitsInStock < Reord...more >>

I am replicating an 80GB database between NY can CT and would like to know why table sizes are different between the two. Here is an example of sp_spaceused:: NY IOI_2007_04_23 rows(279,664) reserved(464,832) data(439,960) index_size(24,624) CT IOI_2007_04_23 rows(279,666) reserv...more >>

hi, CAn i have one trigger for both Update and Delete Delete Trigger --------------------- create Trigger [tr_delete_user_log] on [dbo].[user_log] for delete as begin insert into z_user_log select * from deleted end Trigger Update --------------------- CREATE Trigger [tr_update_user_lo...more >>

The Topics Covered In This Book Are: Understanding the Oracle Environment; Understanding the Oracle Instance; Understanding the working of Oracle Instance; Understanding the Oracle Database; Oracle 9i Software Installation; Oracle 9i Database Design using DBCA; Enabling other computers to access...more >>

I have SQL Server Manager 8.00.2039 installed because I have one program (app) installed that requires it be installed. For the first little while when I had SQL server installed it would only show up in the taskmanager tray, now MOST of the time, it shows up as a popup on my desktop and al...more >>

Hello! I have an big table with 50Gb data, written som functions that cleanup data and want to do something like this insert into newtable select id, func1(col1), func2(col2) from oldtable; I'm also plan to make newtable partioned (before insert). But how could i get the insert as fast ...more >>

Hello there... I had an intrusion into my DB and I'd like to analize the log looking for the moment and the IP the modification was. Does anyone know about free software for this? Thank you. ...more >>

Hi; My company just installed MS SQLServer 2005 ( see below the dotted line ). When a user logs into management studio all of the databases on the server are displayed in the right hand column. What can we do to have only the databases the user has rights to, display? Thanks much in a...more >>

Hi, I'm trying to do retrieve some data from a table where the content is in Greek, however, the query is not working. It's a very simple statement, but I'm missing something. Here is the table... if exists (select * from dbo.sysobjects where id =3D object_id(N'[dbo]. [REPORT_LOCALE]') ...more >>

I had thought that I had posted this yesterday but since I cannot find it here we go again. I have searched the archives but either the code I want is not posted or I missed it. I have a user create role in a database that I need to reproduce in another version of the database. Does anyone...more >>

Hi All I am updating a local table based on inner join between local table and remote table. Update LocalTable SET Field1 = B.Field1 FROM LinkedServer.dbname.dbo.RemoteTable B INNER JOIN LocalTable A ON B.Field2 = A.Field2 AND B.Field3 = A.Field3 This query takes 18 minutes to r...more >>

I would like to remove an index from my database, but I need to verify that it is not being accessed before I do that. I tried running Profiler, but it doesn't seem to be giving me the information I need. I put in a filter for ObjectName, but it seems to be ignoring it - i get several entri...more >>

Hi, I have a funny situation. Within: MSSQL 2000 SP3, everything below described is running on same PC. there is a program running, which sends information to two other programs. This information is a timestamp of the program in datetime format, which has it's own clock. The clock is inc...more >>

I am looking to populate a Schedule table with information from two other tables. I am able to populate it row by row, but I have created tables that should provide all necessary information for me to be able to automatically populate a "generic" schedule for a few weeks or more at a time. ...more >>

Hi, I'm designing a new database and I have a doubt in which surely you can help me. I'm storing in this database historical data of some measurements and the system in constantly growing, new measurements are added every day. So, I have to set some extra columns in advance, so space is avai...more >>

Hey guys - I need your help. We are using SQL Server 2000- do you think, we should upgrade to some later release of Microsoft SQL Servier or Migrate to Oracle, IBM or Sybase. I am also wondering, what do you think of Open Source MySQL and PostgreSQL. Have anyone of you using these databases. ...more >>

Hi, When I debug our sp by using T-SQL Debugger, I got following error. Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'. and when I grant ...more >>

I'm new to SQL Server, so if I'm doing anything stupid don't be mean :) I have a procedure that I use to return data based on optional parameters. It works fine, except when the underlying data contains a null on one if the fields being searched. My system uses a default wildcard for all ...more >>

How can I change a character in a string of text. I have a bunch number that have a lower case l in them and I need to make them an uppercase L. Example; 99l5555 needs to be 99L5555. ...more >>

hi, Does MS2005 JDBC Driver 1.1 support integrated security on Solaris and if so how? Thanks, MarcM ...more >>

Hello, I'm trying to create a simple back up in the SQL Maintenance Plan that will make a single back up copy of all database every night at 10 pm. I'd like the previous nights file to be overwritten, so there will be only a single back up file for each database (tape back up runs every night...more >>

Using SQL Server 2000 I need to extract all the grants made to a user created role so that I can recreate the role in another version of a database and there are more grants than I want to do by hand. Does anyone have SQL or T-SQL to perform this task that they would be willing to share? I t...more >>

HI, Can anyone tell me abt the following error while i was running my ASP.net project and codes were in vb.net? Line 1: Incorrect syntax near 'Number'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more informati...more >>

I am looking to populate a Schedule table with information from two other tables. I am able to populate it row by row, but I have created tables that should provide all necessary information for me to be able to automatically populate a "generic" schedule for a few weeks or more at a time. ...more >>

Hi! I have a stored procedure that takes 22 minutes to run in one environment, that only takes 1 sec or so to run in another environment. Here is the exact situation: Database 1 on Server 1 vs. Database 2 on Server 2 - the data is exactly the same, and the tables and index structures are ex...more >>

Hello everyone, I face currently a problem where I could need some input for searching the source of the Problem System: SQL Server 9.0 I fill from Database A with triggers Database B, everything works fine. On Database B there is a Stored Procedures that checks the records and add addi...more >>

I am attempting to compile a list of questions that will enable me assess 'at risk' stored procedures that need to be remediated in order to minimize unplanned downtime and enhance database performance. Is there a subset of criteria (parameters) from the MS SQL Server Best Practices Analyzer tha...more >>

We are running on SQL 2000 on Windows 2003. We have active-passive clustering set up. We have 16 GB of RAM on each box. This past weekend, we failed over. I noticed that the Total Server Memory went from about 15.5 GB to 8 GB. I have been trying to figure out why this has occurred. Any hel...more >>

Hey guys - I need your help. We are using SQL Server 2000- which version do you think we should upgrade to. Also, wondering if you tried any Open Source data base and any thoughts on those. Thanks guys for your help - Mark Smith ...more >>

Hello, I've a problem where some data gets updated but I don't know which process (SP) is responsible for it (it's an old installation which I've taken over). Is it somehow possible to know which process/user/SP performs an update on a special table/column? I was thinking about to impleme...more >>

guys, I have a project need to move more than 100,000 records from one database table to another database table every week. Currently, users input date range from web UI, my store procedure will take those date ranges to INSERT records to a table in another database, then delete the records, ...more >>

1. In this topic http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/b4a07b516f4a2fcd/cb21516252b65e7c?lnk=gst&q=SET+TRANSACTION+ISOLATION+LEVEL+READ+UNCOMMITTED&rnum=10#cb21516252b65e7c, someone wrote: "I've implemented SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED...more >>

Hi, I have a table that I insert a member's country into every time someone signs up. What I'd like to do is pull information from the DB such that I can see each country and the number of users from each. For example: Argentina 10 Brazil 5 Canada 3 I'm having trouble writi...more >>

SQL Server 2000 SP4. Running the script below prints 'Unexpected': ----------------------------- DECLARE @String AS varchar(1) SELECT @String = 'z' IF @String LIKE '[' + CHAR(32) + '-' + CHAR(255) + ']' PRINT 'Expected' ELSE PRINT 'Unexpected' ----------------------------- I...more >>

Hi, I'm trying to outer join to a maximum date value using a subquery in order to return company information and the last activity date associated. The basic working "sub" query is: SELECT actcomp.company_id, MAX(act.due_date) FROM oncd_activity_company AS actcomp, oncd_activity AS act WHER...more >>

I have been programming access databases for 8 years. Well today I find out that I need to know SQL. HUH LOL well I don't have a clue as to how people even enter data into a sql database or how to manipulate or retrieve data. Can someone please recommend a book to get me started? than...more >>

I have a query..if you look at the bottom of the where clause you'll see an "NOT IN" statement that is really hanging up the query..i'm trying to replace with a "NOT EXISTS" but it isnt appearing to work...I need to get a result set where the email address of the outter most query is not in that...more >>

Our database is running in full recovery mode and we backup the log file every hour and the database file every night. I notice the timestamp of database file *.mdf remains unchanged a few days. For example one database has its timestamp at Apr 15 while it is Apr 20 already. I am wondering if t...more >>

Is this command, which I know can be executed on a per-table basis, the same as the Rebuild Index Task in the SQL Server Management Studio for maintenance tasks?? The documentation I have mentions the reindex.sql script, is this the script that is executed by the Rebuild Index Task?? Thank ...more >>

Hi all, I am dealing with a very large database, and as soon as a record is submitted I need to run a full-text query against it. I believe it might take a while before the record is fully indexed and therefore would not return a result. How can I check whether the record in question is alr...more >>

Is there a certain way of adding users to access a linked server? I linked to an Oracle server but somehow, I'm unable to add any users, even after trying in EM. It'll allow me to select the local account, enter a remote userid/password, click apply > save, but doesn't seem to hold the info. ...more >>

I am writing a function which will take two parameters. One the field to be returned from a table and second parameter is the ID of the record to be returned. Problem is it's not returning the value of the field specified in the parameter but instead returns the parameter itself. Is there a ...more >>

Hi, I am writing an in house utility to attempt to compare different aspects of databases. I am currently writing the queries to list all of the indexes in the database (including primary key indexes at present - I may move these and compare separately at some point). I would like the foll...more >>

Hello, I am getting the rather odd error below; hope you can help. RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\trial_44testingc' is claimed by 'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(65537). The WITH M...more >>

Hi How can I create a job in sql agent to create a new snapshot every hour? I have, for eg a T-SQL that does it manually. create database Snapshotter_snap_20070418_1821 on ( name = Snapshotter, filename = 'c:\temp\Snapshotter_snap_20070418_1821.ss') as snapshot of Snapshotter Now, wh...more >>

Is it possible to have spacing within a column name? Something like "column name." I can do it from EM but won't let me do it in query analyzer. Can someone tell me the command to do this in query analyzer? Thanks! ...more >>

Kinda new to SQL, using SQL Server 2005. I have some foreign keys in a couple of tables. I need to drop these tables, but can't since I'll get the error: Msg 3726, Level 16, State 1, Line 1 Could not drop object 'Client' because it is referenced by a FOREIGN KEY constraint. I'm not s...more >>

Okay, here is a real mellon scratcher. I've got a server I've got semi-automated backups on. A typical backup looks like: BACKUP DATABASE Master TO DISK = 'c:\backups\Master20070418.bak' WITH FORMAT Then I'll do a log backup if applicable (Not for Master). I then get some error about th...more >>

osql command is not executing on Remote server(by using link server) osql -S ucmain -U sa -P abc -l 2 -Q ucmain is remote abc password After executing the above command I got time out expire messsage What is the reason ? It is noted that 35 server is connected with the gateway where the os...more >>