SQL Server

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

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.

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.

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

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

Show the table field on vb.net form

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

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!

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

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

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

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

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

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 to do this? It's not...

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

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.

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

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

Adding processor to SQL Server 2005

Hi All, We are about to add an additional processor to one of our SQL Server 2005, just wondering if there are any downside to doing this and if this a low risk task to do, i.e. we won't encounter any problem after doing this? Thanks.

Backing up SQL Server 2008 databases to a tape drive

I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

Using SQL Connect Statement in SQLRPGLE

I need to use the SQL CONNECT statement within a SQLRPGLE program to connect from one AS400 system to another. I need to get data from one file to another. Does anyone know how to do this? Can it be done within a program. I have no trouble when I do it on an SQL command line... I use CONNECT to...