Answer Questions

• billg51 Configuring an Active\Active cluster memory question

  Hey. I've 2 nodes in this active\active cluster. Both of them have 20gb memory. Right now, both are configured to use 12gb each. Is that the right way to configure it I was thinking we'll have IO issues if we eevr failed over to a server. Thank you. ...Show All

• ShaneShowers Can we add templates to SSRS?

  Hi. Is it possible to add a custom template to SSRS for new reports We'd like to create a template that has our logo and colors. Can you point me to a tutorial on this Your help is much appreciated. Yes, it is possible. For more details, check out this blog entry: http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx ...Show All

• Maranello Object Explorer - Group By Schema?

  Hello all, I'm new to SQL Server Management Studio and was wondering if anyone knew of a way to group by schema's under the Tables node in the Object Explorer. I know you can use a filter to show just the schema you want, but it would be nice if there was a way to have the schema's themselves show as a node which could be expanded. If anyone knows of a way or a plug-in, it would be greatly appreciated. I'm running SQL Server 2005 Enterprise (64-bit) with SP1. Cheers, Corey Thanks to all who responded. I'll report this as a potential enhancement or add in to future releases. The tables under the Table node in Object Explorer are actually shown in sorted order of [Schema ...Show All

• Anjo Gasa Problem with Managment studio Expres

  Hello all, I have a problem during creating new database in SQL Managment studio express.When I click to "Create new Database" is displayed this message : =================================== Cannot show requested dialog. =================================== The type initializer for '<Module>' threw an exception. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Program Location: at Microsoft.SqlServer.Management.Common.ExecuteBatch.GetStatements(String sqlCommand) at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCom ...Show All

• Rajesh Kumar J SSIS Package failing in SQL Agent only

  Hi, I have an SSIS package that contains a single data-flow task: Exporting from a SQL Server table to a tab-delimited text file. When I run the package in BIDS or within SQL Server it runs fine, but if I try to run it from within a SQL Agent Job it fails. The step contains the following Command Line configuration:  /DTS "\File System\GfKLoad1" /SERVER "SCSRV-DR2" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF When I run dtexec from a command prompt with that argument it works. Maybe because the package writes to a text file there are permission issues Any help is appreciated. I am getting the same error and cannot manage to get around it. I have a job that simply imports data from an Inf ...Show All

• AtomZ .be SQL Service Broker - Transport security

  If all my SQL Server instances are mutually trusted, am planning to implement transport layer security with Windows authentication. My query is that if I'm using Windows authentication do I need certificates to be created Though I am using Transport security, I can achieve encryption by ENCRYPTION - ON in the Begin Dialogue conversation. I assume Message integrity using MD5 signatures are by default provided by Service broker irrespective of whichever service options we choose Can I have some article references on how these security mechanisms will impact the performace of Service broker communications Thanks a lot, Transport encryption is needed if you want to encrypt every little byte of ...Show All

• Bilal Haidar - MVP Analysis Services SP4 problems

  Hello I hope someone can help me. On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application." The Cubes can be browsed via Excel though an ...Show All

• Darkside CPU and Duration don't match in SQL Server Profiler

  Hello All, I have one store proc that is really slowing down my SQL server, at least according to the SQL Profiler. When I run the profiler and choose to show store procs that take longer then 3000 ms to execute, this is the only precedure that shows up. The CPU time and Duration is both in the 3000 ms mark. When I open up Query Analyzer and run that same store proc it takes less then a second, but when I check the Profiler to see the time, it's Blank (yellow) .. I'm using SQL 2005 Profiler. Any ideas why 1. I don't see a time when I execute the query from the profiler 2. It says it takes 3 seconds when I only see it taking less then one Thank you This is probably 3000 microseconds (3 milliseconds) :) "In SQL Se ...Show All

• Michael Vanhoutte Is there a performance hit if I run with a db on compatibility level 80 in sql server 2005?

  The database in the sql 2005 test environment is running quicker than in the prod of sql server 2000 (same server setups) with compatibility level 90 but due to some programming bugs we will need to go back to level 80. Is there a performance hit if I run with a db on compatibility level 80 in sql server 2005 Thanks, Vin I was told this by someone : You may see some difference depends on the usage... When you change cmpt to 8.0, sql engine has to be changed...new sql engine features will not work.. http://msdn2.microsoft.com/en-us/library/ms143359.aspx In my experience with actual benchmarks, I have not seen a perf ...Show All

