Answer Questions

• watch is SQL 2005 Analysis Service blocked by Zone alarm

  SQL 2005 Analysis Service blocked by Zone alarm when trying to load new data mining structures I have given every program related to SQL rights that I can think of. If Zone Alarm is up, BI Studio will freeze up loading data mining structures. If Zone alarm shut down no issues. No logs anywhere about program being blocked. Any ideas Great article thanks.  I looked at everything firewall related and in fact turned off all filtering or controls.  It appears if Zone Alarm is running at all, Anaylsis Services fails at certain tasks.  Still researching more with the article, will try some tracing and such.  Any other  ideas Have you had a look at th ...Show All

• robinjam EXAM 70-431: Anyone planning for it?

  I would like to collaborate with others who are taking the exam or who took it ... advices, sample exams, study guides, hints etc. Reply and share email etc. Hi , Please mail me at @ pawan_kv@hotmail.com . I have study material for this exam (70-431) and successfully completed MCITP. Regards, Pawan Kumar Practice practice practice and test, test and test makes you perfect in any subject. Hi, Please do not post duplicate threads refer your earlier post which is answered http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044839&SiteID=1 Hemantgiri S. Goswami I think it is possible. I'm currently studying for one of the MCITP developer exams whi ...Show All

• gumtoo how to perform this query to return data?

  I am using this stored procedure to check if user is exist and update his alread_loggedOn field.. IF EXISTS ( SELECT login_user_id , login_password , person_name , staff_active , is_staff , company_id FROM persons WHERE login_user_id = @login_user_id AND login_password = @login_password AND is_staff = 'Y' AND staff_active = 'Y' AND already_loggedon = 'N' ) BEGIN -- Insert statements for procedure here UPDATE persons SET already_loggedon = 'y' WHERE login_user_id = @login_user_id AND login_password = @login_password AND is_staff = 'Y' AND staff_active = 'Y' END ELSE -- RAISERROR('This value already exists.', 11, 1) RETURN 1073 b ...Show All

• uncle hammy T-SQL Badly needed

  To one of our sql server database Table A , we need to migrate data from another sql server database Table B . Assume there are two columns in a table namely OrderID and Comments . Here OrderID is a foreign key. And therefore, I can have any number of comments for a Particular OrderID. Thru a TSQL query, I wish to have all the Comments data beside the OrderID seperated by comma like Ord1 Comm1, Comm2, Comm3 Ord2 Comm5, Comm6. Comm7, Comm8, etc., This is just the thing we used to do for numeric columns using GROUP BY statement as SELECT ORDERID, SUM(ORDER_TOTAL) AS AMT FROM B GROUP BY ORDERID Want to know how to achieve similar effect with Varchar type of data. I'm currently using Cursor to concat, but it is taking long l ...Show All

• jkeele Sort and select, which executes first?

  I use SQL Server 2005. I want to split the data in a table into two parts, say 30%-70%. Here are my query statements: -- 30% SELECT top 30 percent * FROM DataTable ORDER BY Col1 --70% SELECT top 70 percent * FROM DataTable ORDER BY Col1 DESC Somebody says the result is not guaranteed to be correct since in SQL Server 2005, the query optimizer may choose different strategy to execute the query statement. I think select should execute after order by , which has nothing to do with query optimization. Am I correct Yes, this what I am using now. But I am still wondering if my method works without any problem. Actually, I tested it and the result looks fine. But I need to make sure that it can be used ...Show All

• Nancy_Issa SSIS Deployment Utility - Package Configurations doesnt show up??

  Hi: After moving my deployment folder to the Target Server, I run the Installation Wizard. As I move next, I am missing the window which is supposed to allow me to set package config values as stated in MSDN: "If the package includes configurations, you can edit updatable configurations by updating values in the Value list on the Configure Packages page." Source: http://msdn2.microsoft.com/en-us/library/ms141802.aspx Does anyone know why I am not seeing it In my deployment bundle which I have moved over has currently 3 files: 1) SSIS Deployment Manifest 2) SSIS Package 3) SSIS Config File Again, I double click on SSIS Deployment Manifest, and it starts fine. I go thru the steps for File System Deployment, ...Show All

