Answer Questions

• Guostong Error 18452 (not associated with a trusted sql server connection)

  Using sql2005 on a Novell network... When attempting to log into Mgt Studio using windows authentication I am getting the error: Error 18452 (not associated with a trusted sql server connection) . I added my domain\userName in sql with no problems and added the account to the sysadmin server role. However, I noticed my credentials on my pc are not listed as domain\userName but rather ComputerName\UserName. I think this is what is causing the problem but I am not sure. Can anyone lend a hand I'd appreciate any help, Thanks. Scott Hi I am having similar issue. When using Management Studio, XP clients can connect using widows authentication but windows 2000 clients cannot connect us ...Show All

• arsonist Confusion over SQL 2005 Standard CPU Support

  I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs). Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs) Thanks, Chris. It's per processor regardless of the number of cores. See the link below. Doug http://download.microsoft.com/d ...Show All

• Adam Oxford SSIS hang

  I sumbit a package A in MSDB in SQL2005 EE server with SP1 by dtexec. Package A called 2 packages B and C in MSDB to do some data flow task. The package A finished successfully in about 2 to 3 mins. Howerver, when I submitted the package A again. Package A hanged. I checked the Activity Monitor and found all related Package A, B, C task is sleeping. I killed the dtexec and then re-submit the package A. Package A finished successfully this time in expected duration. It is strange. Could anyone tell me the reason of hanging Thank you very much. Have you installed the latest hot fixes and service packs Saw similar problems until we had. http://support.microsoft.com/kb/918 ...Show All

• Franco22 Is cube browser available as seperate control for use in winforms app?

  I love the cube browser in SQL Server management studio and would like to use it in a client app. But I don't want to give end users the SQL Server management studio. Is it available as a seperate control or is there another one that would be available to me I have tried the Excel addin for cube analysis but it is not as flexible and a Pivot Table report is pretty static.   Ta Dirc It's actually just a slightly modified OWC pivot table. I agree, it's a little odd to work with. And the properties aren't documented that well. But it's a lot better than having to code it yourself :) Hi, I am also trying to use the OWC ...Show All

• PolkaDance Transaction log growth during Maintenance Plans

  During my maintenance plans every night, my transaction log for a 17GB database grows to about 9.5GB. I am running transaction log backups every 2 hours, and my transaction log stays around 300MB during the day. However, every night when the optimization job runs, this explosive growth occurs. I have the optimizations set to Reorganize data and index pages, changing free space to 10%, and remove unused space from database files to 10%, shrinking when they grow beyond 50MB. This database handles cash register operations which are not active during the maintenance plan. During your reorganization, you are touching many if not most pages in the database. In many cases you may touch the same page more than o ...Show All

• KAAU Does MS have a glossary of terms?

  There are several terms using ms Server that I don't know and cannot find in my books. Does MS provide that, besides BOL where it is difficult to find good explanations or even find definitions thx, Kat ps. would be a nice feature if they don't have it currently. Hi Sam, I marked your answer as not helpful in case anyone else has another answer. I use Wikopedia right now but it isn't specific to MS Products. I'll start keeping a list. Some may be silly to others but I've been out for a couple years and am playing catchup. One that I posted already and believe I understand is: Federated Servers vs Horizontal Partitioning Scan: this means reading the entire table Row by row As I said, some of these are just ea ...Show All

• George Tar MS Access Backend Link issues

  Hi Guys I have attached an access database to my SQL Server 2005 as a backend. But there is a query which does not seem to be working. I have used forms in my access database and the query is as follows select lookup_Staff.staff_name from lookup_staff where (((lookup_staff.team_ID) = Forms!Frm_User!txt_team)) order by Lookup_staff.staff_name Can you guys help with that Thanks Mita Hi Mita It would be really useful if you provide a little more information in the way of error messages etc... Thank, Chris. Do you mean that you are using Access as the front-end, talking to SQL Server 2005 as the back-end Hi Sorry for miscommun ...Show All

• R. Muti Get last record in a SQL database

  Don't know if this is the right SQL section, but... using VBE, how do you SQL for the last record in the database Thanks. > the LAST record entered in the database.... if for example if you > entered 10 records in a new database, how do you fetch #10 - or the LAST > recorded > entered (without indicating 'get the 10th record') Again, SQL Server doesn't keep track of which row is the newest. This is not Access, and you are not stuffing a line of data at the end of a text file. What does your table structure look like Do you have a naturally increasing column (such as IDENTITY, or DATETIME reflecting when the row was created) A Dear Valeriy ...Show All

