Answer Questions

• beanz41 Inserting global variables storing values in a table

  Hi, I need a resolution of the following issue: Following SQL is to be inserted in an audit table : INSERT INTO GLOBAL_VARIABLE_LOAD ( [LOAD_ID] , [LOAD_STATUS] , [START_TIME] , [END_TIME] ) VALUES ( @P_LOAD_ID , @P_LOAD_STATUS , @P_START_TIME , @P_END_TIME ) @P_LOAD_ID , @P_LOAD_STATUS , @P_START_TIME , @P_END_TIME are the 4 parameters mapped to global variables (At package Level) which store values mapped in a previous SQL Task in my control flow. Following Error Message is thrown on executing the SQL Task: Invalid object name 'GLOBAL_VARIABLE_LOAD'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameter ...Show All

• CraigInGeorgia Tricky "TOP TEN" query

  I'm self-taught at SQL, so this may be an easy one for others, but I can't even figure out how to search for an answer. I need to put together a query as a datasource for a chart showing the firm's top ten clients by revenue AND the top ten clients by hours worked. It's easy to do either query separately, but the problem comes in when the two are combined. Then top ten by revenue doesn't always include all the top ten by hours clients, and vice versa [at the moment, I'm running a top twenty for each, then hand-compiling the top ten in Excel--oy!]. How can I write a query that will guarantee to include the top ten of both revenue and hours lists Thanks, elinde So, you do ...Show All

• CraigC could i have missed Reporting services during installation

  I recently installed SQL Express advanced and came across something thats confusing me. When i look at my running services i see the advanced features like SQL Server Full Text Search and the like ,but cant seem to find the reporting service. Is there a chance i skipped over it in the insall I had assumed i would have a service running that would say something along the lines of SQL Reporting Services. I havent come across directions on how to turn it on, so i assume that i missed it during installation funny you mention that problem. Firing up that was what first got me rolling onto looking for my reporting services.. I have installed the toolkit twice now and have the same result in it looking for t ...Show All

• Visions.net Passing in current database name to DTS-based SQL task?

  Hi all--I am writing a DTS package looking to back up all databases in sequence. I am calling CDOSYS in a stored procedure from support.microsoft.com to send email upon failure. I have two types of tasks I am writing into the DTS package: 1. backup database <database> to disk = '<drive>:\<path>.bak' with init 2. Upon failure, send the following message: declare @srvname varchar(128), @db_name varchar(128), @msg nvarchar(4000) select @srvname=srvname from master.dbo.sysservers print @srvname select @db_name=name from master.dbo.sysdatabases print @db_name set @msg='Hi--check your database backups. The ' + @db_name + ' database backup on ' + @srvname + ' has failed. Thanks--SQL Server'; Upon success, go t ...Show All

