Can any one tell me, how to display only user defined tables from a database. for eg:) if you give, Select * from sysobject from table_type='U' will display all the tables, which includes system table too. Now i need to display only user created tables only, wats the query for it. Please h...more >>

Hi all, I'm trying to install db mirroring on my laptop with 2 sql server standard and an express as witness, but I couldn't because I receive always the same message: "Neither the partner nor witness server instance for database TestDB is available". I think the problem is with por...more >>

olá I am STILL trying to splits funds depending on their availability in a pool of funds based on a priority list with 1 being highest. In the example I need to split 1000 'ABC' and I achive this by looking at the priority list, going to the pool tbl and allocating whats available based on a...more >>

Is it possible for an UPDATE query to just do a search and replace on a string value instead of replacing the entire string? For example, if a record's string was "N12:0" could the update query just replace the N12 part with something else? ...more >>

Hello - I would like some opinions on whether an application using VB6 and Sql Server 2005 should utilize creation of local (client) recordsets; the theory being that opening and closing a connection quickly and then just moving backwards and forwards in the recordset on the client machine ...more >>

I have a table with the following data in a varchar field (the "10 01-2007" below) and a number (units). 10 01-2007 150 11 01-2007 300 12 01-2007 575 14 01-2007 25 21 01-2007 50000 22 01-2007 25000 31 01-2007 8700 51 01-2007 330 I need to combine the ones with 10, 11 & 12 into one lin...more >>

not sure how this happened but it happened on SQL Server 2000 before we upgraded to 2005 with SP2, but now 3 of our stored procedures have a lock on their icon and are marked as encrypted... how can I recover these? I need to edit them and cant because of that! Thanks! ...more >>

I have two tables, and a query that is used many times. My attempts at creating a function that returns the result of the query isn't working. How can I implment a function "fProtocol()" that will operate on the two tables below with the query I've shown? - Jamie CREATE TABLE Protocol ...more >>

Apparently it is not possible to call UDFs from constraints. Or is there a clever workaround ... ? ...more >>

I am using the sys.dm_exec_query_stats view to get a handle on which queries on our server are taking the longest to execute. One of the columns I am using to determine query efficiency is last_logical_reads. As I understand it, this is the number of logical reads the particular query performe...more >>

when I worked on query using transaction such as rollback, save, and,commit for local database then it works just fine. however I tried to do same thing for licked server it returened a error message like below. Cannot promote the transaction to a distributed transaction because there ...more >>

Hello, I have the following table (Ter is territory, R is Rate): Ter1 R1 Ter2 R2 Z 2 K 3 K 3 Z 4 Z 3 K 2 I am looking for the Order By clause that will give me for territory Z: Ter1 R1 Ter2 R2 K 3 ...more >>

