Hi all, we have restored a database, and then by runing an upgrade utility we have upgrated the database. Now , we need to test the upgrated database i.e all old tables are present in the correct scema...space used in the current database..blah..blah..blah.. Would u pls suggest some approa...more >>

Hi, Please let me know how to install the "SQl Server Business intelligence Development Studio". Does it get distributed as part of SQl server 2005 Enterprise edition etc. Please pass on any useful information. Thanks Santhosh ...more >>

How can I write a procedure where I want the following scenario I have a field called "suburb' create someProcedure ( suburb1 varchar(50), suburb2 varchar(50), suburb3 varchar(50) ) AS BEGIN .... ... END GO I want to check in a table if records exists such that suburb mat...more >>

Hi there Has anybody experienced Timeout issues on updating NText fields in SQL Server 2005? Ive been using a procedure in an MS Access application, to read in the contents of an Ntext field used for notes into a local string variable. Then further notes are added to this and then an upd...more >>

Sorry for newbie question, I am going to create a stored procedure for two task: Inset a row to a table, and return the Identity field(which is auto-increment) to the program. Thanks. ...more >>

Hi, I have a stored proc intented to search a table on different fields, depending on the search type. Up until now, I have implemented 3 options, which is by kanji, kana and english. I'll add many others, like strokes count, radical # and so on. Here it is, with the 3 options (it may see...more >>

Hi Friends, I have installed SQL server 2005 Express Ed. and management Studio Express. How Do i know if these are havibg SP1 Installed or not? I have the Database displayed as: MyHomePC\SQLExpress (SQL Server 9.0.2047 - as version info. Please guide Thanks Prabhat ...more >>

I need to write a a query to update col3 to 9 for each unique id _but_ only the record for that id that has the max col2 value col1(id) col2 col3 1 2 4 1 1 4 2 1 4 2 2 4 3 1 4 3 3 4 3 4 4 --so after the update it looks like this... col1 (id) col2 col3 1 2 9 1 1 4 2 1 4 2 2 9 3...more >>

Can someone who knows a lot more about this than me please tell why, when the following code executes, I get a pop-up window telling me the usage of isqlw.exe? <code> strQueryCommandPath = "C:\\Program Files\\Microsoft SQL Server\\80\\Tools\\Binn\\"; strArguments = "-S(local)\\SQLEX...more >>

Hi, I am trying to maintain logical data integrity by using triggers. In my case I have "Item" table and "SaleTransaction" table for which item_id is a foreign key. Item record can have 0 or 1 "saletransaction" records. Now let's assume that there is Item.salestatus field and one of th...more >>

Is it possible to get the call stack from within a SQL statement? Specifically, I'd like to get the statement that causes a trigger to fire from within the trigger itself. Thanks, -k ...more >>

We have a couple of Bill of Material tables in our SQL 2000 database and I need to extract information. The first table is the master table and the only relevant field is fpartno. Table two is the child table, and it contains all of the parts that make up the fpartno in the master table. Th...more >>

I am trying to join three different tables on common column names, with a Group by clause on the first table. This is the error I keep getting The column prefix "column name" does not match with a table name or alias name used in the query. Any help will be greatly appreciated! -- The S...more >>

In SQL Server 2005 is it possible to set a table as readonly? I know you can mark the entire database as readonly but what about just on table? ...more >>

Hi Simplified version of query: Have tried both with and without SET CONCAT NULL_YIELDS_NULL ON But my database default is set to ON anyway. SELECT Address1 + ' ' + Address2 + COALESCE(', ' + Address3, '') + ', ' + Town + COALESCE(', ' + County, '') + ', ' + Postcode AS Address From Tabl...more >>

I cant insert new rows through the view for the following tables and view... FOR EXAMPLE THE FOLLOWING INSERT STATEMENTS give error insert into states values( '1','john','CA' ) insert into states values( '2','MARY','NY' ) Server: Msg 4436, Level 16, State 12, Line 1 UNION ALL view 'STA...more >>

From my batch script I am able to count the number of rows that satisfy a query but not able to retrieve the rows. For example, these work: 1 - select count(*) from unsupported 2 - select count(*) from unsupported where systemname = 'tracker' The results are 450 and 1, respectively. But...more >>

Hello. A have a Stored Procedure that has one passed in variable. I need that variable to append to a table name that needs to be dropped if it exists. My dynamic SQL looks like this: Create Procedure MyProcedure @NetworkID Char(2) -- Passed in parameter IF exists (select * ...more >>

I had created a view on a sql server 2000 (BigDaddy) select * from employee and I want to schedule this view to be executed daily at 2am. The results must be saved on a workstation, AAA1009. How do I schedule so sql server can execute the view and save the results over network? Your help is...more >>

We've got a self join on a table with a view of that table and two others. Off the cuff, does anyone know if this is valid / not valid / a darn bad idea. The PeopleSoft software we're using does an update based on the results of that view select statement and I'm seeing a lot of IS Table...more >>

Hello, I was able to select all databases from master..sysdatabases, but I am not sure how to run queries against each row so I have something like: "database" "query result" "database2" "query result" .... Any ideas? PS: Each query should run against a different database ...more >>

Is there a materials such as the following for an Oracle DBA who would like to learn MS SQL(e.g. 2005) - Training courses - Web sites/ebooks - MS articles - etc SQL Server features and compare it with Oracle. So, it should be something of learning method for a person with DBA knowledge(i...more >>

Ho to all... I'm stuk with a problem on a simple query... SELECT risorse.ID_Risorsa,risorse.CODICE,a.ID_Ordine FROM risorse LEFT JOIN (select * from lavorazioni WHERE lavorazioni.DATA_INIZIO<25/08/2006) a ON Risorse.ID_RISORSA = a.ID_RISORSA Why this query doesn't return the a.ID_O...more >>

Is possible copy a file from a directory to another, from a SQL procedure? Thanks, Rui Oliveira ...more >>

I've tried this with an example - but of course an example isn't definitive indication that the behaviour is required by standard (SQL-92) or is guaranteed by implementation (SQL Server 2000). Hope someone can help by pointing me in the right direction. The problem is that I'd like a stored ...more >>

Hello, I would like to optimize the following query. The goal is to give a record number on each row based on a row owner and a timestamp. UPDATE dbo.mytable SET rec_id = (SELECT COUNT(*) FROM dbo.mytable b WHERE owner= N'me' and a.[timestamp] >= b.[timestamp]) FROM dbo.mytable a WHERE o...more >>

I'm using this procedure to update all indexes in my database: http://www.sqlskills.com/resources/demoscripts/sp_RebuildIndexes.txt Here in procedure Kimberly created the following table: CREATE TABLE #ShowContigOutput ( ObjectName sysname, ObjectId int, IndexName sysname, ...more >>

exec master..xp_cmdshell 'net use ' result output ------ List is NULL NULL NULL cmd window C:\Documents and Settings\cn.popeye>net use status local server network ------------------------------------------------------------------------------- discon...more >>

Dear all, Is there any way can I insert a new field between existing fields = through TSQL or other means, without using Enterprise Manager? Thanks a lot. Regards, Alex AU...more >>

this is date: 01 08 2006 declare @d_date varchar(20) set @d_date = '01 08 2006' using convert: select convert(datetime,@d_date ,120) ------ 01 08 2006 replace space to '-' select convert(datetime,replace(@d_date,' ','-') ,120) ------ 01 08 2006 replace space to '/' select convert(d...more >>