I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the...
What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change? Software/Hardware used: SQL 2005 SP3
I starting using a new laptop and checked all my sql settings however when I run the same script on my old laptop and new laptop and save to file as text, the data is exactly the same but it is much larger on my new laptop. What setting am I missing on my new laptop? I already save with Encording...
How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls. ...
How do I grant users rights to run reports on reporting services? Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source. When setting up the source, we used windows authentication. I've given clearance on...
SQL 2005, Reporting Services 2005, Microsoft SQL Reporting Services
Hello i am using SQL 2005 and i have Tomcat as an Application Server i want to use Mirroring on my DB and i am looking for the way that let me make Tomcat as my Witness server [Br class="height5" /][small] [/small] Software/Hardware used: Tomcat, SQl 2005
I've got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then...
Hi, I'm new to the whole SQL experience and need help converting some data. In our Activity table, data was imported into the UF_4 field incorrectly. We want to convert this data "from a Decimal format" to a “NonDecimal”. Currently the data looks like 5234.000 and we want it to look like...
Can I get a detailed information on what are the possible things we can do to identify the performance issues? I had run the SQL 2005 profiler against load test for about 2hrs and captured all the trace. I could see the procedure that runs for various different parameters was consistently taking...
We have a small but critical application that is accessed by about 30 - 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC...
How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday
If you move a sql 2000 database to sql 2005 which admin password does it have now.
Hi, I recently applied Service Pack 3 to SQL2005 64 bit and my server performance has been very slow since. The statistics have been updated on my databases, but that has not made a difference. Has anyone else experienced such behaviour post SP3 install? Thanks, Lakshmi
How do I change the default location for database and log files during a SQL 2005 installation?
I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The...
What considerations and procedures should be followed when renaming a Windows server that is hosting SQL 2005? Previous testing has shown considerable applicaiton problems after a system rename. Thanks for the guidance.
in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in...
Can i access the sql2005 mirrored db via crystal reports for reporting
I’m setting up a virtual machine -- SQL 2005 install -- and I want to make a separate drive for the logs and one for the data, but as this is a virtual environment using the same mirrored physical disk, is that advisable?


