Is there a functoin or property that you can look at to tell if a trigger has been disabled? Something in the schema? Like: Print IsTriggerDisabled(tblCustomers.MyTrigger) Keith ...more >>

What is the query that list out all the index names used in the tables? Madhivanan ...more >>

I have a complex qurey as given below.Anybody can suggest a procedure which is equvalent to Oracle's START WITH .... CONNECT BY PRIOR clause. Qurey:"SELECT c_production FROM Production_ASSIGNMENT WHERE I_COMPANY = 1 START WITH c_Production_ASSIGNMENT = 2 ...more >>

I would like to create a dynamic output file with the following code: Declare @cmd varchar(1000) Declare @filepath varchar(1000) Set @filepath = '\\server\path\filename+date.csv >>>> I would like the mm/dd/yy appended to the filename then .csv extension Set @cmd = 'Osql -E -S My...more >>

I'm sure your all aware of the bug in SQL 2000 where if you take a backup and then do a restore on a different database server, the users accounts are not added to the server's own security (login) section. The user accounts are though added properly to the databases "users" list however. ...more >>

I want to use the code below to update one table from another. Can anyone see any problems with this code? Thanks. UPDATE tblBillingDetail SET AppealBalance = AppealBalance - P.PaidAmount FROM dbo.tblBillingDetailPaid P INNER JOIN dbo.tblBillingDetail D ON P.DetailID = D.DetailID WHERE (P...more >>

Hi, Usually how people do the data conversion? For example, I have a well defined database, the new client use another similar relations database and have few years data in it, he want to migrate to my system, so I need to convert his data into my database, customer, appointment, transactions...more >>

Hi, I am trying to find out who are the users that has rights to what tables in a database. Is there a way to accomplish this within query analyzer? Thanks, lha...more >>

anyone have any suggestions on how to join these two queries? 1. they both give results, but i'm trying to avoid creating temp tables. select h.stkhstdate, h.stkhstRSBS, count(h.stkhstRSBS) as Sell from stkhst h join unvmem u on u.unvmemcsiid = h.stkhstcsisym where unvmemUnvID = 7001 and h.s...more >>

I have the following skeleton DDL and need to do the following: *Ability to override a users privileges of the 'Role' that he belongs to. For e.g. if a user belongs to Role 1 that has Privileges 1, 2, and 3 then I want the ability to override this users privileges such that he can be assigned...more >>

First, I have been programming in Access JetSQL for a long time, but am new to T-SQL. I have the following view set up: SELECT Material, [Plnd order] AS PlannedOrder, Ord#quantity AS OrderQty, OrderStart, Ord#finish AS OrderFinish FROM OPENQUERY(ZUPG32000564, 'SELECT * FROM [S...more >>

how do I transform 'Percentage' in the following table so that 'Percentage' values are returned in one row for all the given years. Column 'ID' Column 'Year' Column 'Percentage' Column Grade 1 2001 25 A+ 2 2002 30 ...more >>

Is it necessary to uninstall MSDE before installing SQL Server 2005 Beta? And if so, do you also have to give the server instance a different name on setup? Cheers, Mike *** Sent via Developersdex http://www.developersdex.com ***...more >>

This one has stumped me! I recently implemented a process to monitor database usage and growth on our production servers. I use on server as the "master" that collects data from all the other servers into one database. The problem I'm having is that only every other day the process com...more >>

SQL 2000: Ack! I thought my database had ANSI NULLS set to On. I find that it doesn't. I always use IS NULL to check for the existence of nulls, rather than using = NULL, so this setting might not matter much. I see there is a database-wide setting for ANSI NULLS. Also, there appears...more >>

I think this is any easy one, and hopefully full DDL is not required as there is A LOT. Goal: Create a report(using RS) that shows client name, id, total amt loaned, total amt paid. Data will be displayed in a grid and the balance must be displayed in the pertinent age category..so if Tom...more >>

I'm looking for MS Project templates or examples relating to all and different SQL Server activities; e.g. installation, upgrade, database design, Application Development, etc. Are there such samples available to download somewhere -- anywhere?? Thanks. ...more >>

Just started working at a place which has a SP which runs a loop and gets the id. Then this id is used as follows: SELECT name, 0 from tbl WHERE name like '%'+id+'%' AND xtype = 'u' Basically to get the names of the tables that have the "id" as part of the name. How can I a...more >>

I'm new to SQL server and I need some help on something. In my current table i have a column formatted like MM/DD/YYYY hh:MM:ss AM, how can I only get the MM/DD/YYYY> I need to do a query and get the data were this column = 1/1/2000 only. I don't need the time or if its AM or PM thanks ...more >>

I'm trying to set the default value for a parameter in a stored procedure CREATE PROCEDURE x @endDate INT = Convert(VarChar(8), GETDATE(), 112) as BEGIN ........ END return 1 this gives me an error. if i set the default to say 32445 it's ok. Is there a way around this so that i can set the...more >>

This is the most important question of your life. The question is: Are you saved? It is not a question of how good you are, nor if you are a church member, but are you saved? Are you sure you will go to Heaven when you die? The reason some people don't know for sure if they are going...more >>

I need to open the log file of a database to see the commands in it kept to verify ones definitive inserts that they had been made in the database. How I can make this? -- Nuno Pereira...more >>

I have a stored proc that is removing a leading zero from a nvarchar field. For example, if I pass it '0146' for the @userid it updates the field to '146'. Below is the code. Can anyone spot why this is happening? Thanks. CREATE PROCEDURE [ef_episys_contact] (@EntityID [int], @UserID...more >>

I have a stored procedure (PROC1) that calls another stored procedure (PROC2) multiple times. Both procedures have an output parameter and I am wondering if I can take the multiple output parameters from PROC2 and combine them into the parameter that is output for PROC1. Example... Say th...more >>

Hello, Let's say I am planning retrieve thousands of records and load them in my datagrid in a windows form. This is very slow and I want to retrieve the result in small chunks. For example I want to retrieve first 100 rows and load it and then when user scrolls down on the grid I retrieve ...more >>

I need to convert the date format with an output of yyyymmdd' I have tried the following code but it doesn't produce the desired output CONVERT(VARCHAR(8),supp_creation_date , 112 ) , Any suggestions? Thanks in advance...more >>

Hi, I want to add to my 50 single step jobs a second step with command "execute JOB_STEP_FAIL <jobname>" where <jobname> is job name from sysjobs table. I want to use sp_add_jobstep . I do not want to make this job by hand. Thanks !!!!!!!!!!!!!!!!!!!!!!!!!!...more >>

We're migrating a production database (mission critical) from RMS to SQL Server. In the original database the primary key is negative. Using negative numbers builds a more balanced tree... Are there any drawbacks for doing this in SQL Server?...more >>

We're in the process of migrating a RMS database to SQL Server. Our migration task has so far mapped some datatypes as follows: currency related data: double precision -> float (8) number (in range: -25000 to 25000, one decimal point) -> real None of these columns will be used for indexing,...more >>

Is there a more correct, or nicer, or cleaner way to create Stored Procedures: The following code works fine, just wondering if there is a more acceptable way to do this: The IF EXISTS line, seems somewhat messy to me, maybe this is as clean as it gets? Thanks Russell Mangel Las Vegas...more >>

Sorry, I know that I'm very troublesome I will like to create a view that stores the difference between 2 Integer columns from 2 different table. Is there a function to perform this? And I wrote a SQL statement as below, Select CustID, ReqNo, 'Total'=Sum(AcceptedQty) From Delivery Group By ...more >>

In general, is there any problem with using a trigger to keep the value of a column unique in a table as opposed to setting the column as a unique index? Keith ...more >>

I delete 40 SO so careless ly, Any method to recover ??? ...more >>

Learning some SQL and ADO.Net. Have a mail style learning app with a table where each row has at least a subject string and body string. On the client, I want to select all active rows and return to client (e.g. pop3 like). I then want to delete only those rows (or flag as deleted) only t...more >>

If i use FORMATMESSAGE it allways returns NULL. Any suggestions?? -- Message posted via http://www.sqlmonster.com...more >>

Hi, Does anyone know of a method using File System Objects to monitor for filenames that are date & time stamped. The filename will always follow the form "BACS Day File [ddmmyyhhmm]" There should only ever be ONE file present in the directory - however because it is timestamped I am findin...more >>

hi group! I am searching for a possibility to declare my cursor dynamicly in a way like that ALTER PROCEDURE dbo.proc @param varchar(30) AS declare cursor projekt_cursor CURSOR FOR 'select * from tbl_projekt where projekt_nr in (' + @param + ')' @param is a varchar like that...more >>

Hi, how would I go about sending a Update Script (with multiples Batches) via ADO to an SQL 2000 Server. As much as I know the Command.CommandText can only take a single query. Thanks a lot Patrick ...more >>

Hi, below you find an extract of an update script I would like to use. It should check if the Database Version is correct for the update and if not it should stop (by raising an error?). The whole script should be within a transaction. If an update failes it should rollback everything. T...more >>

Hello group, I have table with 3 columns ( id(int) , ColName (varchar) , ColProperty (int)). In column ColProperty I have binary represention of property (code in binary system) for example: if value is 43 that [Weight ratio * state of property] (1*1)+(2*1)+(4*0)+(8*1)+(16*0)+(32*1)+(64*0)...more >>

Hi All Wonder if you could help me with the problem I've caused myself!! I have 2 problems both exactly the same and I can't fathom how to get round them. PROBLEM 1 (I am using an Access 2000 DB): I basically poke the codes of team names into a line-by-line history table so I'm not s...more >>

Select a.id_customers, firstname, lastname from customers How would i use ROBUST PLAN with this query? please advise. rafael ...more >>

Hi Can any one tell me how to create a group and user in sql server 2000 programatically in C#? Is there any system stored procedure to do this one? I want to create a user and need to place it under a group. and each group has its own set of roles like to access some tables and to deny s...more >>

Hi, I have records with tab Delimited in it. 123 123 123 (one Coloumn Data) 333 555 555 (one Coloumn Data) Is that possible that using stored procedure, I can Split every row on the basis of Tabs and hold them in seperate varibles? Thanks In advance Tony ...more >>

Which the cost to have the sql server, for the programmer and which the cost for my customer? Is it very difficult of installing the sql server in the customer? is a technician necessary, or does he have as a cd of installation of the system or did he see code to leave the program rotating witho...more >>