I am looking for sql server certifcation questions any one has any.like dumps or some thing...more >>

Salve, non riesco a disabilitare un trigger su sqlserver nè da query analyzer, nè da enterprise manager. In pratica tal cosa riuscivo a farla in Oracle con TOAD, mentre qui non riesco. Mi interessa disattivarlo senza cancellarlo per poi riattivarlo al bisogno senza rilanciare lo script di creaz...more >>

I have 2 tables Create Table Orders ( OrderNo Long, Amount Double ) Create Table OrderDetails ( OrderNo Long, Item varchar(20), ItemAmount Double ) the sum of ItemAmount for all items in an order in OrderDetails should be equal to the Amount in Orders tab...more >>

I'm trying to perform a calculation on a field in SQL Server that should return a value with a decimal point. My problem is that the value returned is truncated without the decimal point. Is there a setting that needs to be turned on in SQL server to allow this? for example Select 20/3 ...more >>

Hi there, I've just run some DTS packages on my test sqlserver (Which has limited hard disk space and memory) and all the tasks have failed, due to 'PRIMARY' file group is full Is there a query or script I can run to resolve this problem?? M3ckon *** Sent via Developersdex http:/...more >>

Hello, I am relatively new to SQL Server, although I have used Oracle extensively. In Oracle, there are system tables that you can query in order to get a list of all schemas and all the tables in them. Is there a similar concept in SQLServer? How would I find about the system dictionary ...more >>

I have tables with columns that stores datetime data in int format on SQL server 2000. For example, the datetime for '4/5/2004 00:00:00.000am' is stored as 1081180800. "4/4/2004 11:59:59.000pm' is 1081180799. I need to generate reports that display datetime columns in "mm/dd/yyyy hh:mn:ss" fo...more >>

