Common Criteria certification SQL Server 2005 SP2 DataBase Engine Enterprise Edition (32 bit) is currently in CC evlauation at the German evaluation lab, TUViT. It is listed as 'in evaluation' at the BSI (the certifying agency of th German governmet) web site. It is being evaluated at EAL4+. Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Triggers Error Handling in MS-SQL Server 2000 Thanx Arnie for your reply. Actually i'm trying to insert a record in another table "MySecondTable" from the context of a trigger on another table " MyTest". The problem is that when a null violation occures while inserting a record into "MySecondTable", I was not able to catch that exception from the calling trigger, as if the control doesn't return back to the trigger. Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

How to debug the customer data provider? Hello,
I am doing a customer data provider dataextension such as FsiDataExtension.
But I want to know how to debug it
Thank you.
Jeffers Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

unable to add witness to DB mirror error 1456 Not according to the SQL server 2005 web site, and we have had it working before we installed the service packs Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Need some initial direction Following MSDN libraries might be a good start for you to get familiar with Microsoft SQL Server 2005.
http://msdn2.microsoft.com/en-us/library/ms166352.aspx
http://msdn2.microsoft.com/en-us/library/ms188607.aspx
And following articles might be a good start for data warehousing, Architecture and Design.
http://msdn2.microsoft.com/en-us/library/aa226328(SQL.70).aspx
http://msdn2.microsoft.com/en-us/sql/aa336281.aspx
hope this helps. :-)
Thanks Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Checking Linked Server status Is there a quick way to determine linked server availability. I've got some select statements wrapped up in TRY/Catch blocks which will re-direct any failures to retreive data from a linked server to the catch block and I can get my data from elsewhere, but I have to wait for the statement to fail before I can jump into the catch block. I hoped to speed the process up by using an if exists check on the status of the linked server . Is there such a thing as a quick check on whether or not a linked server is online THX Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Implementation of slowly changing dimensions in SSAS 2005 Hi Mosha
Thanks for the response. So am I right in understanding that if a SCD2 is implemented in the data warehouse, we don't need to use the SSAS definitions/features to define the dimension in SSAS as a SCD
Thanks Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

control where the backup.dat goes Hey everyone
I have a question for you, I am creating a database as part of the application that I am currently working one. When I create the database the .mdf and .log files go to the Sql directory however the .backup.dat file goes in my application folder. Is there anyway to disable this or have those files be elsewhere programatically.
Thanks
Kenzie Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Charts embedded in table cells HI, I require to place a bar chart or a column chart inside a table in a column. In the second column the corresponding descriptions have to be displayed for each of the data values that has been plotted in the graph. It is required that each of the bar being plotted in the graph should be displayed horizontally in a table row. Is it possible
Please help required on this....... Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Data with 0 values in pie chart I have created one report with expolded pie chart showing data along with labels. The problem is though one of the values in pie chart is 0, it still shows the colour in pie chart. For eg - The chart has two values - 'Yes' or 'No'. Though the value for 'No' is 0, it still displays the colour of 'No' on pie chart. Is it a bug in SSRS Is there any solution
Please let me know!!
Thanks in advance!! Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Where can I execute ActiveX/vbscript? Thank you for your response. If the goal is to eliminate the DTS package, how can this work Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

SQL Browser check for this mmc- C:\Windows\System32\SQLServerManager.msc, sometimes i have seen its not added in Program File -->SQL server Node but its there in this folder.
Madhu Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

file corrupted message on query of restored db hi mobigital,
I'd like know more information about this problem.
1. how big is the compressed backup file
2. what OS(es) are those two machine running Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Export SQL Server 2005 Express to SQL Server 2000 Well, Deepak is right, you will have to use the Import functionality of SQL Server 200 to get the data from the 2k5 to the 2k database. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Alternative to Identity Help. Not really. I opened the SQL Server Management Studio and tried to edit the DTSX package. I couldn't find any of those options you mention in the article. I am not that familiar with SSIS. I just used the wizard to create it. Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Modifying the default website setup (http://(computername)/Reports Actually no, I don't think I'm referring to that. Its talking about using Sharepoint or something to post the reports. I just want to modify the layout and the template look of the reporting site. I'm assuming this can't be done unless I set up an entirely new portal for the reports And if that's the case... then I wouldn't know how to link a new webpage to the existing reports I have published to the default site...
Hmm... so confused. Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Save TextBox to Database as new row? (VB 2005 Express) I have a textbox linked to a DataTable (database). I want to save its text into the database as a new row. What is the VB code The following is not working.
Me.Validate() Me. my DataTableBindingSource.EndEdit() Me. my DataTableTableAdapter.Update(Me.myDatabaseDataSet. my DataTable)
Thanks for any help. Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Is this Code right so what should i do.. All i am trying to do is to split resultset into half so that i can display them in 2 tables.
Can u please help me out. Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Restore without Backup No message in the error log. I do not have backup. Can you explain how to attach the mdf and ldf files after I reinstall Thanks! Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Deploy Report projects at client end. Hi, We are using Microsoft Reporting Service 2005 to develop reports. The reports are pointing to the Analysis Services database. We want to move the report project developed to another machine. Basically we want to deploy the reports at the client end. I have found the below url that mentions the steps for SQL Server 2005 http://support.microsoft.com/kb/842425 Is this the only way to acheive the needed functionality or is there any command line utility available that does this or any other simple procedure to do this
We want to give the client, simple instructions to deploy the report project. Any help would be appreciated. Thanks in advance, Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

Blank Multi-value Parameters Hi Kent,
A multi-value parameter can't be null so COALESCE doesn't work unfortunately.
The way I got around it was by using another parameter:
Code Snippet
WHERE MyCode IN ( @My_Codes2 ) )
OR
@Use_Other_Codes = 1
Klunky but it works.
Thanks,
Darren Tag: Specified cast is not valid - Txn Replication Snapshot Agent Error

MM12345

I have set up transactional replication with immediate updating subscriptions on my test SQL 2005 servers. One of the snapshot agents failed with "Specified cast is not valid" error message. I have created the subscription for that database by initializing it from backup instead. I would like to find out why this snapshot agent is failing and how to fix it.