passing data between two SQL Server databases
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...
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...
5 pts.
SA Password change for SQL
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
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
sql results to text file
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...
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...
Auto backup configuration in SQL2005
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 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. ...
Grant users rights to run reports on reporting services
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...
View Answer
| Oct 19 2009 3:10 PM GMT
SQL 2005, Reporting Services 2005, Microsoft SQL Reporting Services
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...
View Answer
| Oct 19 2009 3:10 PM GMTSQL 2005, Reporting Services 2005, Microsoft SQL Reporting Services
Can I Use Tomcate as a "Witness" Server in SQL 2005 Mirroring
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
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
Replication Causes Client Application to Hang
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...
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...
Reformatting SQL Data in a Field
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...
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...
Web Application very slow SQL 2005
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...
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...
Which version of SQL will work best?
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...
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...
Deleting Nightly Database Backups (dumps)
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
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
SQL 2005 Password
If you move a sql 2000 database to sql 2005 which admin password does it have now.
If you move a sql 2000 database to sql 2005 which admin password does it have now.
SQL2005 SP3
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
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
Database and Log file location
How do I change the default location for database and log files during a SQL 2005 installation?
How do I change the default location for database and log files during a SQL 2005 installation?
SQL 2005 SSIS Package to load table from positional flat file
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...
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...
Renaming a SQL 2005 server
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.
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.
SQL Server 2005 Select Multiple views or Tables
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...
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...
Reporting and Mirrored SQL2005 DB
Can i access the sql2005 mirrored db via crystal reports for reporting
Can i access the sql2005 mirrored db via crystal reports for reporting
Virtual machine setup - SQL 2005
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?
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?
