Answer Questions

• herocomplex Count(*)?????

  I am trying to find the significance of using the Count(*), does that mean it only pulls one value according to the query that the procedure calls or what i am a lil lost on this particular feature CREATE PROCEDURE dbo.Sales ( @UserName varchar(256) ) AS DECLARE @Exists int SELECT @Exists = COUNT(*) FROM SalesPerson WHERE UserName=@UserName IF (@Exists <> 0) BEGIN SELECT SalesPersonId FROM SalesPerson WHERE UserName=@UserName END ELSE BEGIN SELECT -1 END RETURN GO Yes one value you can also rewrite your proc to use exists instead (should be faster than count) CREATE PROCEDURE dbo.Sales ( @UserName varchar(256) ) AS IF EXISTS (SELECT * FROM SalesPerson WHERE UserName=@UserName ) BEG ...Show All

• magicalclick Database Mail does not work from SQL Agent Job

  Receiving Message: [264] An attempt was made to send an email when no email session has been established Just installed Service pack 1 and that did not help. We could not repro in our labs. Did you restart SQL Server Agent after setting/changing the profile Thanks, Gops Dwarak http://blogs.msdn.com/gopsdwarak/archive/2006/04/25/583434.aspx Take a look at the above blog and this should address the problem you are running into. Thanks, Gops Dwarak Thank you for your reply. Unfortunately, I have already done those three steps, and still have the same problem I got the same error after running a script (inherited from our DBA) that calls sp_MSupdate_agenttype_default several times ...Show All

• clint 2 i need help: SiteBuilder for Windows (sitebuilder-3.0.2_build060426.365_win.exe) installation error

  where i can download service pack for windows server 2003 Lameck - Can you confirm that you are running Windows 2003 Sp1 this is a pre-reg for Sitebuilder - you should confirm the other pre-reqs as well by referencing: http://www.swsoft.com/en/products/sitebuilder/win/reqs/ I would guess that your system does not have Windows 2003 SP1 installed so I would recommend going here downloading it and installing it: http://www.microsoft.com/technet/downloads/winsrvr/servicepacks/sp1/default.mspx - you can confirm its installed by right clicking on My computer on your desktop selecting properties and looking at the system details on the General Tab. Thanks, AWAL thanks. unfortunately theyre a ...Show All

• Samoyed VSA supports only Visual Basic .NET as a programming language.

  Why This is the wrong forum to ask to be honest. VSA is owned by the Visual Studio team so only they can answer that question. -Jamie Just for your info, we are looking to enable c# scripting in future versions - no promises, but we aim to please. I expect you'll get a familiar reply from VSA - a balance of demand, resources and time. That's what drives most decisions unless solutions are not technically possible. Donald Ok, I'm going there. Thanks Donald. It's a pity due to we've c++ developers who are now facing .dtsx building. ...Show All

• PhilAJ is there an easy way to replace a db name in all stored procedures

  I have a database with 20 sp's. All the 20 sp's were referncing to a look up db whose name has been changed. I dont want to open all the sp's individually and change the lookup table name. Is there an eay way to do a search and replace by using a another sp or something that will look at all my 20 sp's and make the change Thanks Not really. Just script them out into a file and do a search and replace. Hopefully your database name is not the same as any other object, and it should be pretty easy. No. The 'best' option, as Louis indicated, is to script out the stored procedures. In SQL 2000 Enterprise Mangler, you can right-click on the database, click on [All Tasks], and then [Generate SQL ...Show All

• tattoo RS 2005 Prompting for Credentials

  For the life of me, I can not get integrated windows authentication to work with an installation of Reporting Services 2005. I get prompted when connecting to the /Reports IIS virtual directory when not on the IIS machine. If I'm logged onto the machine I don't get prompted. Or if i use the IIS servers IP address in the URL I don't get prompted. The only way I can avoid windows prompting (when not logged onto the IIS machine) is to set the /Reports virtual directroy to "Enable Anonymous Access" I know Windows Integrated authentication works because we have other web applications where Anonymous access is turned off, and everything works as expected. Meaning going to another server for database access thos ...Show All

• chronozphere AMO vs. ADOMD

  I use AMO to programmatically create a complete database with datasource, datasourceview, dimensions, and cubes. I also have a webservice that uses ADOMD.NET to retrieve metadata about those objects (for security purposes and also for .NET 1.1 applications). However, I notice that using ADOMD's GetSchemaDataSet only return certain metadata. For example, for a dimension, it doesn't return the DimensionID or other properties I am able to set with AMO. I want to use ADOMD.NET because it returns the metadata in XML format already. With AMO, I have to serialize the dimension object. Is there any other way to retrieve additional metadata for AMO objects > I assume I can just deserialize the xml to get the A ...Show All

• Roozbeh Sharafi Developing Stored Procedures using Management Studio Express

  Hi, I am new to SQL server 2005. I am developing stored procedures as follows in Management Studio: 1)Right click Stored Procedures folder on a database 2)Select "New Stored Procedure" 3)Write the query in a .sql file 4)Execute the query. Now in this model, I dont seem to have a develop->test->develop and then deploy, type of development cycle. The problem is each time I execute a query it is deployed and re-executing it results in an error like: "There is already an object named 'NewEmployee' in the database." Which forces you to manually delete the SP and re-execute your query. It doesn't give you a chance to test your SP logic before deploying. Contrary to this, If I developed CLR SP's in Visual Studio, I wou ...Show All

