Does anyone happen to know if the folks at Red-Gate used a public SDK to create the log explorer, or did they fork over money to microsoft to get a ISV licensed SDK? I'm looking into making a similar product that would be open source, and I'm trying to figure out what they used to translate en...more >>

Is there a free web based app available to manage a MS SQL. I am not looking to manage the server itself, just the DB. Basically something similar to phpMyAdmin (http://www.phpmyadmin.net). Thanks. Brian ...more >>

Hi there gurus, can you please add your 2 cents on this design? We're having trouble relating these tables in a diagram because of the keys. Is it necesary to have the references setup? I would assume yes so the forign keys can be setup. If you look at this link, you'll see our diagram. In ...more >>

Hi guys, This might be simplest thing, but I am newbie to databases. I need to find out only rows modified within certain time period from a database. As I undertand a way out could be adding an where clause for the time period might be an option, I might be wrong here again. But, wanted ...more >>

Hi, I have unoin of 2 queries which gives outpur as: Service_Name P3 P4 ------------------------------------- S1 1 NULL S2 4 NULL S3 3 NULL S1 NULL 5 S2 NULL 2 S3 ...more >>

How do i find out how much fill facot has been spcified in given table?. ...more >>

Is there a way to automatically import incoming emails into a SQL Server Database? I know it is inefficient, but we have to run a number of rules on the email after it is received. Store it in a database and be able to connect other things, meetings, contacts, etc. Moving it back and forth in...more >>

Hi , Any one tell me how calculate the Size of the row?. regards ...more >>

Hello, I need to write a query to find out a set of missing number in a given sequence. Eg : a Column in some table has the following data Col1 1 2 3 4 5 6 8 9 10 Here I need to write a query to find out that number 7 is missing in the...more >>

I have a nasty situation in SQL Server 7.0. I have a table, in which one column contains a string-delimited list of IDs pointing to another table, called "Ratings" (Ratings is small, containing less than ten values, but is subject to change.) For example: [ratingID/descr] 1/Bronze 2/Silver ...more >>

Hello, there, I am trying to find out if a table is used by any of the stored procedures or functions. I can generate all the scripts and look for it. But is there an easy way? THX John ...more >>

Our SQL Server 200 box is getting perflib errors when we get a decent amount of people using an application that I wrote, call queue system, web based. To accomplish a queue type system on a button push I wrote a query like this... BEGIN TRANSACTION; Select top 1...fields here... FROM table...more >>

Hi, My SQL Server 2005 won't start - can anyone provide some help? This seems to be the most significant error: - TDSSNIClient initialization failed with error 0x5, status code 0x51. There was some info here, but the reg key described looks okay: - http://blogs.msdn.com/sql_protocols/ ...more >>

I have this table... CREATE TABLE #Test (ID char(1), Seq int, Ch char(1)) INSERT #Test SELECT 'A',1,'A' INSERT #Test SELECT 'A',2,'B' INSERT #Test SELECT 'A',3,'C' INSERT #Test SELECT 'B',1,'D' INSERT #Test SELECT 'B',2,'E' INSERT #Test SELECT 'B',3,'F' INSERT #Test SELECT 'B',4,'G' ......more >>

I am trying to tie two tables of data together and I'm having some issues. table 1 has about 1700 rows table 2 has about 1000 rows table 3 has about 70 they all have one column in common, provider number. select a.provider, a.[survey-date], a.tag, a.code, a.[scope-severity], a.state, a....more >>

I have a database with 10,000 records and I want to just see record 1000 - 1025 is there an easy way to do this with a query. I have found info for my SQL using limits but it does not work with SQL Server 2000. Please help. Thanks in advance. ...more >>

I installed SQL's SP1 (KB913090) last night on my sql server 2005 enterprise x64 box, but when I check out windows updates on the web, it wants me to download SP1 and install. Next, I ran the SP1 I had downloaded a couple of months ago, and it wants to patch again. I would think it would say its...more >>

Hi, I was just wondering... Is there any built-in function in MS SQL, which will allow me to do rows' "capitalisation"? Lets say that in database.table.name I've got: "FOO BAR LTD.", which I want to change to "Foo Bar Ltd." "Foo bar LTD.", which I want to be "Foo Bar Ltd.". Is there any way...more >>

Hello, I've created a stored procedure that loops through a cursor, with the following example code: DECLARE curPeriod CURSOR LOCAL for SELECT * FROM tblPeriods DECLARE @intYear smallint DECLARE @intPeriod smallint DECLARE @strTekst varchar(50) OPEN curPeriod WHILE @@FETCH_STATUS=0 ...more >>

Hello All, I would like to get last modified timestamp for a table. Is there any way to get that information using any commands? Thanks in Advance, Muthu. ...more >>

Hi, I use SQL Server 2005. In computer "A", I backup a database "AAA" to a file "AAA_Back.bak". When I try to restore on computer "B", error message shows up, it try to find the original backup file path in computer "A". How can I fix this problem? Thanks Kai ...more >>

How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio 2003 and 2005 installed on my laptop. I have my default website configured for ASP.NET 2.0. I h...more >>

Hello! I use a procedure to insert a new row into a table with an identity column. The procedure has an output parameter which gives me the inserted identity value. This worked well for a long time. Now the identity value is over 700.000 and I get errors whiles retrieving the inserted identit...more >>

Is there any disadvantages of using Decimal type as a primary key? If so, are there other data types that can hold large numbers (more than an int can hold: 13 digits or so) and perform better as a Key field? Thanks. ...more >>

It's not so much a problem, as I don't know how to get around this issue. We have applications that rely on the return value of a stored procedure. This stored procedure inserts a record into a table that has a trigger. The trigger calls a couple of stored procedures itself. Due to the trigger...more >>

I am trying to tally up information from two tables, but I am running in to trouble and I can't seem to figure this out. I have a CreditsTable and a DebitsTable and I am trying to create a querry that sums up the info from each per UserID and returns TotalCredits, TotalDebits, and a Ballance. ...more >>

All, is there a way of getting all table names that contain a column name? I'm looking at a DB that has 125+ tables and I'm interested in finding all table names that contain the column order_date. How can I do it? TIA, Sashi ...more >>

Hello To all I have uninstalled SQL SEVER 2005 EXSPERS to install Visaul basic .Net After i have installed it i can not reinstall SQL Server i having the messege:" An instance with thesame name is already installed on this computer To proceed with SQL server Setup rovide a unique instance name"...more >>

Hello, I am learning SQLServer 2005 Express Edition. I wanted to learn Report Designer which - according to my tutorial book - is part of Business Intelligence Development Studio. I can't find it in Internet. Could you help me plase? Thank you very much! /RAM/ ...more >>

Hello, I am learning SQL Server 2005. I would like to write a procedure making database backup using SMO. According to my book I should write such code: using Microsoft.SqlServer.Management.SMO; public static void MakeBackup() { Server server = new Server("localhost"); Backup backup = ne...more >>

Hi all, We have an app that uses SQL 2000. I am trying to track when a code field (selcode) is changed on an order which then causes a status field (status) to change. I tried a trigger but the app may use 2 different update statements to change these fields depending on what the user do...more >>

Hi, I am learning SQL Server 2005. I need to call .NET assembly procedure from T-SQL. Here's part of my assembly: using System; using System.Data.Sql; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; namespace DemoSQLServer { public sealed c...more >>

Hi all, Using SQL Server 2000, SP4. I have a table of street names (Rua) whose ids (cod_rua) are foreign keys into a consumer table (Consumidor). It turns out that the "Rua" table has many unused records which I'd like to wipe out. For instance, there are some 2800 unused records in the "Ru...more >>

I am running a SQL maintenance job on a 40 GB database which performs optimizations by re-orginizing data and indexes pages. After the job is finished, a separate job peforming a SQL transaction log backup is run on the same database, which produces a 30 GB transaction log backup file. Is ther...more >>

I have a couple new servers - Windows 2003 R2 - with SQL Server 2000 SP4 installed. They are all Active/Active clustered instances (my first ones). I am trying to create database links to other SQL Server instances, but there are 3 that I cannot connect to. The dblink works if I connect ...more >>

I have a text field in a table that contains number along with chars. Is there a way i can write a query to show all the fields that contains just Numbers or Char in a field?? TBALE Example COL1 : COL2(nvarchar) --------------------------- 100 345G01 200 1234...more >>

I really dislike the Management Studio in SQL Server 2005. Having tabs is nice but everything else about it really sucks. What don't you like about it? Maybe someone at M$ will read this and actually make some changes --- for the better (sigh, I wish but I won't hold my breath). For all the...more >>

Hi guys I'm having a nasty problem with bulk copying into a table that has unique identifier column. I'm coding on C++, using ODBC driver. I'm coping from a file containing UID description like this: {43B5B3DE-5280-4CBF-B357-D9E57651F0D1} (I also tried a non-bracket version) and in the D...more >>

Hello, I am currently working with a data mart. The business wants a view of the data that shows columns from the main table along with up to 6 codes from a related table (not related by the full PK of the main table though). They don't care about the order of the codes or how they are assign...more >>

Hello, I am using SQL 2005 and Cognos' Data Manager. It is an ETL tool for data warehousing. I have a problem with time it takes to load new changes, and I am seeking advice on a better way to manage the data. I have a table that tracks student attendance and it contains about 13 million rec...more >>

Hi, I am trying to set up a DTS Package to transfer data from a remote MySQL server to a local MS SQL database. The source tables will remain static as will the destination however I only want to copy down data that does not already exist in the local database. I have two different methods...more >>

Hello! I have a table that looks like this: Col1; Col2; Col3; Col4; Col5 38; 75; 233; 916; 2770 38; 75; 233; 916; 2771 38; 75; 233; 916; 2772 38; 75; 233; 923; 2654 38; 75; 233; 923; 2655 38; 75; 245; 913; 2454 38; 75; 245; 913; 2456 .... And I need a que...more >>

Hi people, I am wondering how to do this. Let's say that you execute a long running insert or whatever stored procedure from your application. It runs for a while (minute or two) and it runs on the SQL Server. So your application doesn't know it's status. Is it possible to get the statu...more >>

Hello, I am learning SQL Server 2005 Expres Edition. I need to create full text index on Books.Remarks column in my database. I tried: CREATE FULLTEXT CATALOG FTC_Books AS DEFAULT CREATE FULLTEXT INDEX ON Books (Remarks) KEY INDEX IX_Books_Remarks ON FTC_Books Unfortunately I got error: ...more >>

Hello every body. I have a small issue. Problem: I have a table with 4 descriptor columns (type). I need to formulate a query to retrieve a count for each type so I can group by...etc. The view I have works, but doesn't work when I supplement the query with some functions... they just don't...more >>

I am experimenting a simple stock database. Let's say it only contains the end-of-day trading data for Intel. The database has the following columns date OpenPrice HighPrice LowPrice ClosePrice TradingVolume For each trading date, I need to compute simple moving average based on the last ...more >>

Hi all, I defined unsigned_int in my database, which uses unsigned_int_range rule. The unsigned_int_range rule is defined as follows: @unsigned_int >=0 and @unsigned_int <=4294967295 (4294967295 = 0xFFFFFFFF) The storage size is 4 bytes. One of the tables in the database contai...more >>

Dear Friends, I have table contain 2000 out of those some are duplicate when i select duplicate records by using Enterprise Manager and make modification to one of those duplicate records the following message flashes/display. key columen information is insufficient or incorr...more >>