Can I have a query to return the tables that have no primary keys defined ? Using SQL 2000 Thanks ...more >>

SQL Server 2000 Here is a data sample: DDate Acc Amount 10/10/2006 8:03:00 AM 40.2 0.04 10/10/2006 8:14:00 AM 40.24 0.04 10/10/2006 8:21:00 AM 40.28 0.04 10/10/2006 8:25:00 AM 40.31 0.04 10/10/2006 8:27:00 AM 40.35 0.04 10/10/2006 8:34:00 AM 40.39 0.04 1...more >>

I've got 4 columns in my table NameCompany NameFirst NameMiddle NameLast I'm trying to create a view in which a column "Full Name" will display all 4 above fields together. I want to return any of 4 columns if any is null. And i want to put a dot after NameMiddle If NameCompany is nu...more >>

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have this stored procedure in SQL Server 2000 SP 4. I replaced the commented away part by a scalar function that does the same thing. When running the modified procedure, I got a runtime error "Subquery returned more than 1 value". How on Eart...more >>

I'm trying to tune the DB that after two years is getting really slow. I have doubts if it is well designed. When I tried to drop index on one of the table I got message: Msg 3723 An explicit DROP INDEX is not allowed on index '%.*ls'. It is being used for %ls constraint enforcement. How can...more >>

Hi, I've created a CLR Stored Procedure to access a cube data, by using ADOMDClient. Now I intend to send the returned data by the SQLContext.Pipe, however the object type is a SQLDataReader and the ADOMDClient returns a ADOMDDataReader. I would like to "cast" from one to another, in order t...more >>

I've this statement in stored procedure: execute sp_executesql @Query @Query is a result from a build command query (another stored procedure) @Query = update table_name SET column_name='123456789' where ID=112 The error on that line is: Conversion failed when converting the nvarcha...more >>

When using sp_addlinkedserver to add a linked server, is there a way to explicitly specify that in the security context, connections will 'Not be made'? I'm tasked with adding 80+ linked servers and for each one of them, after they've been added using sp_addlinkedserver, I have to manually ...more >>

Hi, I am trying to determine if I should be using a cursor or if I can put my logic right into the select statement. I'm selecting my results and putting them into a temp table. In the value1 column, the following data appears: "Name: John Doe". Name: might not always be there. What I was h...more >>

Hi, I have a table with thousands of rows, of which, one column contains the string, in the following convention, PCDE_XXX, where the values of XXX varies, but PCDE_ remains constant. I'd like to only replace the PCDE_ constant value with a new value of, PostalCode_ Any idea how I can...more >>

Hi All, I need a development tool for writing stored procs in SQL Server 2000. I'd like to be able to set breakpoints and watchs and step through code. Any suggestions would be greatly appreciated. Thanks, Steve...more >>

I can guess from the name, but could someone tell me more specifically what Business Intelligence and BI Studio can do in SQL Server 2005? What are some examples of what I can make with it? Ive seen it there for a while, just never got around to figureing out what it can do for me.. thanks! ...more >>

I have a field of Image type in several tables in SQL Server 2000. Data was transferred from Access db awhile ago. In Access there is a way to see the image in OLE Object type column (right click on the field, then Bitmap Image Object, then Open. Paint starts displaying the contents of the fi...more >>

Hi, I've created a table, tb_logspace to store the results of DBCC SQLPERF(logspace), as shown below: INSERT INTO tb_logspace ([Database Name], [Log Size (MB)], [Log Space Used (%)], Status) EXEC ('dbcc sqlperf(logspace)') In my table, I also have another column, run_date that stores t...more >>

we have a 15 million data and our hardware configuration is Microsoft Windows Server 2000, SP3, 4096 MB Ram System Manufacture : HP Processor : 4 * GenuineIntel ~2399 Mhz Database : SQL Server 2000 , SP4 we keep getting this error, Anyone has any solution? do we need to increase more memr...more >>

Hi I have a query (shown below) which works fine on my Dev server but on the production server throws a Timeout Expired error. Here's the query... SELECT SessionArtists.SessionID, Sessions.SessionID, Projects.ProjectID Sessions.ProjectID FROM SessionArtists, Sess...more >>

Hi, I am having an issue creating a unique column in a view. I need to increment the 'mchn_mode_id' field by one each time a new record is added to the view from the source table. Could anyone possibly assist me with this? Regards, CREATE VIEW EUR_d_mchn_mode AS SELECT CAST('' AS...more >>

Hello People, someone could help me? I need to send the result of a query by email. I know how to send the email the problem is to put the result in a string. Thanks, Fabiano ...more >>

How can you embed a .Net function within in a SQL statement in SQL 2005? ...more >>

hi, i want to remove update and include this in the insert statement my structure --create main table DECLARE @tmp4 TABLE (o_num int, f_type varchar(30), LoanPckRec varchar(20), HudPrep varchar(20), HudRev varchar(20), DateDocsRcvd datetime, dt_pr...more >>

Does anyone know how to get the server version and Service pack via SMO? eg as it appears at the bottom of a query window: yourserver\instance (9.0 SP1) I could do with this working against SQL2K databases as well, so don't know if I can use SMO for that. Thanks...more >>

I tried to create the following scenario: MSSQL 2005 + sp1 in the first session I run: begin tran drop table temp1 --where temp1 is some table in the second session I run: select * from temp1 waitfor delay '00:00:01' when performing selection from sysproceses or sys.dm_exec_requests f...more >>

hi, i have a table like table name : temp order_no int LoanPk char(3) hud char(3) to insert into this table, its referring another table insert into temp select order_no,'NO','No' from abc first LoanPk and hud is inserted as 'No' and then it is updated according to the co...more >>

Hi there I want to implement a job command at SQL Server 2000 that should allow the following: 1. Do a backup to "xpto" database 2. the name generated by the backup should be: 21112006xpto.bak 22112006xpto.bak ... 21022007xpto.bak After archiving 3 months the first ba...more >>

Hello Everyone Apologies in advance for the long posting, I just wanted to help explain all the details and leave no doubts of ambiguity. I have a query, which returns results of an ID / Account Number /Flag. The query returns many flags for one Account number. i.e ID AccountNo ...more >>

Hello there I have Store procedure that do some process on single client. The current procedure that run this process on all the client is cursor that runs on the entire client table (at least 500,000 records) and do the store procedure on each one of them. this process is very slow (3 ...more >>

Hi All, I want a scalar valued function that will take table name as parameter. For example I have a table EMP_Regular that lists regular employees. I may have saveral other tables like EMP_Offshore, EMP_Contract etc. Then I wish to have a function that will take the table name and return ...more >>

Hello there I have huge sql sentence with one main table with cacluation and 4 other tables that i need to use on the sql As a result of that the performance is very poor. It seems that i need to change the clustered indexes but how to make it better? my tables are: Customers(CustID...more >>