I can create, drop reint, & sync just fine (I built a small widget like vb.net 2005 form) However I can't figure out how to get status events out of the running agent... I need to drive a progress bar & update a textbox with messages while it's syncing there's sample code in C#, (salesorder...more >>

Hi All, Does anyone know of a way of removing everything between, and including two given characters in string using TSQL. e.g. If my result set returns 'Sample Text [12345]' where 12345 is unknown text, how can I make this 'Sample Text' I know this is something perhaps best done at app...more >>

I want to be able to pass a date to a function and add 4 days to it. The quirk is that it needs to be 4 working days ie. Mon - Fri excl holidays. so I have a table of Holidays with 2 records in 2/1/2006 (2nd Jan) and 3/1/2005 (3rd Jan) The 31/12/05 and 1/1/06 are a Sat and Sun I have a ...more >>

I'm having a problem with my database server whereby performance decreases after 12-18 hours in production and is only restored after a reboot. [almost like hitting a wall] Of course, the memory usage increases throughout the day and eventually settles with a few hundred MB of free memory. ...more >>

Hi, Can anyone please tell me what would happen if someone is in the process of running a select / an update statment while I drop the user permission for datareader and datawriter or I add the user for denydatareader or denydatawriter? Can the process still be finished or the select /...more >>

What's a SQL statement for renaming an existing index. I know how to add an index at the time that the table is created, but how do you rename an existing index. -- E. coli Happens. Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200512/...more >>

I know someone will refer me to online books, but I did a search on the microsoft site and can't get to it. I know the general format for adding an index is: Alter Table tablename ADD INDEX indexname, type, FieldName The thing is, I'm not sure what to put in for type? Do I use quotes? Ca...more >>

I'm currently trying to use SET ROWCOUNT for the purpose of limiting my number of rows returned but the select statement is buried deep in a nested SQL query for example: -- Gets one row of the ProdouctAcquisition table -- based on the ActualFileName CREATE PROCEDURE Get_rsDeleteProducts_A (...more >>

Hi folks, MSDN states the CreateAccessor method of class CManualAccessor as follows: HRESULT CreateAccessor( int nBindEntries, void* pBuffer, DBLENGTH nBufferSize ) Does anybody know under which circumstances "pBuffer" is used (i. e. filled)? Whatever I try, this buffer stay...more >>

Hello, Here's one for the SQL 2005 CLR programmers! I'd like to send a SQL 2005 CLR stored procedure a string of SQL and have it execute and send back the result set. I've got it to work if I hard code the SQLDataRecord values as per the below code, but I'd like it to dynamically build th...more >>

Hi, There are some jobs running in the morning everyday. What I would like to do is to log everybody out when the jobs are running to prevent all the Locking/Blocking from other users... what would be the best way of doing it???? I am thinking if I can use the sp_droprolemember to not l...more >>

Hi all, I have noticed when i export data, that any resulting tables created don't seem to include the IDENTITY attribute on the necessary columns. These attributes are defined in the source tables, but don't carry over to tables resulting from an export. Can someone fill me in on what is...more >>

When designing a system we have used a single catalog for maintaining clients data and differentiated by using a unique key. Is it a better practice to map each user to a separate catalog or use a single one in terms of performance on the server and clients? While I would think this would mak...more >>

Hi, I have a select statement which brings back several fields and several columns. Within one of these columns is an email address. I want to be able to cycle through each record in the select statement and email the details attached to their email address. My SP is below:- SELECT ...more >>

I have q query like this SELECT DISTINCT ([cinsiyet]) FROM URUNLER WHERE cinsiyet NOT IN ('Bileklik' , 'Yuzuk' ,'Set' ,'Kupe' ,'Bilezik' , 'Kolye') ORDER BY urunid it returns ORDER BY items must appear in the select list if SELECT DISTINCT is specified. i tried SELECT DISTINC...more >>

I have an application using MSDE 2000 which uses the sp_addlogin statement to programmatically create a guest login with read-only access to a set of low-priority databases. Had I originally implemented this code, I would have given the guest account a password, however low its permissions, bu...more >>