• xluna Transaction not commiting using Microsoft SQL Server 2005 JDBC Driver 1.1

  I have some code that should execute multiple statements and then commit. I am using the Microsoft SQL Server 2005 JDBC Driver 1.1. The statements only commit ifI close the connection to the SQL Server 2005 instance. I've looked at the example given at http://msdn2.microsoft.com/en-us/library/ms378931.aspx and it doesn't require closing the connection in order to commit. Example: public void doCall(Connection con) { try { /*Turn off AutoCommit.*/ con.setAutoCommit(false); /**Call Two Stored Procedures.*/ Statement stmt = con.preapareCall(/*Java Code*/); stmt.setObject(/*Java Code*/); stmt.execute(); Statement stmts = con.preapareCall(/*Java Code*/); stmt2.setObject(/*Java Code*/); stmt2.execute() ...Show All

• l Bllizzd l Implementing Sql Server Express within a Strict Domain Environment...

  I am looking for some assistance from the grand knowledgebase out there concerning the implementation of Sql Server Express 2005 on a client's strict domain environment. I am designing and implementing a pos software that resides on registers and a server within a number of stores. The registers are running WePos and the server is running Server 2003.  I run an instance of sql server express on all devices. The registers read the server when it can see it but when it cannot it reads the local instance. I am seeing a number of performance issues and I am trying to tweek the installation and coding of SSE on all devices. Any words of wisdom for me out there Thank you, Sir Robert   The issue is more off how ...Show All

• elsamma connecting to remote SQL Server

  I have recently taken over as webmaster at my company and need help connecting to our remotely hosted SQL server. The company who is hosting it will charge me "support time" to explain how to connect to it. The database is used to store data and application information for our customer service center. So it is ALL database driven... i have installed SQL Server Enterprise Manager on my machine, but have no ideas on where to even being trying to connect. I have the name of the server, password....etc. But do not know where to configure a connection. ALSO, when i install my Enterprise Manager the first options askes me whether i want to create a new instance of SQL server on a local or remote machine....i am guessing my lo ...Show All

• frostit Like statement in a filter

  In a report I want a parametered filter on a specific text. I tried with the following statement: =Iif(Parameters!Filter.Value="Example",(Fields!Warehouse_Class_Code.Value),"NULL") like %TEXT% But no result. Please help! Thanks a lot! Now I have a filter with two values. A last question: I want a filter with a Label "All" and a value <Blank>. How to show the label "All" as a default in de dropdown on my report I tried the value %. This works in the preview, but not in the HTML viewer. Kind regards, Marius I have a table with several values: HARPAL06 CITPBK01 HARPBK08 HARPAL02 ONPAL07 I want a parameter with a filter on the r ...Show All

• AlexBB SQLCMD - Copy all procedures & code

  Hi All, Our Management studio for sql2005 is damaged and we only have way to copy through SQLCMD - command line. Please can any one provide me the script to copy all the user defined Procedure , Functions & Triggers code from database. Thanks in advance Hi, Please can anyone let mw know what is wrong with this code. It is giving me an error when I run it. Create trigger "SLocationinsert" on "SLocation" for insert as BEGIN declare @rowsAffected int , @nullRows int , @validRows int , @errorNumber int , @errorMsg varchar ( 255 ) select@rowsAffected Msg 102, Level 15, State 1, Procedure SLocationinsert, Line 11 Incorrect syntax near 'select@rowsAffected'. ...Show All

• Rekire query view

  Hi all, I ran a query, pasting in my sql text. I received this error. Msg 8163, Level 16, State 3, Procedure All_Participants, Line 7 The text, ntext, or image data type cannot be selected as DISTINCT. Msg 208, Level 16, State 1, Procedure Distinct_Proposals, Line 7 Invalid object name 'Proposal_Details'. But, I cannot see the msg numbers in my script. How do I find Msg 8163 Excuse the ignorance....only my second day using this :P Thanks, Steve hi Steve, the exception you get is thrown by a SQL Server 2000 code based version of SQL Server SQL Server 2005 usually results in SET NOCOUNT ON; USE tempdb; GO CREATE TABLE #t ( Id int not null, t text ); GO SELECT DISTINCT ...Show All

• Glen Satuito problem in connecting to sql server Express

  Hi to all, i'm installing sql server in my pc as netwrok service. when i try to connect it, it showing me a error sql server does not allow remote connections error 26 error locating server/instance (MS Sql server ) how can i resolve this plz help me out. it not able to connect the server locally. when i try to connect it with .\SQLEXPRESS or localhost\SQLEXPRESS it will connect to the DB But when i use ServerName\SQLEXPRESS it wont connect to DB what the problem plz help me with Regards Amjath Let's try the simple things first... Ensure that you've fully configured your instance to accept remote connections per the KB article on the topic, here . If that doesn't solve the problem then try some of the ...Show All

• papadi EXAM 70-431: Anyone planning for it?

  I would like to collaborate with others who are taking the exam or who took it ... advices, sample exams, study guides, hints etc. Reply and share email etc. Hi, Please do not post duplicate threads refer your earlier post which is answered http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044839&SiteID=1 Hemantgiri S. Goswami Practice practice practice and test, test and test makes you perfect in any subject. i have already done both 70-431 and 70-447. and i have blogged my experience about these exam in my blogg. http://madhuottapalam.blogspot.com/2007/01/mcitp-sql-2005-dba-yet-another-mile.html Hi , Please mail me at @ pawan_kv@hotmail.com . I h ...Show All

• SkiesOfBordom Problem with Context Switching feature in SQL 2005

  Hi, One of our client application launches a execuatable on server by calling master..xp_cmdshell. We are migrating to SQL 2005 and I would like to use the Context Switching feature We have sql login “client” which is used by clinet application and has very least privelge and have only required access to requried database and tables. xp_cmdshell is disabled by default on our server and I would like to enable xp_cmdshell, launch the executable on the server and disable xp_cmdshell . I have created another SQL Login “Bob” and is member of sysadmin. The below SP is created by logging in as “Bob”. My objective is to grant execute access on this SP and grant impersonate access to sql login “client” . So that client ...Show All