Answer Questions

• Muhammad Azeem Azam exporting more tha 65k rows to excel

  hi all, I wanted to know how to export a report that returns more than 65,000 rows of data to MS Excel, it will fail because excel has a limit of 65K records per excel sheet. What i want to know if there is some way to use multiple sheets (in the same excel file) to show more than 65K records Eg we have 105K rows of data ...can we export 65K records in the first sheet, and the remaining 40K in the second sheet (of the same excel file) Appreciate the Help, Siddharth Hello Siddharth, Using a Table, you can force an explicit page break after a certain number of rows. Because the Excel renderer creates a new worksheet for every explicit page break, you can use this technique to make sur ...Show All

• Claudiu Chiorean Script jobs for restore to another server

  I want to restore all jobs from one server to another. I seem to remember that in SQL 2000 there was an option to script all jobs but it seems that in 2005 you have to script them 1 at a time. Is there a more efficient way than scripting each job and then executing each script individually Thanks, -Dave you still can. just open the 'summary' window and go to jobs. highlight all the jobs and generate the script. ...Show All

• Asim A SSIS - Cannot debug a script task

  I am unable to step through (in debug mode) a script task. Have set breakpoint on first line of script in VSA. Click Start (in debug mode). Nothing happens. Have also tried to execute task in control flow of visual studio but it will not stop at breakpoint To be clear, do you mean a Script Task or a Script Component The former is the task available in Control Flow, the latter is in the Data Flow. Both are named as above in the toolbox, but people have a habit of using the terms interchangeably which can rather confuse things on here. The Script Task can have breakpoints applied, and the VSA debugger will pick these up and stop as you would expect, displaying the IDE and your code. Exceptions ...Show All

• Ramanujam Sampath Import export wizard

  In sql2k i can select bunch of tables in EM and export to a different db also I can schedule this activity. How to do the same in SQL2K5 Right-click on the database Point to Tasks-->Export Data Go thru the wizard, selecting the tables that you need. You will be prompted to save the resultant SSIS package somewhere. Once you have saved it you can schedule it thru SQL Server Agent. -Jamie ...Show All

• jheddings SQL Server Express Client app login / password

  Help!! I used to have an Access database which had tables for users, roles, actions etc. This was used by a C++ client app (using ADO) which logged in, got the user ID and password (by raising a login dialog ) and then checked these against a user table and then assigned the roles and possible actions. Now we have SWL Server Express 2005 - NT Authorisation - how do I get/pass the user ID to the C++ Application so it can get the associated roles Seems silly to have 2 logins. Better still can I do away with the App's User table or make its password column invisible to all users bar Admin and the C++ App Hi, if you are using Windows Authentication you can use role based security which enable ...Show All

• Denis Pitcher Server: Msg 18452

  Hello, I hope that anyone can help me. I'm getting the following message, when I try to logon to a SQL SERVER 2000/2005 via Windows authentication. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Server: Msg 18452 The SQL Servers were working fine with Windows authentication for a year or so. But now every day a new server starts to get that Problem. If I disable the TCP/IP Protokol in the SQL Server Networkkonfig. (and just leave Named Pipes) everything works fine again.... (Sometimes it helps to take the server out of the domain and back in again - but only for a couple of days/hours) Does anybody got and idea Hi, there are lots of applications running. Bu ...Show All

• Daniel Hawkins NET_ADDRESS in the master.dbo.sysprocesses table

  Does anyone knows how the field NET_ADDRESS in the master.dbo.sysprocesses table is encoded May I extract the IP address or MAC address from that field Just ran it on my own computer. NET_ADDRESS is the MAC address of my network card. The only way I know to correlate this to an IP address would be to somehow get it from the DHCP server. As I understand it, the only computer name/ip address in SQL Server is HOSTNAME and that's voluntarily provided by the client and the client can make up any name it wants. 1) If the net_Address starts with 00 the program which opened the connection is running in a simple environment or is a regular connection. If you have letter is ...Show All