• Bianca_it SQL 2005 training - suggest best provider to train on site

  Hi, our company is looking for a good training for SQL server 2005. Majority of attendies will be .NET developers, but some will be technicians who need backup, replication, maint., etc. training. All are pretty familiar with sql server and have experience with SQL 2000. So, it should not be for beginners. Intermediate and advance topics. Whom you can suggest Do you have experience with them Thank you. Victor     Try www.sqlsoft.com .  They have classes at the Redmond campus and MS sends some of there people to talk classes from them.  I had a great reporting services class with them. Learning Tree is excellent for onsite training as is Training By ROI, INC. Go ...Show All

• Javad Khadivi SQL 2005 Server DDL Trigger Errors

  Greetings! I've been working on a SQL 2005 project, and have really been excited about the new DDL triggers. I managed to implement some database-level DDL triggers successfully. However, I keep getting an error when I try to create a server-level DDL trigger. For several of the event groups, I keep getting the following error: Msg 1082, Level 15, State 1, Procedure tr_Server_Audit_Security, Line 44 "DROP_SERVER_ROLE_MEMBER" does not support synchronous trigger registration. I can't figure this one out for the life of me. Here's a sample of the trigger I'm trying to create (BTW, this code works for database triggers, with some slight mods of course): create trigger tr_Server_Audit_Security on all server  for drop_server_role ...Show All

• komomomo Bulk insert error

  Hi, I am using bulk insert to insert a lot of information from file to memory. In many cases it do the work but in one place it gives me the exception. My code: BULK INSERT tblCompVSNet1 FROM 'E:\EasySeries\WindowsApplication1\bin\Debug\tblCompVSNet1.tbl' WITH ( FIELDTERMINATOR = '|',ROWTERMINATOR = '|',LASTROW = 0,ROWS_PER_BATCH = 10000,CODEPAGE = 'RAW',TABLOCK) The error: Invalid object name 'tblCompVSNet1' The table exists and the query works fine in query analyzer but in code through OLEDB it doesn't work sometimes. How can I solve my problem Thank's Alexei Hi, I have 2 problems: 1. I can't use bcp becouse I don't know where the bcp is. 2. When I use. It doesn't work and give the same error. ...Show All

• Helio Gomes Getting "Permission denied" error in ExecuteSQL task

  The purpose of the Package is to load an SQL table with data from text files in a subdirectory. The parameter is parsed from the text filenames. It is a zipcode. I have an ExecuteSQL task inside a ForEach container. The SQL in the task is: IF EXISTS (SELECT * FROM dbo.ZipCodeRadius WHERE CenterPostalCode = 1) BEGIN DELETE FROM dbo.ZipCodeRadius WHERE CenterPostalCode = 1 END I also have a Data Flow task in this container which populates the ZipCodeRadius table. The same parameter is also passed to the Data Flow task which specifies a zipcode to delete and afterward load. I am using Windows authetication for the package. What am I doing wrong Fred The database in on my workstation and I am ...Show All

• OMJAI Passing a schema to a cube via AMO

  I'm having a problem passing the Schema name to the cube when building it using AMO. Oh, i'm using SQL Server 2k5. When i build the cube through Dev Studio, it will process dimensions as expected. So, when pulling data, i can look at the SQL and see (for example): "Select blah from Schema.TableName" Which is what i want. However, when i build the cube using AMO i can not process the dimension, and it's failing because the SQL reads: "Select blah from TableName" A quick fix for me is to remove the Schema from my tables.. so, dbo.TableName works fine. But that's not exactly what i want. Or, i can create stored procs that pull the data from any table/schema, but that's not what i want either.. So, i guess i'm asking if th ...Show All

• yonderstar JDBC for Sql Server Analysis Services 2005

  Is there any way to access Sql Server Analysis Services 2005 via JDBC I do not know of anyway of doing this with our JDBC driver. ...Show All