Hi,
I just installing reporting services for sql2005,now I can see a db call reportserver and reportservertempdb, but not so sure how this both db can be use to integrate with my new reportin...
I am moving an MS Access 2003 SP3 application (.mdb) and an MS SQL Server Standard 2005 Database to a new production machine. The application runs correctly on the old machine.
When I try t...
****THIS ONLY WORKS IN SQL 2005. This is a much better way to generate XML instead of using the UNION ALL approach.
--device_location is the key in both the tables. device_location: 1041644...
Something wrong with using Database Diagrams in SQL Server 2005.
I moved one database from SQL 2000 to SQL 2005. In SQL Server Management Studio, when I clicked "Database Diagrams", I got the...
Hi,,
I'm having an error when trying to backup my SQL 2005 Database:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Backup failed for Server 'DEVBOX'. ...
I have a SQL server @005 database. Build 9.00.3042.00. I also have a client instance of oracle 10g installed on the machine. I want to be sure of the Oracle client version. The DBA at the en...
In SSRS I have a report that tells me when products are due to be renewed in the next 12 months.
I want to conditionally format the rows so that I get the following:
If the renewal is du...
Here's the setup:
SQL Server 2005 x64 (on Windows Server 2003 x64) Clustered Active Passive
IBM DB2 Client x64 (installed on DB Server) version 8.1.14
Linked Server from SS2005 to remote D...
I have two tables in SQL 2005. A user table which we'll call tblUser for this discussion and a record table which we'll call tblRecord. I want to be able to run a query where each user from ...
I just configured the report server on the same sql server the DB sits on. IIS is functioning. When I put http://localhost/ReportServerTest in IE on the local server I get this,
The curre...
We built an website version 3 in ASP.NET 2.0 and we have a My Account login page. The problem is that the first time that you enter the username and password it takes 15-20 seconds to get logg...
Each row in my table has has a unique key. Normally, a user selects a record from a listview and I populate a form with the information. When they want another record, they select another re...
Hello,
I have 2 tables:
Classes (classid)
Teachers (teacher name, classid)
I need to combine them to a view that will show me something like this (| = column divider)
Class|Teacher A|Te...
I have a piece of SQL that I'd like to incorporate into a function on SQL 2005.
The basic SQL is:
---------------------------------------------
SELECT TOP (1) FO.FO_DESC
FROM ...
I have a SQL Report in SQL 2005 that has 2 datasets. The second dataset queries a value that is passed as a parameter to the first dataset. It works well as the main report but when I use it a...
Hi,
I have on windows server with sql server 2005 . I want to have high availibility for sql server 2005. Please let me know if there is any documentation for the mirroring of the database or...
I am trying to move the location of my 'msdb' database. I stopped the Agent service, Analysis service, reporting service and Fulltext service for this instance.
I started up my default ins...
Have a "fmpxmlresult" xml file from FileMaker 8. Would like migrate it to SQL Server 2005.
What is the best way of doing this?
I've been upgrading from SQL 2000 to SQL 2005 which necessitated re-builing the Merge Replication.
I managed to setup every subscription until the last one failed with the above error.
I have the following query that will return employees that are showing Status T but have user accounts that are enabled. I want to count the records that it returns and if there are any send a...
Hello,
I am currently in process of deploying SSRS 2005 reports. Some of the reports need to run on a periodical basis and are thus subscribed for delivery. When subscribing a report for Em...
Using VB.NET 2005, talking to SQL Server 2005 using a stored procedure, I am having a heck of a time trying to give an official NULL to the database whenever a user has not entered a particula...
I have an ssis package that imports data from an access database into a SQL 2005 data base. It provides a very detailes on-screen display of all status messages. Is there a way to save this ...
what type of lock sql 2005 hold during backup to the disk ? if a read lock is held on prevous night's dump file thru network backup program, can sql 2005 start it's backup or have to wait till...
Hi,
I'm thinking of how do I migrate the system db (msdb) from sql200 to sql2005 I try with copy database wizard in sql2005 but there is no option for me to copy or transfer the db, and one m...
