| Thread | Last Post | Replies |
|
| OPENROWSET & ERROR | 03 Jun 2008 17:46 GMT | 4 |
While running the below query using openrowset function on SQL 2005 machine.. I am getting the below error.. Query.. ---
|
| check columnname in list gets an error | 03 Jun 2008 17:36 GMT | 3 |
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](
|
| indexing | 03 Jun 2008 16:52 GMT | 6 |
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 ...
|
| [newbie] function question | 03 Jun 2008 16:36 GMT | 3 |
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
> execute issameday getdate, getdate |
| Query | 03 Jun 2008 16:25 GMT | 4 |
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
|
| export to excel | 03 Jun 2008 16:15 GMT | 2 |
hi, i want to make a query and export it to an excel datasheet, how can i do that? thanks in advance! gabriel
|
| sql server disaster recovery | 03 Jun 2008 13:56 GMT | 1 |
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
|
| Number of SQL Server 2005 licenses required? | 03 Jun 2008 11:35 GMT | 1 |
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
|
| Why can't shrink the unused space of data file | 03 Jun 2008 10:33 GMT | 1 |
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' ...
|
| Using filegroups to simplify Dev/QA Refresh | 03 Jun 2008 09:24 GMT | 5 |
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
|
| convert MySQL create query to T-SQL create query | 03 Jun 2008 09:21 GMT | 9 |
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
|
| Help... | 03 Jun 2008 09:08 GMT | 3 |
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,
|
| Copy SQL 2005 database.. different servers.. network storage | 03 Jun 2008 08:57 GMT | 5 |
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..
|
| Problem when set up a linked server to access a secured Microsoft Access database | 03 Jun 2008 02:20 GMT | 2 |
I've problem setting up a linked server to access a secured Microsoft Access database, here is the script exec sp_addlinkedserver @server='AccessDb',
|
| Finding memory leak in SQL Server | 03 Jun 2008 00:24 GMT | 2 |
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 ...
|