• Eusebiu Smart Aggregation

  I'm having problems implementing the following in reporting services 2005. My hierarchy looks like this (just to illustrate the problem...): University->Student->Exam My query returns the following fields: University,Student,StudentPayment,ExamName,ExamScore I need to create a report that will show the hierarchy and to smartly aggregate the StudentPayment to both the Student and the University levels. The problem is that the StudentPayment field is being multiplied by the number of exams in the upper level aggregation. If only I could set the granularity level of the StudentPayment measurement... Note that I don't have access to the query, so I can't change anything on that front. Thanks, Efi ...Show All

• Tadwick HTTP ENDPPOINTS

  I keep getting this error when trying to create one: This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server. I am running sbs2003 r2. Is this not supported on this server SQL 2005. It's acting like those procedures or something does not exist That would be strange. Could you please execute the SQL statement SELECT @@VERSION on the server and post the results Regards, Uwa. What version of SQL Server are you running against The CREATE ENDPOINT statement is supported on SQL Server 2005. Regards, Uwa. ...Show All

• Quiztar Exam 70–443 (MCITP)

  Hi, Somebody can speak (tips) about exam Exam 70–443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Tips Amount Questions Time :-) you know we can only recommend official stuff here. http://www.microsoft.com/learning/exams/70-443.asp ... also the book and the practice tests will give you a better idea of what to expect in the exam which is worth gold. all i can say is buy the 70-443 study guide book from amazon and signup for the practice test on www.measureup.com best way i think, the book will give you a voucher for 15% off when you sit the exam and if you signup to the newsletter from www.measureup.com they'll send you a voucher for 25% off their tests (runs january 2007) ...Show All

• chris29 database not in full recovery mode on both partners error:1465

  I have two instances (Source and Destination) on the same server, i did a full backup of a database on the source server, i did a restore on the destination using the NORECOVERY mode, now the database on the destination as green arrow saying "restoring". From the source database i set up the mirroring, i'm using port 5022 on source and 5023 on destination, everything seems to connect fine but when i start mirroring i get the error message "Database mirroring cannot be enabled because the database is not full recovery error: 1465" but when i look at the property of the db on the source the recovery model shows full as so the destination Look at the columns recovery_model and recovery_m ...Show All

• Proxima Splitting PDF documents

  This may be a stupid question but I'll throw it out here, is it possible to use sql 2005 to split up pdf files into individual files by a field on the form or an index Thanks. I took a different route. ...Show All

• Programm3r A problem in memory when I run sp with a large number of records !

  I will describe my problem and I hope that you will help me to find the way to solve it ! My task is how to find the "similiar" words in our database ! Now, I have to use my software to find the similiar name. For example : The name : "Donaldson Filtration Slovensko s.r." and the name : "PENTA Slovensko Donaldsin spol. sro" are "similiar". In that case : the word "Donaldson" and "Donaldsin" can be called similiar because they are diffrence not more one character in the same positon in the string. I used stored procedure to sovle this problem because it is a larg number of records in each table (for over 1 million records for each table). The way I had used first is ...Show All

• KLJ Cannot see the cube using Crystal Analysis 9

  Hi, I'm currently using SQL 2000 Analysis Manager to create a cube, and Crystal Analysis 9 to try to view the cube. When I grant the role of the cube to "Everyone", there is no problem, CA is able to view the cube. However, when the role is granted to a specific "domain account", the cube is NOT showing up in CA... My settings are: SQL 2000 on one PC, and CA on another PC. Both are under the same domain, and both are logged in using the same domain account. Also, this domain account is already granted the "Administrator" rights in SQL 2000 PC. Any idea why this is happening Anyone ran into this problem too Thanks very much in advance. sendmehere. ...Show All

• oren Subtotal

  Hello, Is there any way to change the formula of SubTotal column that is used in a matrix Imagine that I want to obtain the difference between the values in the columns instead their adition. Is there any place where I can see the code used behind SubTotal column Thanks and best regards. vjn You can write your own aggregation function through custom code and use that instead of the built in stuff i.e. Code.YourFunction(Fields!some_field.Value) rahter than Sum(Fields!some_field.Value) Thanks for answering my question Adam but is there any way to apply the custom code like the SubTotal in a matrix My real problem is described in another thread (http://forums.microsoft.c ...Show All