Answer Questions

• NILKAMAL Cannot start SQL Server Browser

  Hello, I use SQL Server 2005 for multi-user access. In the Surface Area Configuration, I changed the protocol from TCP/IP to Named Pipes and restarted the service. Then I went to SQL Server Browser, stopped it and clicked on Start to restart. I am getting a message "An error occurred while performing this operation". I am not able to get the Browser started. Any help would be greatly appreciated. The key one is "The SQLBrowser service port is unavailable for listening, or invalid.". So what happens is SQL Browser starts up and enumerates all network interfaces and attempts to bind to UDP port 1434 on each one found. If it cannot bind to any of the network interfaces, you wil ...Show All

• kymaita How to import from text file

  Hi. Basic question: how do you import from a .csv file into a database table Thank you. See SQL Server 2000, 2005 Books Online topic: bcp Utility or check out DTS/SSIS import tasks You can also use bulk insert. DTS is best to go when you are not sure about few things that are new to you. http://www.microsoft.com/technet/prodtechnol/speech/library/loganalysis/log_files_UsingDTS.mspx KBA http://support.microsoft.com/kb/285829 ...Show All

• Amde The given key was not present in the dictionary

  Hi, When I try to preview a SSRS report in VS 2005 I get the following error: "The given key was not present in the dictionary", however when I deploy the report and view it in the Report Manager all is fine. I have not been able to find any usefull info in MSDN, any one have an idea what I can try Hi Donovan, That was the problem yes, solved it. Any idea what that file is for I'm tempted to delete all the .rdl.data files on a daily basis... :) Hi, Thanks for the reply. I do not think that this has anything to do with login IDs since I can preview other reports from Visual Studio, it is just this report that I cannot view in Visual Studio, it must be something unexpected in this report... Dear , ...Show All

• CoDeR X Chart

  Hi, My chart look like this: http://img242.imageshack.us/img242/7056/fig1kd9.png I have a dataset like this Parameters are startdate=1/1/2000 and endDate=12/31/2002 HumanExpo AnimalExpo InfoCount sDate 20 45 6 1/1/2000 30 56 8 1/2/2000 .. ... .. ......... 20 .. .. 12/31/2002 The dataset is returning the Animalexpo Count,HumanExpo count,Information Count for each day i.e DayByDay. In my chart, the X-Axis like this.. 1/1/2000,1/4/2000..... 12/31/2002(Quarter of the year) and Y-Axis like this..0,1000,2000,3000.....10000 under Series group,Categories groups,Data groups what i need to put. Please he ...Show All