• Meggy Converting Access cross-tab query to SQL Server

  I have an Access cross-tab query that conditionally breaks up a field into multiple groups and averages the results in each group and I am having trouble doing this in SQL Server. The SQL Server query I have below works but does not find the averages by node A, B, RA, or RB. Is there a better way to do this than what I have below How would I do this in SQL Server In the Access query I use: right( [Serial No], iif( len([Serial No])-3>=0, len([Serial No])-3, len([Serial No])) Table: [Work Order No] [Serial No] [Parameter Name] [Type] [Min] [Max] [Value] [Pass/Fail] M1000 001A "Test Name" "System1" 0 100 50 P M1000 001B "Test Name" &q ...Show All

• avols143 Unlocking login on Status Tab always gets reset to Locked Out

  I've been having this issue lately with a new login. We have set it up to use the Windows Password and Expiration Policy and I give it an initial strong password. In testing this new account I would purposely input the wrong password into an application 3 times thus causing the login to become locked out. I would then go into the SQL Management Studio, go to the Status Page and uncheck the 'Login is locked out' flag. If I would then click the 'OK' button to close the properties, I would get an error message that the password is not complex enough. This is strange since I never changed the password in the first place, I just unchecked the 'Login is locked out' flag. That's issue#1. I then decided that I would give Management Studio the b ...Show All

• RON C How useful to have a clustered index within a SQL Server database table?

  Hi, all, Would please any expert here give me any guidance for how useful a clustered index can be within a SQL Server 2005 database Thanks a lot for any guidance for that. With best regards, Yours sincerely, Hi Helen, You do not have to create a clustered index on the primary key if that is the column you want the clustered index to be on. The clustered index is created automatically when you define a primary key. The only thing you need to watch for is whether or not you want the clustered index on the primary key. Typically that is the column that is used in the methods mentioned by Joey. But, if you use another column or a composite of columns where you use the methods described above, then you have to actua ...Show All

• Samoyed How to send email using asp.net 2.0 and how to find the smtp mail server name?

  How to send email using asp.net 2.0 and how to find the smtp mail server name You're in the wrong forum (actually, the wrong site). Try the www.asp.net forums. ...Show All

• JohnSmith TheForumGuy SQL Agent 2005 won't start

  I'm having a problem getting the SQL agent restarted. It ran properly for about a week then stopped. SQL Server is running fine. I've used the sp_configure to change the settings for 'Agent XPs' to 1. I can see the settings changed, but when I go through either the Management Studio or Surface Area configuration it fails and resets the 'Agent XPs' value back to zero. Here's the error I get in the sqlagent.out file: 2006-07-28 10:15:37 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2006-07-28 10:15:37 - [098] SQLServerAgent terminated (normally) I don't see an EventLog service under services that I can start. Any help would be greatly appreciated. Thanks! ...Show All

• Svetlana Simova Redistribution Agreement?

  Is the redistribution agreement for SQL Server Compact Edition online anywhere I can't find it. (I did find the one for SQL Server Express Edition.) Do any other users of this forum have an opinion about whether an agreement similar to that for the Express Edition (available at http://www.microsoft.com/sql/editions/express/redistregister.mspx) would be compatible with distribution in an open-source application, as long as the license wasn't GPL I'm thinking probably yet, but I'm not sure. Thanks. ------------------ Dan Cooperstock FreeDonationSoftware.org info@freedonationsoftware.org It will be available once SQL Server Compact Edition is released to web that is on 15th Dec. Thanks Sachin ...Show All

• Prashweenet ODBC support

  Can CE be called from an app. that makes ODBC calls Thanks. IIRC there was a OLEDB to ODBC bridge at some point that worked with ADO classic... Ah, there is no ODBC driver for the SQLCe engine that I know of. It uses an OLE DB interface... hth Here is a code example under OLEDB http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/08/691894.aspx I would guess that the reason he wanted an ODBC adapter was because he wanted the database to be accessible from some tool that supports ODBC, but not OLEDB. I'm actually surprised that there isn't some sort of generic ODBC-from-OLEDB adapter, so that if you have a DataSource accessible via OLEDB, you can turn it into an ODB ...Show All

• YongZai Why can't I do a select from a remote table having an XML column??

  Hey, I'm just trying to do select top 1 * from lnksql1.db1.dbo.Table1. This table has a column which is an xml column. It returns an error saying " Xml data type is not supported in distributed queries. Remote object 'LNKSQL1.db1.dbo.table1' has xml column(s). " What's the workaround for this Thank you. XML column is not supported in distributed query. This is a limitation Microsoft SQL Server currently has. You may work around it by pushing logic into remote server by, say, creating a Stored Procedure that convert the XML column to some format that DQ supports, or filter out the XML column completely, then call the remote stored procedure. Thanks! ...Show All

• Mike240 RS Configuration

  I'm working on a RS 2005 demonstration for my employer. On my equipment at home, the install goes just great. (winxp pro) On the server at work (that I have limited control over), I've managed most of the install successfully using the SQL 2005 Trial Edition, however, when using the RS Configuration Tool, the Web Services Identity won't allow me to enter anything, and when I try to connect to RS through the Management Studio, I get some warning saying that it recieved text/html when it was expecting text/xml or something like that, followed by a bunch of html. The main difference I can see in these installations is that the one that won't work is on Win2000 Server. So, I guess the one question that springs to mind is: is there something in ...Show All

• Zero_ Using SQL Server CE in a NON .NET Delphi Application

  Hi, I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO. I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :) Any help Anything that I might have missed Thanks, Dawid SDAC 4 for Delphi 6 and some other IDEs will be uploaded in the next couple of days. SQL Express has it's own set of problems. Well..... Borland has always had issues with ...Show All

• Sybed Login to SQL Server Express using Command Prompt

  How can I login to SQL Server Express instance(localhost\SqlExpress) using command prompt so that I can query database. Is there any alternative GUI tool for SQL Server Express Manager (I think Microsoft has discontinued SQL Server Express Manager). I prefer using Command Prompt. I am using WindowsXP Professional. oSQL is supported, but SQLCmd is the 2005 equivalent that is recommended. Simply open a command prompt and open the connection to your server as in: SQLCmd -S .\sqlexpress -E This will take you to a prompt where you can start typing commands. More information about SQLCmd is available in Books Online. Regards, Mike Wachal SQL Express team ---- Mark the best posts as Answers! Oops, I forgot to specify ...Show All