hi all, i got is table: Id StartDate EndDate a 19/03/2001 18/03/2002 a 19/03/2002 18/04/2002* b 13/08/2000 12/08/2001 b 13/08/2001 12/08/2002 b 13/08/2002 10/07/2002* Sort command and groupins i am ok but i need to select only the records that has the latest enddate. (...more >>

Hello all, I'm using SS 2000 and NT4. Say I've got three tables: T1, T2 and T3. T3 contains the 1-to-multiple data of the relation between T1 and T2: ------------------------------------------------ CREATE TABLE #T1( T1PK INTEGER NOT NULL PRIMARY KEY, Name VARCHAR(3) NOT NULL )...more >>

I have two tables: T1 : Key as bigint, Data as char(20) - size: 61M records T2 : Key as bigint, Data as char(20) - size: 5M records T2 is the smaller, with 5 million records. They both have clustered indexes on Key. I want to do: update T1 set Data = T2.Data from T2 where T2.Key = ...more >>

I've only just started using update queries and have a problem with the following query in that it comes back with this error: "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." Query: UP...more >>

I'm still a database newbie so I would like to solicit thoughts about the smartest way to do something in sqlserver. My company has a web application that we customize for each client. We can do this because everything is database driven. We have database tables that contain our HTML and da...more >>

Hi; Is there an **easy** way to tell tsql apart from standard sql? Will sqlserver run scripts written only in standard sql? What about variable definitions? Thanks in advance Steve...more >>

Dear All, I am using a SQL server database with around 20 columns,all the columns have numeric values, I want to write an SQL statement which does the following: compare each row of the table with all other rows in the table and return all the rows that have a difference of + or - 0.5...more >>

Hi there, Need a little help with a certain query that's causing a lot of acid in my stomach... Have a table that stores sales measures for a given client. The sales measures are stored per year and there could be multiple sales measures every year per client. There is another field calle...more >>

Can we make a Index on 2 or more tables Table a: Col1 int col2 varchar Table b: Col1 int col2 varchar can you have a single index for two tables a and b on the column Col1. Is this possible in SQL-Server. As far as i know you can make an index only on one Table. can the index b...more >>

Hi, I am storing information being sent to me weekly into a ms sql database. The one twist I am running into is that later down the line the information I recieve may require more columns, or columns might be renamed so having a static database call is out of the question. I was using mysql but ...more >>

I have a table with some sensitive customer data in it. I am now keeping all the data in another table, and encrypting it. I want to get rid of the original unencrypted data and be sure that it is no longer anywhere on disk. Should I drop the table, or first delete the rows and then do a dump...more >>

Hello, Access XP, SQL Server 2000 Is it possible to hide a SP under Queries in Access, yet still be able to Execute it from Access? We hooked up a custom form to accept the input parameters (MS Feature Request!) for the Stored Procedure. We had two problems with MS's 'Input Parameter' di...more >>

Hi there I have a stored procedure which uses an INSERT ... SELECT statement to transfer records from one table to another. However, I also need to insert an extra field to the table which is from a parameter @orderid ( the field is called orderid) Can someone tell me how this can be acheiv...more >>

Newbie question: Aside from the single quote (i.e. chr(39)) what other characters can cause MS-SQL server to cough-up the insertion / update back in your face? TIA ...more >>

We have installed a package developed by another company and sometimes (when the server is with a big rate of transactions), we are seeing the following messages in package debug file: 2004-04-22 14:23:27 3056: ------------------------------------------------------------ 2004-04-22 14:23:...more >>

I'm looking for a way to transform the contents of n source tables into a single destination table. This by itself is no problem. However, the name of the source tables change, so I'll need to base the transform task on a global variable that I can update via external code. Not sure how to do ...more >>

We have a re-indexing all DBs schedule job in our SQL 2000 box, normally it took 7 hours to complete but all of the sudden now it takes more than 20 hours. What do you think it cause this problem? We have no clue....more >>

I am trying to determine the number of columns that are returned from a stored procedure using TSQL. I have a situation where users will be creating their own procedures of which I need to call and place those results in a temp table. I will not be able to modify those users procedures. I figure...more >>

Hello, I want to open a mdf file but i don't no the database manager to do it. I suppose that solution is with vb and msde But i'm newbie thanks ...more >>

Hi, I am writing a remote update app, and I'd like to programmatically backup the SQL Server 2000 database before running the SQL files over it. Can anyone tell me a command that does a hot backup of the DB and puts it somewhere, which I would shell exec from my program. eg ShellExec("hotbac...more >>

qualcuno sa dirmi cosa c'è di sbagliata in questa query: EXCEPT ({ SELECT idAttach FROM tbAttachs }, { SELECT idAttach FROM tbAttachsForPages WHERE (idPage = 2) }) gr...more >>

We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files ...more >>

Platform: Win2000 SP3, SQL 7.00 - 7.00.1063 I have a SQL-authenticated user with the following permissions: "Process Administrators" server role "db_owner" and "TargetServersRole" for msdb database "db_owner" for master database. The problem is that when this user opens up any job (i.e. own...more >>

Environment is SQL Server 2000 64 bit. I restore from a script 'my' database, this works fine. However, all the tables are also found in master, no data though. Anyone experienced this?...more >>

ciao a tutti... ci risono... devo migliorare delle performance di accesso ad una tabella... la tabella non ha indice primario, ne altri indici... sulla tabella ci accedo con select di questo tipo.. select @ExistInOAG = count(*) FROM caprs05dev.dbo.OAG WHERE Air_Ca...more >>

Hi, I'd like to round all amounts in a certain column to 2 decimals. I tried the following query, but eventhough the syntax is correct, it doesn't give any result: update gbkmut set bdr_hfl = round(bdr_hfl,2) can anyone help me? cheers, steve...more >>

Hi, I got a backup file from my friend which needs 11 GB to hold the transaction log. I tried to restore this database but an error message: "MODIFY FILE encountered operating system error 112(error not found) while attempting to expand the physical file." appeared. The free space is mo...more >>

Hi, I would like to select records from a table where the following criteria hold: SELECT * from Mytable where field x "contains" string @X or field x "starts with" string @X or field x "ends with" string @X What would the syntax for the "LIKE" predicate be in each of these ...more >>

Hello, I have a problem with exporting and importing a DTS package from one server to an other. Saving a package like a VB-file is an option I have seen, but how can I import a VB-file on the new server. Do I need a separate program? Is there a possibility like exporting and importing a Job (...more >>

Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be us...more >>

Hi, I have a weird UPDATE sequence I want to perform. The customer does not want to use INSERT and DELETE. My issue is that there are multiple Mat_Class, but I do not wish to hard code each one individually. Originally I was thinking of using a select statement and creating a loop to sub in e...more >>

I would like to know if I can determine the calling user from within an extended stored procedure. I assume it's accessible in the SRV_PROC structure somewhere. Also, does anyone know of a comprehensive list of what is included in the SRV_PROC structure? This is for SQL Server 2000. Tha...more >>

I have everything set up with SQL Server 2000 and Outlook 2000 and the procedure works fine but the message sits in my inbox. When it open the e-mail it says this message has not been sent. I just click send and the e-mail sends. Is there any reason I have to manually sent the e-mail after th...more >>

How viable is it to use MS Access as a front end (via ODBC) to a SQL Server 2000 database? The users would access via the internet using a netgear vpn setup. Thanks, Paul S ...more >>

I prefer to write SQL code, without graphical tools. Have third party Query Analyzer that has filter and sort abilities? Also I looking for SQL editor with Completion ability (like we know for programming lang), for assist me write more quickly. ...more >>

Scusatemi , avrei bisogno di lavorare su SQL SERVER 2000 Analysis Services potreste indicarmi un link per il download della Demo o Trial che sia. Purtroppo ho cercato, ma visto che sono qui a chidere aiuto il risutato della mia ricerca penso sia ovvio, :P Analysis Services è integrato in Sql Se...more >>

Salve Ragazzi!!! ho un problema che non riesco a risolvere e spero di riuscirci con il vostro aiuto... dunque.. ho un file csv tipo questo Date,Aircarrier,CallSign,ComFltNbr,AcReg,AIPTDep,AIPTDst,STD,STA,AOBT,ATA,CancellationDate 01/2004,AZ,,0735,IDATD ,SKG,MXP,01/01/04 04:20,01/01/04 06:45,...more >>

I am getting the following error message while attaching my DB in SQL Server 2000. "Error 823:I/O error ( torn page) detected during read at offset 0x000000000026000 in file 'C:\TestFile.MDF.' I basically, detach the DB from my server and copy that MDF and LDF to another server. Then I F...more >>

Does anyone know of a way to add *key words* to Query Analyzer's syntax highlighting feature? I would think that there would be a text/xml file that could be modified. This certainly can't be hard coded. Thanks, Bryan ...more >>

I'm having a little problem with using Select Not Exists between 2 tables. I get the infamous Primary key "Cannot insert duplicate key" error. This is on MS Sql 2000. I'm trying to create a temp table with distinct values from another table. Heres a small snippet of the code. Create table...more >>

Hi, I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm trying to install the MS SQL Server Reporting Services that is in the MSDN of April 2004. I also have Visual studio.net installed. So when I run the CD all goes well until you specify the database for the reporting se...more >>

Hi, Can anyone please tell me if there will be support in SQL2005 - Yukon for datafiles to be placed on Compressed volumes or if there will be compression of the data that is transparent to the user. Thanks! <Keeps fingers crossed> Jack...more >>

My company maintains 40 replicated Sybase databases using a merge replication approach. It's difficult to update all 40 databases when a structure change occurs. Structure changes are minor, usually adding fields. We are considering moving to SQL Server 2000 in the hope that these updates wil...more >>

How do you retrieve a list of db roles from within T-SQL??? I can't find a sys table that returns a list of roles. sysobjects does not list roles as a object type. I found sp_helprole, but I can't get the sp to return it's output into a cursor or variable. Help?? Regards, CxG...more >>

I need the maxvalue of 2 colums for each row Select date1, date2, maximum(date1,dat2) as datemax. Is this simple to realize ? date1 and date2 can be NULL. something like this: select date1,date2, maxdate = CASE when date1 is null then date2 when date2 is null then date1 else...more >>

Ok, I haven't been doing too much database work lately and my brain has gone soft. I need some help with proper structure. My database is being used to track television shows. Any given show will be associated with at least one production company (call it ProdCo) but possibly up to 3 prod...more >>

Hello all, I'm looking for some hints as to how to use the results of a query in another query. I assume I'm 'thinking' wrong in how to solve this, so I'm hoping someone can clobber me and send me in the right direction. My question is best illustrated by simplified example. I have one tabl...more >>

hello group, is it possible to do a storage snapshot of a running ms-sql database without losing transactions? What tasks must be done before such a snapshot. thanks in advance, Bernhard...more >>

i need to alter all foreign keys in my database and uncheck the "Enforce relationship for replication" check box. Using the EM, I extracted the code snippet below. unfortunately, when i run this test from query analyzer, then go back into the EM, the box is still checked. can anyone tell me...more >>

I'm having difficulties invoking a user defined table function, when passing to it a parameter that is the result of another user defined function. My functions are defined like so: drop function dbo.scalar_func go create function dbo.scalar_func() returns int begin return 1...more >>