Restoring a deleted table in SQL Server 2005
How do I restore a deleted table in SQL Server 2005?

Answer Question   |  July 15, 2009  4:51 PM
SQL Server 2005, SQL Server Management, SQL Server tables

Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?
Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive the following error: TITLE: Analysis Services Processing Task [...]

Answer Question   |  July 6, 2009  4:41 PM
SQL Server 2000, SQL Server 2005, SQL Server Analysis Services, SQL Server Integration Service

SQL Server 2005 Processor Licence
Hi All, Just wondering what happens when an additional licence is purchase for a SQL Server 2005 that is currently running with one processor. IE. How do we purchase the processor licence for our clients, what to do when we purchase this licence? Thanks in advance.

Answer Question   |  July 6, 2009  6:39 AM
Microsoft licensing, Processor Licence, SQL Server 2005, SQL Server licensing

How to delete spaces in charts
Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha

Answer Question   |  July 6, 2009  1:29 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting

Increasing Processors of SQL Server 2005 in VM
Hi, We are about to increase the number of processor on a Virtual Machine from 1 to 2 for one of our clients, will this affect the SQL Server 2005 which installed on the Virtual Machine, just wondering if are any issues to look out for, and if anyone has done this before? Thanks.

Answer Question   |  July 6, 2009  6:12 AM
SQL Server 2005, Virtual Machines

sql server remote server connection
What is the best way to access a sql server in another country using the public ip address? I tried linked server unsuccesfully. Please help. Thanks.

Answer Question   |  July 2, 2009  5:03 AM
Linked SQL Servers, SQL Server Remote Connections

Why is SSIS xml variable in escaped format?
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote marks are escaped [...]

Answer Question   |  July 1, 2009  7:44 PM
SQL, SQL Tasks, SSIS, SSIS 2005, XML

Backup of large amount of data
I need some suggestions on a backup procedure. Here’s what I am backing up to a 3.5 TB fileserver (RAID 5). 200 GB of application and document files from an application server. About 200 GB each on four medical imaging workstations. 100 GB of SQL database files from a SQL Server 100 GB of backed [...]

Answer Question   |  August 25, 2009  6:49 PM
Backup & recovery, Data backup, File servers, NAS, RAID, RAID 5, SQL Database

Show the table field on vb.net form
How can I show table fied on vb.net form.I have used sql2005.

Answer Question   |  July 1, 2009  2:46 PM
SQL 2005, VB.NET

DTS: Export to Excel
I’m exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

Answer Question   |  July 3, 2009  7:55 PM
ActiveX, DTS, DTS Import/Export Wizard, Microsoft Excel

How do I get the value of a lookup field stored in nvarchar field
I have a list with a lookup field which is being stored in an nvarchar column. I’m trying to access the value in a Sql Server query, but what comes back is this: ↓ ъ䅃㒳ꅉ I’ve tried converting this column to every data type there is, and no success. Please help!! Thanks…

Answer Question   |  July 1, 2009  3:56 PM
NVARCHAR, SharePoint, SQL Server, SQL Server Query

Convert column from Number(9) to varchar2(3) in SQL
What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ….

Answer Question   |  July 1, 2009  2:26 PM
SQL, SQL tables, VARCHAR

Problem with Download-only Articles in New Subscription of Merge Replication
Hi, I have a Publication in a SQL Server 2005 Merge Replication with Mobile Devices. To explain my problem follow this example: I have an Article in Download-Only with 100 rows. When I start new subscription I look, in the Replication Monitor, that Process start with “Insert 300 rows” for this article and end with [...]

Answer Question   |  June 29, 2009  3:38 PM
Merge replication, SQL Server 2005, SQL Server 2005 merge replication

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 [...]

Answer Question   |  June 29, 2009  5:40 AM
SQL 2005, SQL Express 2005, SQL Server 2005, SQL Server Express

Field in crystal reports duplicating lines from quote
Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database. This is hard to describe accurately but here goes… I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes. QUOTE_Binary_to_notes is a view in the DB: CREATE VIEW dbo.[Quote Binary to Notes] AS [...]

Answer Question   |  July 15, 2009  6:01 PM
Crystal Reports, Crystal Reports XI, SQL Server 2000, Visual Manufacturing, Windows XP

Software to automate backups for SQL Server 2008 databases
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up [...]

Answer Question   |  June 29, 2009  4:44 PM
Automated backup, Backup & recovery, Backup software, SQL managment Studio, SQL Server 2008, SQL Server backup, SQL Server backup and restore, SQL Server Management Studio

dynamic temporary table variable usage
We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can’t resolve the problem. It occurs after the INNER JOIN on the [$Temp_Final_IDlist] temp table. It appears as if [...]

Answer Question   |  June 25, 2009  7:53 PM
Dynamic SQL, INNER JOIN, SQL tables, SQL variables

Migrate User & Permissions SQL 2000 to SQL XXXX
Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

Answer Question   |  June 25, 2009  4:26 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005

Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left [...]

Answer Question   |  June 25, 2009  4:23 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring

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

Answer Question   |  June 25, 2009  3:57 PM
Database Backup, Database backup and recovery, Database maintenance, SQL 2005