SSRS Excel export
Exporting from SSRS is not great, and although you are staying in the microsoft range of products, complications do occur. If you have extra resources you could always splash out and buy an add-on for SSRS that performs exports better such as OfficeWriter from www.softartisans.com which provides much more control over Excel output. From my [...]

View Answer   |  March 23, 2009  4:33 PM
Microsoft Excel, SQL Server reporting, SQL Server Reporting Services, SSRS

How to run SQL script with parameters in CL
Hi, How do you call your script? Can you maybe post a sample of the code? Have you tried running the SQL script interactively? Regards, Martin Gilbert.

View Answer   |  March 23, 2009  10:27 AM
AS/400 Control Language, CL, SQL, SQL scripts, SQL/400

Can I install SQL Server 2005 32-bit on Vista 64-bit?
You can install either the 32bit or 64bit of the developers edition. If you are just installing the client tools don’t bother install the 64bit edition as the client tools are only 32bit.

View Answer   |  March 23, 2009  5:47 AM
64-bit processors, SQL Server 2005, SQL Server 2005 (32-bit), Windows Vista, Windows Vista 64-bit

Database Migration
To migrated a database from one version to another simply backup the database, and restore it to the new server. Then point the client machines to the new machine.

View Answer   |  March 22, 2009  7:29 PM
SQL Server Database Migration

Looking for detailed synchronization logging in SQL Server 2008
You can adjust the amount of logging by changing the OutputVerboseLevel setting in the SQL Agent job which runs the merge agent. <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1337202_mem1,00.html”>This article</a> gives some information about it.

View Answer   |  March 21, 2009  9:29 PM
SQL Server 2000, SQL Server 2008, SQL Server replication, SQL Server synchronization, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2008

How to check Max Worker Threads in SQL Server 2005
This code will show you the min value, max value, config value and running value. The running value is the value which is currently in use. A value of 0 means that SQL Server will dynamically select the number of worker threads to use. This is the default setting. <pre>exec sp_configure ‘show adv’, 1 reconfigure [...]

View Answer   |  March 21, 2009  9:25 PM
Max Worker Threads, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 performance

SQL Server with domain accounts
Yes you will need to be logged into the server with a domain account to be able to access the domain resources. Accounts which are local to the server to not have access to the domain resources and there for can not validate the domain account.

View Answer   |  March 21, 2009  9:12 PM
SQL Server 2005, SQL Server 2008, SQL Server Domain Accounts

IBM System x3400 connectivity
Put them in the same physical network. All you need to do is connect them to the same physical switch. Just in case make sure there are no VLANs. You can access the other server by going to Start -> Run. Type: \IP_Address_of_serverc$ If it prompts for login credentials, use the administrator account on the [...]

View Answer   |  March 21, 2009  7:15 PM
IBM System x3400, SQL Server 2005, SQL Server 2005 connectivity, SQL Server interoperability, Windows interoperability, Windows Server 2003

SQL Server vs Oracle comparison
This <a href=”http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm”>link</a> will give you a good comparison.

View Answer   |  March 21, 2009  6:18 PM
Oracle, Relational databases, SQL Server

Running Microsoft SQL Server on AS/400
I’m not sure if that is supported. The AS400 does have SQL based query capabilities using DB2 or MySQL even. //////////////////// Where were you thinking of running it – on the IFS under LINUX or WINDOWS? There is no way it runs in OS/400. phil

View Answer   |  March 20, 2009  9:53 PM
AS/400 SQL, SQL Server on AS/400

what is the max length for an sql cursor name?
The cursor name is usually VARCHAR(128); however, if the cursor is defined WITH RETURN, the name is limited to VARCHAR(30).

View Answer   |  March 20, 2009  5:51 PM
Cursor Length, Embedded SQL, RPG, SQL Cursors

Using the return value of a SQL Restore script
You can use SQLCMD <b>-b</b> to return a nonzero exit code when the SQL batch fails. You can then check the ERRORLEVEL in the batch to determine if the outcome was succesfull

View Answer   |  March 20, 2009  11:27 AM
SQL Restore, SQL Server, SQLCMD

split column into column
Alternatively, if you want to separate date and time using T-SQL, you can use CONVERT function as follows : Syntax CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Example : CONVERT (VARCHAR(10), dbo.EMPLOYEES.BIRTH_DATE, 103) (Style Code 103 returns date in dd/mm/yyyy format You can see all Style Codes [...]

View Answer   |  March 20, 2009  6:48 AM
Microsoft Excel, SQL Server 2005, SSIS

Hibernate with clob type
Have a look at the following page. Hopefully you will find the answer there. I would recommend to read the “<b>Beware – lots of info on this page outdated!</b>” section first. <a href=”http://www.hibernate.org/56.html”>Using Clobs/Blobs with Oracle and Hibernate</a>

View Answer   |  March 19, 2009  2:55 PM
CLOB, CLOB Problem, Oracle 10g, SQL Exception

New Contest: Win 1 of 3 Xbox 360′s
best of luck to all.

View Answer   |  March 19, 2009  2:01 PM
AS/400, CRM, databse, DataCenter, DataManagement, Development, Exchange, Linux, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows

table row values for column headers
If you are on 2005+, <b><i>one option</i></b> could be to use the PIVOT operator. The following query should provide the desired output <b><i>in this particular case, assuming that there is a fixed number of areas, and only one row exists for each year-quarter-area combination</i></b> (because it needs an aggregation function, and a SUM function is [...]

View Answer   |  March 19, 2009  9:45 AM
SQL, SQL Database, SQL tables

Large DB, low capacity line, resync log-shipping options.
Yes, the upgrade will require that you resend the snap. Setup the replication using a local path for the snapshot (C:something). Make sure that its a folder that each subscriber has available with enough space for the snap. After the snap is created, zip it up (its just text at this point and should compress [...]

View Answer   |  March 18, 2009  9:08 PM
SQL database replication, SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server database

Searching for a T-SQL query to find data from multiple SQL 2005 servers
To access another server using T/SQL you would need to have linked servers setup to each of your SQL Servers. Once you have the linked servers setup to access all the other servers run sp_helpdb remotely on each server. This will return the database name, size and other information about each database on the instance. [...]

View Answer   |  March 18, 2009  9:01 PM
SQL Server 2005, SQL Server Query, T-SQL

Configuring SQL Server to not lock tables when using the SELECT statement
Change the isolation level of your session from READ COMMITTED to READ UNCOMMITTED. In Management Studio click on Tools > Options. Navigate to Query Execution > SQL Server > Advanced. Change the isolation level option there to set it as the default. There is no way to change this setting server wide.

View Answer   |  March 18, 2009  8:58 PM
SELECT statement, SQL Server, SQL Server tables

Storing and retrieving an image in SQL Server 2000
[kccrosser] I have to disagree with mrdenny – using SQL database table fields to store image blobs works quite well, and there are a lot of positive reasons to use this technique – not the least of which is the consistency of the database transactions and backups. As far as how to manipulate the data [...]

View Answer   |  March 18, 2009  8:18 PM
SQL Server 2000, SQL Server Image Store, Visual Basic 6.0