Hi, I am trying to write a script which basically checks that a date is within 7 days of todays date. It then emails these details off to the officer involved. My stored procedure does the first bit i.e. Get's list of details within 7 days of todays date. I need to then cycle through the...more >>

Hi, from sql, what is the best way to check if a file exists in a share - given the file's partial name (for example the first 20 characters) ? I thought about saving the result set of "xp_cmdShell dir shareName ... " into a temp table and query the temp table for the filename... but are there...more >>

Hi, Could someone please let me know where I could find inofrmation/documentation about fn_replprepadbinary8 function (exists in master db under functions) Thanks!...more >>

If you are asking if you can attach a 2005 file to 2000, the answer is no. They are not backward compatible in this manner. Forward compatibility is another thing, as you can attach 2000 db files to 2005. I have a couple of questions about moving a sql2000 database to sql2005. I was able to ...more >>

Is there a way to insert data from one table to another table without logging the transactions? Thanks in advance, ji ...more >>

Hello. I have a UDF that I created to pick out a value from a string that has several values in the string separated by a delimiter. I pass the string, the delimiter and the number of delimiters to find before picking up the value. The UDF returns a Decimal(5,3) and it works fine but I wan...more >>

Am I able to do something like this? The syntax below is obviously wrong, I'm looking to see if there is a way to accomplish this. DECLARE @DBName varchar(5) SET @DBName = 'pubs' SELECT * FROM @DBName.dbo.authors I have a master application and database containing data for several companie...more >>

I can use DTS and BCP, but I am trying to export a table into a text file through Query Analyzer (I need to show documentation in QA). DTS uses EM and does not leave a "paper trail" I am looking for the reverse of BULK INSERT ...more >>

Does anyone know if this is possible to do in SQL? declare @product varchar (50) declare @product1 varchar (50) declare @product2 varchar (50) declare @product3 varchar (50) declare @product4 varchar (50) declare @product5 varchar (50) declare @product6 varchar (50) declare @product7 varch...more >>

I am supporting a purchased product that uses a text field for comments. Is there a way to query the column and format the contents w/o the rtf formatting?...more >>

I have a need to read email being sent to an account. This is fairly easy using SQL Mail, but I want to use the Database Mail provided with SQL 2k5 (as SQL Mail is being phased out). Is there a way to read mail as well as send, or is it a send only process? Thanks!...more >>

I see tons of "18453 Login succeeded for user domain\username. Connection: Trusted". If this is a problem then it seems big because I see this line in event viewer for every second for many hours. What is going on pls help? ...more >>

Hi I was wondering if it possible to retrieve the max date of audit fields in all tables, within a database. i have looked at the sysobjects and sysindexes, but haven't had much luck, since I am able to get the Tablename and rowcount, but the Audit field data, I cannot seem to find. I.e ...more >>

I am relatively new to sql server 2000. I have a transaction log that is 98 gigs in size that has never been backed up. This transaction log file is too big and needs to be decreased in size. Can you tell me how I would make my first full backup of this transaction log file? To shrin...more >>

Hello Everybody, I do have a question abt performance of one of my report store procedure. We have a reporing application using Microsoft Reporting Services a Report Front End and SQL SERVER 2000 as a DB. I have written one report store proc. That report store proc is taking arround 30 sec to ...more >>

I have a table with a varchar(3) column. CREATE TABLE #Test1 (column1 int identity , column2 varchar(3)) I run the following insert statements: INSERT #Test1 VALUES(' ') -- one whitespace INSERT #Test1 VALUES(' ') -- three white spaces Then I run this query: SELECT * F...more >>

I am working on a managed code trigger using visual studio 2005 and SQL 2005. When I try to deploy it I get the following error: Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the ...more >>

I have a problem hopefully someone can help with.... I have a stored procedure which .... Writes to table A (table A has an identity column) Gets the identity column using @@IDENTITY (OR @@SCOPE_IDENTITY) Updates a table; setting column X to the IDENTITY value just retrieved...more >>

Hi, I have two tables TABLEA on serverA and TABLEB on serverB. TABLEA ID QTY 1 4 2 3 3 1 TABLEB ID QTY 1 1 2 4 They are both the same in terms of structure. I need to update TABLEB with the contents of TABLEA based on the following 1. If the record exists in both...more >>

