Answer Questions

• Kevin Linder Lost SQL 2005 Tables and Stored Procedures

  I converted a program from SQL 2000 to SQL 2005 all went well. I created a number of tables and stored procedures after the conversion. I backed up my .mdf and .idf files. I was having problems with SQL so I uninstalled and re-installed it. Once I re-installed it I could no longer display some tables and files. Since I am the dbo, I think I should be able to access them. There obviously is something I am missing, hopefully not the tables and sps ...Show All

• charlycmx report events

  Are there report events that can trigger code. example: trigger some code to run after a dataset has been refreshed. ...Show All

• MikRos Connect to an NS instance on remote server

  I have Sql Server 2005 and Notification Services on one machine and I am developing a web app on another machine that will be front-end to the NS instance. So far all the examples I've seen for connecting to an instance using NS API assume that Sql Server, Notification Services and the development environment are on the same machine. Is it possible to connect to an instance on a remote machine using NS API If so, how can it b ...Show All

• coolazeem how to populate foreign key in normalizing import?

  I am copying data from one denormalized table to a COUPLE of normalized ones. I am using multicast, following advices from the forum. The problem I have is that the two destination tables (A and B) are sharing a foreign key relationship.Filling in A is no problem, but when I want to fill in B, I don't know how to populate its foreign key, since the multicast doesn't know the corresponding primary key in table A. ...Show All

• RaycX9X Raw File Destination Create Always error

  Hello, I'm having issues with the Raw File Destination and using Create Once/Create Always. First problem we have is that if we have WriteOption="Create Once" when the file is already present then we get a design-time validation error: "Error occurred because the output file already exists and the WriteOption is set to Create Once". To me that doesn't seem right - why should the fact that the file already exists be a problem - it doesn't matter ...Show All

• csheppard Optimization Processing Cube Duration In SSAS 2005

  i need to optimize the duration of processing Cube,Fact table Record Count 100,00,00,00 Recoreds Current Duration Almost 18 hours If any one Know how to Optimize Performance Please advice me The main boost in performance you will get once you partition you cube. Create partitions in your measure group and start processing them in parallel. Please note the partitions are feature of Enterprise edition of SQL Server Analysis Serv ...Show All

• Gentry Bieker How do I register/install an IFilter with an instance of Sql Server?

  Hello, I am wanting to install Adobe's Pdf IFilter v6.0 for use with pdf files stored in the database and to use Full-Text searching on those files. I have been unable to find documentation telling me where I need to install the files, and how I register the IFilter with an instance of Sql Server.  I know I've seen demos showing how to do it, but I have not been able to find them again. Thanks, JoeM Hi Joh ...Show All

• SimonH6804 query to get sql server version information?

  Hi! I'm new to sql and would appreciate it if anyone could show me the query that i need to type to get the server version information - I do not have direct access to the sql database (doing some work on an old website that runs on windows box w/ coldfusion :p) appreciate it! @@version doesn't have a column name by default. If you need to name it for your purposes, try something like this: Select @@version ...Show All

• Andrei Faber INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstr ...Show All

• C.Batt How to current logged windows user name in tsql

  Hello how can i get current logged windows user name in tsql. I know with windows aut it is possible how can i get this when sql auth. Is there any system function or any special codeing required regards Chikuu I think the answer is: you can't (exactly). You might be able to use sysprocesses or dm_exec_requests (or sessions) to determine the computer they were on. Most people implement ...Show All

• rabram Simple Question: Testing an Update Script

  When writing simple update SQL statement, what is the proper way to test the script before committing the changes Is there an easier way than wrapping the script in a TRANSACTION and rolling-back the transaction, like so : BEGIN TRANSACTION -- Do the update UPDATE sometable SET somefield="something" FROM sometable -- Show the changes SELECT somefield FROM sometable ROLLBACK TRANSACTION If you -don’t have a sampl ...Show All

• lle Can't change language in server properties

  Hi I'm running SQL Server 2005 Express SP1 on a Danish PC, and I need to have the server language set to Danish. However, when I want to change the language in server properties (the current language is English (US) using Management Studio Express, I can't - all of the properties on the General page are greyed out. I know that the SQL Server Express SP1 download is available in several languages (Danish not being one of them) - doe ...Show All

• Zoran Simic SQL 2005 SP1 and Peer to Peer Replication

  We are thinking about upgrading to SP1 on all of our database servers. Our servers are running on WIN2K3 Enterprise Edition and we have SQL2005 EE also on these servers. Each server is configured as a distributor and subscriber in a peer to peer topology. The readme on the services pack says to upgrade in a specific order but since all the servers server as a publisher and subscribers how do we do it Has anyone upgraded in this scenario ...Show All

• Me.Chris Cannot in install samples.

  When I try to install the x64 version of the AdventureWorks sample database I get an error indicating that the file is corrupt (data1.cab). Is there another version or somewhere else I can go to download the sample .msi files Currently I am going to http://www.microsoft.com/downloads/details.aspx FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en and downloading SqlServerSamples_x64.msi and AdventureWorksDB_x64.msi. Thank yo ...Show All

• WGParrish view ignoring order by - used to work in sql 2000

  This works fine in  SQL 2000, but not in SQL 2005 I have the following view: CREATE VIEW [dbo] . [viewServicesAll] AS SELECT TOP 100 PERCENT dbo . services . serviceID , dbo . services . serviceDescription , dbo . services . accountCode , dbo . accountCodes . abbrevName FROM dbo . services INNER JOIN dbo . accountCodes ON dbo . services . invoiceAccountCode = dbo . accountCodes . codeID WHERE ( dbo . services . ...Show All