There are a few people at my company that are not familiar with SQL, but it would be benificial if they were able to search for text within a database and report on tables. Is there a freeware tool out there that will connect to a sql db and allow you to search for text? Thanks ...more >>

I have been seeing these intermittently in our event logs... Event Type: Information Event Source: Application Popup Event Category: None Event ID: 26 Date: 1/30/2006 Time: 6:00:30 PM User: N/A Computer: PNTD3BSQLCJ1 D...more >>

hi, Can I create a job like this in sql 2k? exec EVO_SP_CUSTReindex go SP_updatestats go Does the second step will run? Thnaks ...more >>

I thought that it would be interesting to point out some very subtle issues that can occur when using SELECT's inside a transaction that also includes INSERTS/UPDATES or DELETES.). The issues really arise when concurrency occurs (ie many users trying to execute this transaction at the same time ...more >>

Hi, I'm designing our suite of new applications (sigh) and we're going to be storing all the data in SqlServer 2005. I'm hardly a "DBA", I have used access in the past, but never designed a full system. The issue I'm hung up on is how to determine what tables should be in their own separa...more >>

Hi all apologies for the question but we run ePO (anti virus management software) and are moving everything to a new server so I need to back up the ePO database and import it to the new server. Problem I'm having is identifing if I have a Microsoft SQL database or a MSDE database as there...more >>

Hi Everyone, I am a newbie to this discussion forum. If I'm bending/breaking any of the rules, please let me know. I need some major help with a linked server I setup. I have a cache database that we can only access through ODBC (no mumps). I have a SQL database, db01, which is storing data...more >>

Hello, If in a database, "table3" depends on "table2" and "table2" depends on "table1" - how would I write a query (on the system tables) which will take "table3" as a parameter and return me this result as below in a hierarchy? Name Parent Table Name table3 table2 table2 ta...more >>

Hi All, I am trying to add a new table and foreign key relationship to an existing SQL Server 7.0 database. When I try to save in EM, I get a rowsize exceeded error... [Unable to create relationship 'FK_existingTable1_newTable1'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]AL...more >>

Hi, I heard that SQL 2000 Server has been discontinued. Is this true? If yes, any official advisories on the web? Thank you. ...more >>

I have multiple failed backups jobs through the enterprise manager. I have an event id 9 "\device\scis\aic78u21 did not respond within the timeout period" and event id 15 "\device\tape0 is not ready for access yet." The aic78u21 is the scsi controller and only appeared once. Since then, I have...more >>

Hi, We're performing bulk inserts into a database with the bulk_logged recover model and seeing the log file grow by 3x the size of the data file as a result of the bulk insert. This is not expected at all. A sample command: BULK INSERT Pulses_best FROM 'C:\FilePath\Remoted.txt' WITH (T...more >>

I am not sure if this is a stupid question, but here goes ... What does "improper use of cursors" mean? I mean, I know what a cursor is ... i just don't understand what its relevance is to SQL ... I would be grateful for any clues....more >>

Hi, I set up several backups in individual databases to back up on a weekly basis. Later, I set up a maintenance plan to back up all the databases nightly. I am now trying to find where I can delete the weekly backup schedules but cant find them. How do I go about this? The docs on backups ...more >>

Hello together, some months ago, I saw a website stating the restrictions of the x64 SQL implementations. Now I need them for a decision, but cant find them anymore. Can someone help me out? Thanks, Michael...more >>

Hi, We have a fairly large SQL Server installation and we have noticed recenlty that the TEBMPDB is growing. Can someone tell me why this would be the case? What makes TEMPDB grow? We are using SQL Server 2000. Yours AliG...more >>

Hi All, are there any good articles on tunning SQLServer 2000. I am new to SQLServer DBA work, but I have a lot of DBA experience with Oracle and others. TIA. John The One...more >>

On a live SQL Server 2000 in the last week I have noticed a problem with collation with the Model and tempdb both changing from 'Latin1_General_CI_AS' to 'SQL_Latin1_General_CP1_CI_AS'. I am not aware of anybody changing these settings. Do the any of the log files record when these values have c...more >>

Hi, I am fairly new to the log shipping, and trouble shooting our log shipping operation. We are using SQL Lite to back up, and some log backups are visible, but fail to apply with the following message. There are no back up files in the set, check for cancelled backup operations. Has an...more >>

Hi everyone, Maybe I have a very simple question ... I have a requirement that is very apropriate to use schemas. I understand that one of the advantages is to simplify the permission management and that I could assign a kind of 'dbo' permission inside a schema. I did the following steps: ...more >>

Hi, I have SQL Server 7 with a link server. When i try to execute a SP from SQL Server, i have this error : [ OLE/DB provider returned message: [ IBM][Pilote ODBC iSeries Access][DB2 UDB]SQL0107 - "pack14rexe" is too long. 10 characters maximum are accepted. ] I try this : exec recet...more >>

Hi there - I'm experiencing slow inserts on tables with AFTER INSERT triggers on them. I think it's because I'm joining to the [inserted] table to determine which rows in the trigger table were just inserted, and there are sometimes hundreds of thousands or even millions of rows inserted by a...more >>

When execute xp_sendmail as below: EXEC xp_sendmail @recipients = 'yamoho@yahoo.com' The recipient will see the mail sent from sql server. Is there a way to specify my email address when execute xp_sendmail so that the recipient will see the email address sent from me not from sql server? ...more >>

Hi... two questions: 1. When adding an additional data and/or log file, does SQL Server accept these changes dynamically or would one have to restart SQL services for the changes to take effect? 2. When using the BULK INSERT command with the BATCHSIZE option, if the task fails half-way t...more >>

I am trying to create a simple Maintenance Plan using the Wizard to backup my databases. When I click finish everything works fine apart from the last step, "Saving Maintenance Plan". The report I get is this Maintenance Plan Wizard Progress - Creating maintenance plan "MaintenancePlan" (...more >>

Hello, I have a table with text-items in different languages. There are columns TextID, TextItem and LanguageID (and one more ID with primary key). sample: TextID says "I am at home" in 10 languages, each with it's own LanguageID. So this textids has 10 entries. Some texts are only avail...more >>

Two questions relating to this: 1 - Do I require SQL Server 2005 or can this work with SQL Server 2000? 2 - My ASP.NET book says that I require MDAC 9.0. My registry setting says that I'm using 2.8 but I can't find where I can download an update from. Thanks if you can help with either of ...more >>

Hi Hope someone can help me as I am having major problems. I have seen this before but none of the usual fixes seem to work. Problem. Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot cycle, so I reinstalled Windows XP Pro. Note, after this I have had major problems wi...more >>

Hi all, I am looking for some functions which are used as "Start with" and "Connect By" in Oracle. Please help! Thx a lot. Regards, Thomas ...more >>

Is it easy to rename an instance, or change an instance to default instance? Basically I have an SQL 2000 Standard and MSDE installed on same machine, and I would like to swap around their instances. Thanks cj ...more >>

Comment faire ce genre de requete ? select top(10) T.* from ( exec SEL_MODELES 767 ) T WHERE T.ID > 50 ...more >>