I have a sproc that will return several tables, and it looks something like this: SELECT * FROM TABLEA WHERE somelongasswhereclause SELECT * FROM TABLEB WHERE TableBID IN (SELECT foreignKeyToTableB FROM TABLEA WHERE somelongasswhereclause) SELECT * FROM TABLEC WHERE TableBID IN (SELECT ...more >>

I am working on an SP to insert data from an ASP page. I would like it to check for a record with the submitted primary key, if it is not present, then insert, if it is present then return an error message. The following SP does what I want it to, but it does not return an error message. ...more >>

I have a stored procedure that executes sp_rename. The default message "Caution: Changing any part of an object name could break scripts and stored procedures." Two questions: Will this message hinder applications? Is there any way to disable the messages? (I have NoCount on) Sample p...more >>

Is there anyway to run a query and then compare the results with a row in a different table? If this is possible please show me what it might look like structure wise. Thank you....more >>

Can SQL operators be called form "xp_sendmail" stored proc? xp_sendmail @recipients = 'DBA' Thanks for your help. *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have used xp_getfiledetails on SQL2000 for several years. Now that we are upgrading to SQL2005, I find out that xp_getfiledetails is no longer supported. Has anybody found a workaround for this? If so, will you please share. Thanks in advance....more >>

Hi All I have two tables that are supposed to have the same records and i would like to get those records in Tab2 that are not in Tab1. The records are uniquely identified by a combination of column Id1 and Id2 in both the tables. Below is what i have tried and i am not getting the record...more >>

In MSAccess, I can execute the following query: SELECT SUM([MyField]) AS SumMyField FROM [MyTable] GROUP BY [MyOtherField]=13 However, MSSQL conks out at the '=' operator in the "group by" clause. Is there a way to write such a query for MSSQL that will work the same way ...more >>

Hi, Is there a way to get the group count and the total count in one select? Something like this (which doesn't work): select count(products) as totalProduct, sum(count(*)), products from tbl_products group by products So I would have productA 10 100 productB 50 100 productC 40 100...more >>

Hi all, Using SQL 2000 SP4 I have a bak file where when I back up I have RETAINDAYS = 10. Well I'm changing that to 3 days. So how do I get rid of old sets that I don't need in the bak file? And how do I always restore in the scrip below the most current backup set? File = 1 doesn't wo...more >>

How can I get a query that i can run against a SQL Server to get a list of dbs and its size such as Name Total DB Size Allocated DB Usage Total Log Size Allocated Log Usage DB1 120GB 100GB 20GB 1GB DB2 1GB ...more >>

Hi, For a column of type nchar of length 2, is it possible to give a value of "04", or "01" ? In SQL server Express 2005 if I type the value "04", the value saved is always "4" or "1". It loses the zero left padding. -- DocW...more >>

I've got a four-way, 4G RAM 2000 SP4 server that is experiencing timeout issues and so far I haven't been able to find the root of the problem. We're looking at memory, disk i/o, etc. but without any luck yet. One thing that is unusual about this server is that it has a lot of databases: 26...more >>

I'd like to get the date given the month, day, and year (3 integers). ...more >>

I have a relationship between two tables, one is purchase order items and the other is invoice numbers. The items don't have to have an invoice number, at least when they are first ordered, but I do want to validate that they are assigned a valid one from the invoices table when they later acqui...more >>

Here is the query first: USE reclaim GO SELECT o.sku, o.order_desc, o.order_qty, o.open_dte, o.created_ini, o.order_qty - sum(s.rec_rr + s.rec_sprint + s.new_rr + s.new_sprint) As 'owe', sum(s.rec_rr + s.rec_sprint + s.new_rr + s.new_sprint) As 'ship', datediff(d,(o...more >>

hey all, how do i convert the following if statments to a case statement: if a=1 begin end if a=2 begin end if a=3 begin end thanks, rodchar...more >>

Hi all, I'm looking for some help in writing a stored procedure. I'm new to SQL Server so this may seem rather elementary, (well it is to me) so here goes.... I'm trying to select a bunch of records from multiple tables, create totals on a couple columns and then post this aggregated data int...more >>

Hi all, I am joining tables between two databases. Will it affect the performance? Please advise Thanks Soura...more >>

Hello, I have the following query, SELECT DISTINCT GroupInfo.GroupID, GroupInfo.GroupName,GroupInfo.ParentGroupID FROM GroupInfo INNER Join DeviceGroup ON(DeviceGroup.GroupID=Groupinfo.GroupID) INNER Join Deviceinfo ON (Deviceinfo.SerialNumber=DeviceGroup.SerialNumber ) It results...more >>

Hi all, Yesterday we changed the account for the sending of emails and sending out an email is not any more possible. All needed steps are done to set up this new account. Already checked with Outlook if something strange with the account is happening, but haven't found anything [I can s...more >>

People, how can I make barcodes using Reporting Services 2000? Thanks ...more >>

Hi all, I'm getting the following error while trying to update an ntext column in a table: Server: Msg 511, Level 16, State 1, Line 1 Cannot create a row of size 8067 which is greater than the allowable maximum of 8060. The statement has been terminated. Normally, this would mean that...more >>

We use a CSV to import data into a table (tableBCP) where all the fields (except the key) are varchar fields. On this table we will do certain tests before the records are transferred to the final destination table (tableProcess) with the proper data types. One of the fields is a 'Date of B...more >>

I am writing a Stored Procedure which updates about 50 tables within a single Transaction. Four of the tables have triggers which should not be fired, so before updating these tables I include ALTER TABLE...DISABLE TRIGGER... statements (and re-enable the triggers after the update) What w...more >>

Friends, I have following senario ("#temp Table " ) and follwing result required ("Result Required"). Create table #temp ( id int, colA VarChar(4), colB VarChar(4), colC VarChar(4) ) Insert Table #temp(colA, colB, colC, id) Values ('A','','',1) Insert Table #temp(colA, co...more >>

Friends, I have following senario ("#temp Table " ) and follwing result required ("Result Required"). Create table #temp ( id int, colA VarChar(4), colB VarChar(4), colC VarChar(4) ) Insert Table #temp(colA, colB, colC, id) Values ('A','','',1) Insert Table #temp(colA, co...more >>

Hi All, We have a stored procedure, which we term as our archiving procedure. It removes a few million records from our live tables, into these other tables. There are about 9 tables overall. While the stored procedure is calculating what to move, everything is fine. However, once it st...more >>

Hello there I have sql server 2000 Standard SP4 I have some process that update some field in my database. After checking all the procedures i found only one procedure the update this field, but i didn't find the point where this procedure is running and what are the parameters that send....more >>

I want to debug the stored procedure call, as we get to debug the methods... I have all the database credentials. while executing the stored procedure from SQL server Management Studio Window ,for same set of parameters the SP, is executing Fine. While calling it from the code, with same ...more >>