Hi all, In my accounting application if one user tries to execute a long report that my take several minutes, the other users who are entering invoices almost hang, and the process of enter products into the invoices or the saving the invoices slow down significantly. I'm using VC++ 2003...more >>

I have the following table, CREATE TABLE [dbo].[XXX_TBL] ( [PERSON_ID] [nchar] (10) NOT NULL, [BEGIN_DT] [datetime] NOT NULL, [END_DT] [datetime] , [TYPE1_ID] [nchar] (10) , [TYPE2_ID] [nchar] (10) ) that charts two attributes (TYPE1_ID, TYPE2_ID) assigned to a person, over time. ...more >>

I have 3 reports, and all 3 of them have an option that returns the same information. So, I created a stored procedure to pull that info. Now, I want to call that SP from another SP. Both will return the same fields for the report. I'm thinking what I need is probably very simple, but don't ...more >>

Has anyone out there deciphered the "status" field bit-mapping of the sysobjects table? Specifically I want to identify all objects created for the purpose of replication (eg. conflict tables, replication triggers, replication procedures etc...). Thanks. ...more >>

Does anyone know how to determine if a Temporary Table was dropped already or not? If the Table still exists?...more >>

Does anyone have any thoughts on how to generate a username/pw for an application that uses MSDE? I am working on an application that uses MSDE as a backend for some very simple database operations. Users of the application shouldn't need to be DBAs in order to use it. I am trying to come u...more >>

Hi All, I know there can be lot better ways to do the same thing (Finding all the childs of a given parent) . Please Provide some insight to improve my understanding of the topic .Trees and Hierarchies. Create Table ParentChild ( Pid varchar(20), Child varchar(20) ) Insert in...more >>

if I have 5 columns that I want to check for distinct values in all of them (not just one columns distinct values - I want to eliminate duplicates from the entire returned result set) will Select DISTINCT col1,col2,col3,col4,col5 from mytable order by myfieldname do the trick? -- Do y...more >>

Hi, As far as my understanding goes, normally PK would be set on fields whose datatype is INT. But in one of the project I saw 99% of the tables they have used Varchar datatype for PK fields. This internally means that it would string comparisons. I was arguing that SQL server isn't goo...more >>

i have a snippit of a query DECLARE @INPUTRPT int DECLARE @ADDACSRPT int SELECT a.companyname, CASE WHEN EXISTS (Select @INPUTRPT = Count(Licence) from INPUT_HEADERS as b WHERE (b.DatePostedToBureau IS NULL AND b.licence = a.licence)) ...more >>

Can someone give me an idea of UK contracting rates for T-SQL programmers? eg migration work, non-DBA. Bit vague I know, but I'm just after an idea. Thanks...more >>

What data type do you recomend to use in a table to store positive an negative numbers with 2 digits precision. It is important to be compatible with different brands of sql-servers. Size up to +- 1 billion. In our C app this value will be assigned to and from the double data type....more >>

hi friends, i want some advanced interview questions that is questions, giving some situation. and also some intresting questions. thanks vanitha...more >>

Hi prob a simple question. Need to update a row in a table. I pass into SP the row ID and up to 10 parms. Any number of the parms may be populated. if not they are NULL. What is a good way of updating the particualr row with only the populated parms and ignore the nulls. Thank you....more >>

hi all, we have been facing severe locking, blocking and deadlock issues on our database and it is really bogging down the system...since we developers don't have the luxury of any DBAs, we've been asked to look into the issues. We have lot of DTS packages which are throwing alerts whenev...more >>

HI, Running debugger on the server works like a charm, however, when my developers try to doc the same thing from ther desktop (with everything setup correctly), thety get the following error ------------------------------------- Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, L...more >>

Dear fellows, I am generating monthly excerpts and I was wondering how would I do in order to do things faster. I would need to improve the following query so that it would be more automatically: General basis: select count(*) , sum(Imp) from dbo.TRU_Rec where FechaCarga >= '2005-0...more >>

Hi! I have two tables (Master and Slave). So I want to write a query (using SQL Query Analyser) which will display all the records in Master which are not in Slave. Can anyone help? Cheers!!! ...more >>