• Muzero Cannot open database "xx" requested by the login. The login failed.

  Hi, we are running a webapplication, using IIS6, Windows 2003 64 bit in classic Asp. In the asp pages we connect to our SQL server (SQL Server 2005 64bit,windows 2003 64 bit), mirrored on a third sql server (same software setup as the first sql server). The mirroring is without witness. This works perfectly but sometimes we get the following error : Description: [Microsoft][SQL Native Client][SQL Server]Cannot open database "OBJECTS" requested by the login. The login failed. In the logs of sql, we see that the offending connection does not go the principal but to the mirror. Which would cause the problem of course.. The name of the database varies, and there is no consistent error. Most of the time there are no problems (95%), ...Show All

• Charltonn Is there a way to do a bulk migration of DTS structured storage files?

  For a number of excellent reasons, I have exported the DTS packages that need to be migrated to SSIS to structured storage files. However, unlike the migration from a SQL Server source, the wizard doesn't allow a developer to select more than one package at a time. Is there a way to do this in bulk that I am unaware of I sure hope so as I have a couple of hundred to do and it's going to get very old very quickly if I have to do them one at a time! ...Show All

• DavidThi808 Using Server.Transfer to Post report parameters

  Can I use Server.Transfer in an ASP.Net web page to transfer the variables via POST rather than the less secure GET in the URL. I have tried creating a page with form elements with IDs that are the same as the report parameters and using Server.Transfer to send that information to another ASP.Net webpage that has the reporting services control on it linked to the report. You can add the IUSR to the report server permissions with view reports priviledges. You can do this in Report Manager in the Security section. Go to Home\Properties\Security at http://localhost/reports . Have you tried Response.Redirect instead of Server.Transfer I have not tried either the way you are attempting, but my understanding ...Show All

• Gregg Hamilton Mirroring for certain tables from the database in sql 2005

  Can I know is it possible using database mirroring for only certain tables from the database, not for the whole database in sql server 2005. Hopefully able to get any assistance here. Thx alot. Best Regards, Hans oic. thanks for the information. :) Hi Jerry, sorry for bothering you again. Can I ask some questions regarding the connection for the database mirroring. Actually I did post a thread here and hope can get any assistance from you. If can, I prefer to share/discuss the problem for solving this scenario which is the Error 1418 through messenger. Hope to hear from you soon. Thanx a lot and have a nice day, Jerry. Best Regards, Hans ...Show All

• Rolan creating a new database in SQL 2005

  I have been trying to create a new database in SQL 2005 and each time I do so, it brings tables in from other locations. Any suggestions Dave Hi Dave, The model database that Adam referred to will be under "System Databases" in SQL Server Management Studio. The model database acts as a template from which all new databases are based upon, so if you create a new DB and the model db on that server has a bunch of tables (or other objects), these will be created in the new DB as well. If you are created the database with the FOR ATTACH clause, then the new database is not being created from scratch, but rather it is being created by attaching exising data files that will in turn contain db objects such as tables etc ...Show All

• Kerryr Three daily schedules for a single report

  Hi, I have been trying to figure this out for a while. I have a report that should run at 9AM, 12 Noon and 2PM every weekday. Due to the complexity of the report, I'm using snapshots. Since the lowest gap is 2 hours, I currently have it configured to create the snapshot every two hours. Since this is running all day, my servers are taking a lot of strain. In the report manager help, it suggests creating three daily schedules for the report. I cannot find a way to create more than one schedule for a report. Please let me know how I can do this. Any help will be highly appreciated. Thanks, Anand I found it very annoing that RS does not support an END time. But, you can work around this, but it doe ...Show All

• h1 Matrix Report and Drill through key values

  I have created a matrix report that has a drill through report. I send parameters to the drill report from the results displayed and the parameters from the main report that are seleced. My problem is that I can not seem to get the values from a colapsed matrix row. For example. I have a colapsed section for "regular" and "temp" employee headcounts. If I select the "temp" count and pass the value of "Fields!RegTemp.Value" to the drill through report it receives "T" just fine. My problem is when that section is colapse I need to send both "R" and "T" but "Fields!RegTemp.Value" only sends over the first value "R". If I run isarray on it it's coming back ...Show All