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',

We have a SQL Server 2005 database that is causing the server to consume
large amounts of memory.  SQL Server has loaded the SCRRUN.DLL several
thousand times, each time it looks like SCRRUN.DLL has allocated a heap while
sharing the code sections.  The sum of these heaps is a ...