Assigning access to SQL Server Integration Services (SSIS) packages
How do we assign access for users to SQL Server Integration Services (SSIS) packages?
View Answer
| Jul 3 2008 6:19 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SSIS, User Access
Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory
I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always...
View Answer
| Jul 3 2008 6:16 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Memory, SQL Server performance
Slowdown on a server running SQL Server 2000 and Windows Server 2003
I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server's specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus ...
View Answer
| Jul 3 2008 6:13 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Windows Server 2003, SQL Server performance
Using a .bak file with SQL Server 7
I currently use SQL Server 7, and I have a .bak file downloaded. Can you direct me on how to open this .bak file and how to convert it to allow usage with SQL Server 7?
View Answer
| Jul 3 2008 6:11 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 7, BAK
How SQL Server will work with PerformancePoint Server 2007
Can you explain the basic architecture and operation of PerformancePoint Server 2007, and how it might work with SQL Server?
Answer Question
| Jul 3 2008 6:10 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Servers, PerformancePoint Server 2007
SQL Server 2005 within MS Access VBA
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...
Answer Question
| Jul 3 2008 3:44 PM GMT
| asked by
Rjwilcox
SQL database, SQL Server 2005, Microsoft Access
sql server
what are the diferent versions of sql server
View Answer
| Jul 3 2008 5:22 AM GMT
| asked by
Jideesh
SQL Server
Looking for a database name query in SQL
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?
View Answer
| Jul 2 2008 5:49 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Query, Database
Including a primary key in a nonclustered index in SQL Server 2005
The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?
View Answer
| Jul 2 2008 5:36 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Primary keys, Index
Setting database security to prevent restoring databases on other SQL Servers
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...
View Answer
| Jul 2 2008 5:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Security, Database security
Backing up and restoring a LIVE database in SQL Server 2000
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...
View Answer
| Jul 2 2008 3:52 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Indexes, Database backup and recovery
Network Redeisgn
Hi,I am serving as a system admin for an organization. We have ISA 2004 network, with Exchange 2003 Standard edition server, 2 Microsoft SQL server 2005 Standard edition for database projects, Windows 2003 domain controller in two sites A and B using active directory services. These two sites are...
Answer Question
| Jul 2 2008 11:23 AM GMT
| asked by
NetworkSanjay
Networking, Network design, Network performance
Archiving and Purging Data
We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain...
View Answer
| Jul 2 2008 10:24 AM GMT
| asked by
Roops
SQL Server administration, SQL Server archiving
Slowdown of the SAN due to overusage of temporary tables
We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...
View Answer
| Jul 1 2008 8:23 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SAN, Stored procedures
Finding the total size of databases on SQL Server 2000 and SQL Server 2005
Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?
View Answer
| Jul 1 2008 8:09 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL Server 2005, Database
Sorting hierachy data alphabetically in SQL Server 2005
I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...
Answer Question
| Jul 1 2008 8:02 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Hierarchy data, Sorting
Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message:"Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...
Answer Question
| Jul 1 2008 3:35 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SSIS, Business Intelligence
Migrating data from Oracle 9i Database to SQL Server 2005
I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?
View Answer
| Jul 1 2008 3:29 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Oracle 9i, Data migration
Exporting stored procedure results into an XML file in SQL Server
I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?
View Answer
| Jul 1 2008 3:25 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, XML, Stored procedures
Unable to Restore Backup in SQL Server 2005
I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000.The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _ "...
Answer Question
| Jun 30 2008 7:35 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SQL Server 2000, SQL Server backup
