Answer Questions

• SUPAXE Partitioned View not updatable ???

  Hi There Ok i have searched on this error and seems to be a bug or maybe i am missing something. All i need to know is can this be done or not, am i making a mistake I have created 2 tables. -------------------------------------------------------------- Table_A_Jan ( Col1 int not null, Col2 datetime not null, Col3 char(5) not null, CHECK (DATEPART(mm, Col2) = 1), CONSTRAINT [PK] PRIMARY KEY CLUSTERED ([Col1], [Col2], [Col3]) WITH FILLFACTOR = ...Show All

• CRISTIANO333 Poor performance when looping through table columns

  Hi   Is there a performant way to loop through all columns on a table accessing lots of properties against the table and each column   If I do this on a single table with 100 columns it takes forever! If I look at Profiler this seems to generate 1000s of queries. I have tried using SetDefaultInitFields (as indicated in Michiel Worries FAQs) but while this reduces the number of queries it still generates 100s of queries. ...Show All

• kosmab WMI Event Watcher is not working properly

  Hi, I have an SSIS Package to get the data from an Excel Source. For that I am using WMI Event Watcher to find when the file drops into a specific folder. It is working fine when I check any folders in the local machine. We have a separate WebServer and Database Server for our application. The application is deployed in the Web server and the SSIS package is deployed in the Database server. Since the files are dropped through applicat ...Show All

• R.D. After Install of 2005 still 2000 Engine!

  I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000. I do not know why setup did not upgrade it. What do I need to do now  I think some new options are now working because of that... After ignoring the previous message I got the following:   TITLE: Copy Database Wizard ------------------------------ The server is SQL Server Express. This application wi ...Show All

• Brian Cordell Resources about Load/Run SSIS packages using .NET Remoting.

  Hello, I don't have a specific problem, I'm looking about resources because this is the tipical case when something is working but I don't know why .. On particularly I have to load and run a dtsx package from a window application and the package is located on the server. I decided to use .NET Remoting. I developed my "Remotable Object" which contains: package = Microsoft.SqlServer.Dts.Runtime.Application. LoadFromDtsServer() packag ...Show All

• Oliver Berris Failed SQL 2005 SP1 install

  I have tried several times to install sp1 for SQL 2005. However, I get the same errors everytime. Here is the log that is generated: 04/19/2006 21:45:19.711 ================================================================================ 04/19/2006 21:45:19.711 Hotfix package launched 04/19/2006 21:45:20.508 Product discovery successfully completed during the install process for MSSQLSERVER 04/19/2006 21:45:20.508 SP Level check successfully ...Show All

• wolfkrow Backup of databases within SQL Server 2005 Express

  Hi there! Is there any replacement for the missing SQL Server Agent which could be configured to backup "all databases" and fix minor errors in databases, rebuild indexes, etc. Or let's better ask: is there any solution/tool out there to create and execute maintenance plans without the need of SQL Server Agent (It might be a simple tool that enumerates the DBs and executes some T-SQL statements on them) Thanks Jochen ...Show All

• PPrabhu.NET Indexing questions

  Conceptual questions here...In BOL it mentions 'Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified.'. I'm wondering how this works as non-clustered indexes are built on top of clustered ones - is there in this case a significant slowdown in the speed of accessing non-clustered indexes Also, I'm guessing here, but is the reason this might be useful is for when you want to disable and ...Show All

• dognardo Report Designer for Reporting Services

  Sorry if this is well known now but... If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003 Is there some form of report designer It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed. Regards Graham Is it possible to host the Report Designer in a custom ...Show All

• Raba21 Support for Forms Authentication with Reporting Services

  We are preparing to upgrade to SQL Server 2005. We want to implement Forms Authentication for Reporting Services. I read somewhere that to implement Forms Authentication for Reporting Services 2000 required the Enterprise Edition of the software. Is the same true for SQL Server 2005 or can we implement Forms Authentication with the standard edition I looked at the edition comparison chart on the Microsoft website but it wasn't clear. Thanks in ...Show All

• JKay Issue installing SQL Server Express on Visual Studio Beta 2

  Hi, I have installed VS 2005 Beta 2 (Team System) using a DVD available from MS TEch Ed. This also installs SQL Server 2005 Express edition along with other tools. This installation is done on a vpc. However when I try to install SQL Server Express Manager over this installation, I get "The installer package could not be opened. Contact the vendor to make sure to verify that the Windows installer package is valid". Is there a solution to get thi ...Show All

• Paulius Transfer SQL Server Objects Task doesn't work with schemas

  The task has a fault if you try to copy a table with a schema like [test].[table1] The error says Error: 0xC002F363 at Flyt til DM, Transfer SQL Server Objects Task: Table "table1" does not exist at the source. Even though i just selected it from the table list minutes before. Actually the transfer is between a SQL2005 and SQL2005 database! I think the ...Show All

• Jan Heppen SP1 Database Services failed to install

  Database services upgrade installation keeps failing when I try to install SP1 on a SQL 2005 Developer edition. This is the log: 04/28/2006 10:35:44.081 Failed to read registry key: PendingFileRenameOperations 04/28/2006 10:35:44.097 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll 04/28/2006 10:35:44.144 Failed to read associated hotfix build i ...Show All

• Denis Beuermann Feedback on CTEs

  When I first saw this feature I though "Yeah, that's a nice-to-have" Now that I'm actually using them for real my opinion has changed to "WOW. These solve SO many problems that I couldn't have solved otherwise". Specifically I'm using them to navigate hierarchies (which is of course what they are for). Kudos to the SQL Server team, and thanks very much!! -Jamie Add me to the List ;) This saves me from writing my own set based hierarc ...Show All

• Michael Nelson Can't modify the UDFs I create

  I am logged in using an account that is dbo on this database. I created a new UDF, which works fine (I can execute it). When I right click on it in the object explorer and select modify, it says: Property AnsiNullStatus not available for UserDefinedFunction '[dbo].[fn_MVParamV]'. This property may not exists for this object or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) I would think that if I had the ...Show All