• harish1981 How to hide parameters information from URL

  I am using sql 2K reporting services: Please does any one has an idea how to hide the parameters information from URL completely. I am calling the reports via aspx page, using a URL and in the url placing all the parameters., is it possible to hide just the parameters information. i don't want to allow users to change the parameters directly from IE. or is it possible to encrypt them. Please help, i have been struggling for this and don't get no clues at all how to go forward with this. Thank you vfery much. I have a similar problem but in Url of Response.Redirect() function of VB.net, ex: Response.Redirect("./ViewOvertimeSheet.aspx EmpID=" & e.Item.Cells(1 ...Show All

• Thwack I have a Blog Table which contain following Blog Details

  Table: Blog UserId | BlogId | BlogDetail | CreatedDate 1 1 xyz 12/23/2007 1 2 fdf 12/23/2007 The data is about 10000 rows and according to above structure and sample data I want to use sql so that I can get the Data in Following form Day Count Wednesday 30 Tuesday 20 Monday 30 LastWeek 40 Two Weeks Ago 55 Last month 5 1 year Ago 200 ...Show All

• clarkie SQL Server 2005 Reporting Services Add-in for SharePoint, Installation

  Setup:  Windows server 2003 SP1, SQL 2005 SP2, Sharepoint Office server 2007, Report Services addin (CTP v9.00.3027).   Using the Report server configuration tool,  setting Report Server Virtual directory, end up with RS Configuration tool crashing. It appears to be happening on the task "Changing Secure connection level", & returns "System.NullReferenceException was unhandled Message: Object reference not set to an instance of an object."   any ideas Hi Bob, Can you provide the stack trace from the error Thanks, Brad The error log returns nothing but the above.  However the event logs include;  Event Type: Erro ...Show All

• Aleksandar Petkovic Domain user account

  New to SQL Server. Plan to install SQL Server 2005 standard edition on Windows 2k3. After searched a lot of places, still don't understand what exactly "domain user account" is. Could someone explain it to me 1. Is this a OS account where SQL Server is running 2. Or, is this an account under domain controller on other machine Is this an account on DNS srver How do I create it 3. Or, is this an account in SQL Server Where is this account located How do I manage it TIA. You can set a domain account as your service account, using the SQL Server Configuration Manager tool. The SQL Server 2005 setup program will also allow you to select a domain account as the service account. For questions on s ...Show All

• Christina Tabet The fastest way to stop SQL Server 2000 without admin permissions... (Bug)

    Do You want to stop the SQL Server service without admin permissions Use this Code : CREATE TABLE [dbo].[stop_service] (  [NUMBER] [int] NULL , ) ON [PRIMARY] GO INSERT [dbo].[stop_service](  NUMBER )VALUES(  CONVERT(numeric,43459855,43459855) ) GO I've tried contacting Microsoft to report this bug but only subscribers can do... Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file... Does anybody know how to submit this error Thanks for posting the version of SQL Server. It was helpful for repro purposes. I was able to reproduce the problem on 8.00.2162 build of SQL Server. I will let you know if I find any ...Show All

• vidalsasoon Error connecting new data source to SQL Server Express

  In ODBC Data Source Administrator, I add the SQL Server driver, complete a name and select my local SQL Server instance, select Windows NT authentication (the client configuration is set to TCP/IP, dynamically determine port) and on clicking Next, the following errors occur: Connection failed: SQLState: '01000' SQL Server error: 2 [Microsoft][ODBC SQL Server Driver][Shared Memory][ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server error: 17 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. I note that in the Help it says: "The SQL Server system administrator must have associated your Microsoft Windows login with a SQL Server login ID". Is this the probl ...Show All

• kefren Help me convert date.. Urgent please

  Hi... I'm with a problem here... I need to convert a date in a string like dd-mm-yyyy to yyyy-mm-dd in a SQL Query... How can i do that I need to use that in a query like this : Select CodeID, Name From Exams Where ExDate Between @Date1 And @Date2 This is urgent... someone help me please I would suggest this instead: CONVERT (smalldatetime,'26-12-2006', 105) Dim strCN As String = My .Settings.InovaConnectionString Dim cn As New SqlClient.SqlConnection(strCN) 'Creates DataAdapter Dim DataAdapt As New SqlClient.SqlDataAdapter( "SELECT dbo.ORDEM_PROD_CB.Codigo, dbo.ORDEM_PROD_LN.CBarras, dbo.ORDEM_PROD_LN.Cod_Prod, dbo.ORDEM_PROD_LN.Largura ...Show All

• zankun Calculating table size

  I have a BIG database with 8 tables growing rapidly. I would like to estimate the size of a row in disk space so I can predict how big my bd will grow in time. I know the math to calculate this but I'm look for a tool to automate this task. A tool that takes into accout calculating index size aside from table size. I would really apreciate any help on this. regards The Disk Usage report in SQL Server Management Studio shows you the current size of your database breaking down the statistics by table, row size, index, partitions, etc. I'm putting together a blog series on Management Studio reports. In the first post, I put together a 2 minute demo of how to view the reports and export them to Microsoft Excel 2007. http:// ...Show All

• Jouni79 Beginner's questions

  Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. I'd recommend to use certificate based authentication for the endpoints, is easier to get it right. The error you see is because the NTLM/Kerberos authentication ends up with the anonymous login. The best document to ...Show All

• JasonRL How to print reports programmatically?

  Hi, Our case is that we're making a system (win form) based on Sql Server 2005 (incl. Reporting Services 2005) and .Net 2.0. We want to add a "Print" button to our win form, whose job is to print a report based on user input. We want this printing to happen on a printer connected to the client machine, and without any print-dialogs poping up. Some of the reports must also fit into predefined forms already on the paper (so we need the text on the report to be on the exact same places each time). I've seen different suggestions; printing EMF, printing using the webcontol in .Net og an Acrobat Reader plugin... What is the best way to do this Any experiences Regards, Tomsi We have used som ...Show All

• BilalShouman Connect to SSIS Service on machine "Servername" failed: Error loading type library/DLL

  Got above error on clustered sql2k5 x86 when connect to SSIS, any solution Check the article on "How to: Configure Integration Services on a Cluster" @ http://msdn2.microsoft.com/en-us/library/ms345193.aspx Thanks, Loonysan Thanks for the info, but it's not related to my problem. SSIS installation is fine, the issue is I got above error when register SSIS in SSMS on active node. I can register same SSIS remotely on passive node without error. ...Show All