i became a bit confused with a length of data stored in varchar datatype.
When ansi_padding is on (which is default), column is padded with trailing
spaces - BOL. However, datalength() function does not show it.
And if that's true (padding with spaces), it makes it equivalent to ...

While running the below query using openrowset function on SQL 2005
machine.. I am getting the below error..
Query..
---

I have something wrong in the syntax and it doesn't compile in query
analyzer on the line with the comment.  I'm trying to create a boolean
list:
CREATE TABLE[INTERNALXL_categories](

I have a table (included below) with a Primary Key clustered index on the ID
column, and several non clustered indexes on the MSH_DateTime and
MSH_SendingFacility and PID_PatientAccountNumber (and other) columns.
I am selecting back records where the MSH_DateTime column is equal ...

SQL Server 2005. The function below compiles fine. If the two dates
are same return 1 (true) else false.
But the testing gives an type error

Am looking for a query where it will search the complete db for email
address. or a column of some sort to indicate it has email address.  sry have
no clue on how to do this and was hoping someone can help out
thx in advance

hi, i want to make a query and export it to an excel datasheet, how can i do
that?
thanks in advance!
gabriel

How would I restore user databases to a freshly installed system for a
disaster recovery scenario? I am using W2K3 server and SQL server
2005. Also can I restore SQL 2000 server databases unto SQL 2005
server? Thank you, T

I am planning for SQL Server 2005 on a production environment, where I
want to have the Database Engine, Integration Services and Analysis
Services installed on one server (single-processor, could be multi-core
- AFAIK, the number of cores do not require those many

We have a database which data file current size is 3690MB and the space used
is 3566MB. But we know the actual used space is less than 3566MB,we use the
exec sp_MSforeachtable "exec sp_spaceused '?',true" to query this database's
tables used space and found two-three tables' ...

We have a fairly large OLTP database that is undergoing some
significant development.  We are constantly having to run DTS jobs to
replace/refresh data in the Dev and QA databases via DTS.
I have been working with filegroups for another reason and came across

I'm trying to convert a MySQL db to SQL Server. I have the create
table statements imported to the Management STudio Query Analyzer.   I
changed the datatypes to be consistent with SQL Server.   Where it
says ENGINE= , how can I correct the syntax to make it T-SQL code

First,
I din not know where to ask, so, i post my question at here. we have a
production site senario like below.
Our client install our program which include sql server 2005 express,  

Hi..
I have to SQL 2005 Standard Servers (Server1 and Server2)
Everynight I have to program a copy of a DB in Server1 to Server2.. what is
the best way to achieve this??.. DB can't go offline..

I've problem setting up a linked server to access a secured Microsoft
Access database, here is the script
exec sp_addlinkedserver
@server='AccessDb',