• Sudheer Palyam Sql server 2005 trial edition

  Hi , i am trying to install Sql server 2005 trial edition , There were 3 types of files for download Self-extracting executables: X86 Executable X64 Executable IA64 Executable Didnt know for which they are applicable , i have a windows xp professional SP2 I downloaded "X86 Executable" . Then tried to run the setup.exe file . It says installing Sql Server 2000 but i want Sql SERver 2005. I have checked couple of times and am pretty sure that i have downloaded sql server 2005 trial version and not the 2000 version. can some one help me Thanks red If you run the downloaded package it will instal SQL Server 2005. X64 and IA64 packages are SQL Server 2005 for 64-bit platforms x64 for AM ...Show All

• paulanthonysamson Toolbox is all grayed out and IUIService Could not be located received

  Every time I try to edit a Control flow or Data flow task I am getting the following error. My toolbox options are all grayed out also.  TITLE: Microsoft Visual Studio ------------------------------ The service System.Windows.Forms.Design.IUIService could not be located. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=UnableToLocateService&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Any help is appreciated Gulden I had to re-install Visual Studio. The error message disappeared. However I h ...Show All

• matthew_arena Displaying inividual fact details in report body

  I have a dimension for account and measures for time taken for editing etc. which provide a sum of minutes taken to edit all documents in each account. The requirement is on clicking on the account link to be able to get details regarding each document in every account. for each document, I would need to display editor name, time taken, document type etc. How do I display details that are not an aggregation along the rows but individual details of each document I would suggest using the drillthrough mdx command - more details @ BOL: http://msdn2.microsoft.com/en-us/library/ms145964.aspx ...Show All

• Emy_P change date&time default formate to mm/dd/yyyy

  dear i've an old sql server 2000, with default date format mm/dd/yyyy i've installed a new one SQL server 2005 , my application did't work with its date format i wan't to change SQL 2005 default date format to mm/dd/yyyy instead of dd/mm/yyyy regards Dates are displayed as configured for the user (its a session setting). But formatting of the dates should be made in the front end / presentation layer. Don’t do that on the server, try to pass the date in a more generic format like ISO Date. 20061114 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• PedroCGD SSL Diagnostics ERROR Please HELP ME!!!

  I kept getting these errors anyone know how to fix them System time: Tue, 30 Jan 2007 09:07:04 GMT ModuleFileName: C:\Program Files\IIS Resources\SSLDiag\SSLDiag.exe version: 1.1:34.0 CommandLine: "C:\Program Files\IIS Resources\SSLDiag\SSLDiag.exe" ProcessorArchitecture: x86 OS: Windows XP Service Pack 2 #WARNING:IIS5.1 - World Wide Web Publishing (W3SVC) service is not installed [ HKLM\System\CurrentControlSet\Services\InetInfo\Parameters ] CertChainCacheOnlyUrlRetrieval = True(default) CheckCertRevocation = False(default) CertChainCheckUsage = False(default) #WARNING:sspifilt.dll is not loaded into inetinfo.exe [ SChannel Info ] ServerCacheEntries = 0 ServerActiveEntries = 0 ServerHandshakes = 0 ServerReconnects ...Show All

• mattdawg Export To Excel Gives Me Gray Cells

  I have a report which was in RS 2003 and exported to Excel fine. Now when I export the same report using RS 2005 to Excel I get gray cells at the bottom of each table. I have the background of the body set to transparent. I have tried setting the background of the body to white and other colors. Those colors show up but the gray is still there as well. In preview mode and export to pdf I do not have those problems. Basically gray cells are showing up where they should not be. Any help would be great. I do have items in the footer. Now here is the kicker. When I take the color out of the header of the top most table then the background goes to white and all the other tables retain their color. the space b ...Show All

• akoties how to loop through several excel sheets in a file in integration services

  Hello, I'm new at Integration services and I have an excel file with information in several worksheets. I want to loop through some specific sheets to retrieve the data and save it in a database table. I know how to retrieve the data from one sheet, but I don't know how to do it for several sheets. Any ideas ...I would appreciate any help. Hi Rafael, Trying to use a DELETE statement against the Excel file yields an error message (the syntax varies based on where I click OK), but generally all say something to the effect of "Deleting data in a linked table is not supported by this ISAM. (Microsoft JET Database Engine)". So my only recourse seems to be, as you suggested, to (1) create a &quo ...Show All