Microsoft SQL Server Administration

SQL CE - Multi-user

arothberg - 21 Apr 2007 11:18 PM - 4 messages

If a SQL CE database is deployed on a file server, is there a way to block the second user from accessing it? (preferrably without the use of a separate "KEEP OUT" file that would be created after the first user accesses ...

Connect to online webhost MS SQL database

Max - 21 Apr 2007 10:50 PM - 2 messages

Hello, I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection, ...

SQL Server Compact Edition - View Support

arothberg - 21 Apr 2007 10:06 PM - 2 messages

Are there plans to add VIEW support to SQL Server Compact Edition? ...

Dumping sql server

John - 21 Apr 2007 4:47 PM - 5 messages

Hi Is there a way to dump all the sql server data into some sort of file that can be imported into a local sql server later? I have used sql server dumper but it is not very stable and crashes during sump. ...

reclaiming image data space

neilsolent - 21 Apr 2007 2:12 PM - 2 messages

Hi Using SQL 2000, I insert the contents of a binary file into an IMAGE column. I notice the .MDF files grows by at least the size of this file. Later I delete the data (I think) by setting the column to NULL. ...

Urgent please help!! Restore failed for Server (Microsoft.SqlServer.Smo)

mhiremath - 21 Apr 2007 9:10 AM - 4 messages

Hi DB Gurus, I have a DB restore problem. I have backed up my SQL sercer 2005 database, unknowingly it has backed it into two media files. Now when I try to restore it including both the media files in order (1-2), the ...

Attach database over the network.

Joao Novo - 21 Apr 2007 8:58 AM - 2 messages

Hello, I have Sql Express installed in one computer and I want to attach a database that is stored in another computer. How can I do that? Thanks ...

OODBMS vs RDBMS

Hassan - 21 Apr 2007 2:01 AM - 4 messages

What applications/cases benefit from OODBMS as opposed to RDBMS. We are considering OODBMS to replace some SQL Server instances but dont really know if we are making the right choice. Can someone just provides pros and cons of both ? ...

SQL Server Small Table Performance Problem

Isaac Alexander - 20 Apr 2007 11:38 PM - 12 messages

I two customers reporting a performance problem. One using SQL Server 2000 and one user SQL Server 2005. I tracked both issues down the a single query as follows: "select count(*) from statustable" This table typically has 0-150 records in it. Never more than that. It ...

Columns on Summary Page of SSMS

Conan Kelly - 20 Apr 2007 6:32 PM - 2 messages

Hello all, The Summary Page In SSMS looking at the tables of a DB in Details view, there are 3 columns: Name, Schema, & Created. Is there any way to select other columns to view? I created a "Notes" property in the Extended Properties of a Table's ...

Default Database?

pbd22 - 20 Apr 2007 4:33 PM - 11 messages

I got the following after trying to connect to SQLEXPRESS from a remote computer: Code: SQLCMD -E -S 192.168.0.10\SQLEXPRESS,2708 1> select * from users 1> go MSG 208, Level 16, State 1, Server DISNYLAND\SQLEXPRESS, Line 1 ...

SQL 2005 - load generator?

Matthew M (UK) - 20 Apr 2007 4:20 PM - 2 messages

Hi, Could someone tell me if a free load generation/simulator exists for SQL 2005? We are doing some power measurements with Intel E5310s and I would really like to give the processor and disks a bit of a run. ...

Multi-user issue

RickBentley - 20 Apr 2007 3:06 PM - 2 messages

I have a medium sized application running on Windows Mobile 5.0 devices. This app was developed in VS 2005 and uses the Microsoft application blocks for data access - running a stored proc. This app has been in use for ...

Restoring Transaction Logs Into Backups of MDF and LDF

cosmasdev - 20 Apr 2007 2:20 PM - 3 messages

Hello, Here's a brief outline of my scenario: I am trying to recover from a database corruption problem. I have a backup of the db's physical MDF and LDF files from before the corruption, but no actual backup (ie bak file). I also have daily ...

RAID 6

Greg Larsen - 20 Apr 2007 2:04 PM - 3 messages

Any comments on using RAID 6 for Data Files for SQL Server? ...

Saving dynamic Management View Information

Greg Larsen - 20 Apr 2007 1:56 PM - 2 messages

Does anyone know how to save dynamic management view information so I can still use some old view info after I stop and restart sql server ...

Cannot delete maintenance plan.

SQLdba - 20 Apr 2007 1:20 PM - 2 messages

Cannot delete a maintenance plan. SQL 2005 patched service pack 2. (That means I was dumb enough to apply service pack 2 immediately and then microsoft release a patch a couple days later because spk2 was broken) The DELETE statement conflicted with the REFERENCE constraint ...

SQL Server 2005 - Checking startup account from TSQL

kunalap - 20 Apr 2007 10:56 AM - 4 messages

Hello, I have a task to list out the startup account being used by SQL 2005 services on a particular server. I have to script this using TSQL. The script should out put all the SQL 2005 services installed on a server ...

non unicode

SB - 20 Apr 2007 7:43 AM - 7 messages

Hi, Is DT_STR Unicode? From SSIS I am using a data conversion component and defining the data type as DT_STR and saving the output in excel file. I am getting an error that 'can not convert from Unicode to non- ...

linked server problem

00ScarlettJohnson - 20 Apr 2007 6:17 AM - 3 messages

I am running trigger with update on a linked server in SQL 2005 SP2. It is running very smooth and when I turn on the firewall, the trigger action is giving error and failed to take action. Is this a Big NO between firewall ...

missing tables

Antonin - 20 Apr 2007 4:52 AM - 8 messages

I upgraded SQL Server 2000 with 2005 Developer. Now, I have only 6 system tables in the master database. All the others disappeared. I need them for running my old stored procedures. Do I have to reinstall 2000 to get back ...

Stored Procedure Error

sharman - 20 Apr 2007 1:42 AM - 3 messages

Hi, I am having a peculiar problem. I have a SQL Server 2000 with 8 databases running on it. If I try to create a Stored Procedure on any of the databases except master I am able to create it without any problem. However, if I try ...

attach vs restore

tshad - 20 Apr 2007 1:02 AM - 5 messages

When moving all yous database to a new server where you install Sql Server, is it better to use detach, copy database to new server than attach it or backup on the old server and restore the backup. I assume that I don't really need to move the Master or do I? ...

Adding Logons

tshad - 20 Apr 2007 12:59 AM - 4 messages

I have transfered databases from one server to another. All my users are showing up in my databases but there is nothing in the "Login Name" column. I tried adding in the user in EM in Logins under the ...

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

Bharath - 20 Apr 2007 12:18 AM - 2 messages

Hi, I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try to expand a data file by 4 GB - it does not report any error. The windows explorer shows the new size. But the enterpise manager and sp_helpdb show the ...

Rebuilding Sql Server 2000 from Backups

tshad - 19 Apr 2007 10:07 PM - 3 messages

I am trying to rebuild our server onto another - which will have the different name. So I expect the best way to handle this is to just do a backup on the old server for each database and then restore them on the new server. ...

SQL Server 2005 Standard Memory Utilization

David - 19 Apr 2007 9:44 PM - 2 messages

How can we maximize our SQL Server memory utilization? Our environment: Windows Server 2003 Standard SP1 SQL Server Standard 9.00.3042.00 4GB RAM boot.ini: /3GB /PAE SQL Server Max Memory setting: 3072 SQL Service user 'Lock Pages in Memory' ON ...

At what point is schema information loaded?

dduv - 19 Apr 2007 8:58 PM - 8 messages

I am hoping that someone with a good knowledge of the internals of SQLServer will be able to help with the following - admittedly bizarre - question (assume SQLServer 2000 throughout): We have two SQLServer databases, dbmain and dbslave. An application calls stored procedures in dbmain, some of which in turn access tables ...

SQL Server 2005 Standard Memory Utilization?

David - 19 Apr 2007 8:55 PM - 2 messages

Let me ask a question: We have: Microsoft Windows Server 2003 Standard SP1 Microsoft SQL Server Standard Edition 9.00.3042.00 4GB of RAM What is the maximum amount of RAM SQL Server can use? Using boot.ini of /3GB /PAE ...

SQL Server 2000 Log Shipping (Test Disaster Recovery)

Joe K. - 19 Apr 2007 8:08 PM - 2 messages

I have SQL Server 2000 Log Shipping set up, transaction logs will be created every 30 minutes and send to the standby database every 30 minutes. The standby database is Read-Only mode. I would like to test Disaster Recovery. ...

Backup Wizard 2005 Standard

Todd - 19 Apr 2007 7:40 PM - 3 messages

I have a new installation of SQL 2005 standard and I cannot create an automatic backup. When I launch the wizard I get an error " Failed to retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can ...

recent SQL 2005 hotfix creates problem

fj - 19 Apr 2007 6:00 PM - 8 messages

Here are the errors in event log. The installation packeage keeps trying every 3 hours. How shouyld I fix it. Microsoft SQL Server 2005 Tools Express Edition -- Install started. Product: Microsoft SQL Server 2005 Tools Express Edition -- Error 2711. The ...

set transaction isolation level read uncommitted

Shkedy - 19 Apr 2007 5:06 PM - 4 messages

I have a web application that is running reports on a database. Ther reports utilize 2 big tables that keep getting inserts all the time (100s per second). When the report takes a long time to run I miss some of ...

MS OLE DB provider for Oracle

SamP - 19 Apr 2007 4:58 PM - 7 messages

Hi, I am trying to create a link from SQL SERVER 2005 64 BIT to an Oracle database on Solaris. The problem is when I try to create the link I get MSDAORA not found. It is not in the drop down list when in the MSSMS 'New ...

Cannot create a Stored Procedure

sharman - 19 Apr 2007 4:54 PM - 5 messages

Hi, I am getting a error that the object already exists in the database when I try to create a Stored Procedure. I have looked in sysobjects table and have tried 5-6 different names for the Stored Procedure but nothing works. Any ...

Help with moving DB from 2000 to 2005 folders

pbd22 - 19 Apr 2007 4:31 PM - 3 messages

Hi. After installing SQLExpress on my DB Server, I have the following file directory: 80 90 MSSQL MSSQL.1 I am noticing that the DB that I am working with is in MSSQL > DATA > MY_DB.MDF On the Web Server, I want to connect to (server name)/SQLEXPRESS so I ...

Hyperthreaded CPU's

Chris Wood - 19 Apr 2007 4:22 PM - 9 messages

Hi, This is a follow-up to Ken's earlier Option (MAXDOP 1) thread. We have a server with 3 hyperthreaded CPUs that will show as 6 CPU's to SQL2000 SP3A. I am lead to believe that logical CPU's 0, 2 and 4 are the physical CPU's. ...

SSIS Connection Error

DXC - 19 Apr 2007 4:10 PM - 6 messages

I can not connect to SSIS from the management studio after installing the SQL Server 2005 SP2. I am getting: "Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)" "Connect to SSIS service on machine failed: No such interface supported" ...

A couple LDF questions.

mark_s_nospam - 19 Apr 2007 3:55 PM - 4 messages

I do a bit a sql programming but do not handle the admin side. Our server backups are becoming huge so I looked around to see why. A couple of our databases (small... ~60Megs) have ldf files that are almost 1 gig. I did some reading and learned about 'dbcc loginfo'. It ...

Run a stored proc thru the index tuning wizard?

Derrick - 19 Apr 2007 3:33 PM - 2 messages

Is there any way to run the index tuning wizard on a stored proc, other than copying the content of the stored proc into sql query analyzer? I tried highlighting a sql call to the sp, and running itw on that along ...

recover a database without backup

Brian Brian - 19 Apr 2007 3:18 PM - 5 messages

Hi, Is there any way to recover a sql database from a file system backup (.mdf and .ldf files copies taken every night while sql was up and running)? The client does not have any sql backups. I know he should ... ...

SATA for SQL Server data

Chris - 19 Apr 2007 2:58 PM - 8 messages

Hi all, Currently we have database system that logs readings from sensors at an interval from 5 minutes to 1 hour (more on the 5 minute side), from which customers can view statistical data, graphs, etc. For storage, we currently connect to a fiber-channel SAN with 150GB 15k ...

SQL Server Agent Not Restarting Automatically

Jason H. - 19 Apr 2007 1:58 PM - 7 messages

We've created a few backup jobs within the SQL Server Agent inside SQL Server Enterprise Manager (2000) and the jobs will run fine for a few days but, afterwards, stop altogether. I realized it was because the SQL Server Agent ...

Database in Standby / Readonly

johnvmc@gmail.com - 19 Apr 2007 1:49 PM - 2 messages

I recently restored a database to a 2005 SQL Server and it is now reporting that it is in standby / readonly mode. I've seen some suggestion that this could be solved through re-restoring the database but the database restore isn't an option. I've tried taking it offline ...

SQL Server 2K Memory Capacity

David Kirkman - 19 Apr 2007 11:03 AM - 3 messages

We currently have SQL Server 2K Standard running on W2K Server with 2Gb of RAM. We are about to upgrade the server to W2003 Server Enterprise and 12 Gb of RAM. According to BOL our current version of SQL server will only be able to use 2Gb of RAM on all editions of W2K ...

Error message

Stefan Braun - 19 Apr 2007 9:55 AM - 2 messages

Hello, If a execute a query SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode, Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz ...

data conversion

Tiffany - 19 Apr 2007 8:48 AM - 2 messages

Hi i have a problem converting a column which contains the date to the date type i want ie mm/dd/yyyy csv source file is y-MMM (e.g. 6-Feb is Feb-2006). When i import the data ...

performane issues - can someone explain the connection?..

Sergei Shelukhin - 19 Apr 2007 8:44 AM - 3 messages

Hi. We recently moved some databases to a new server; databases are not related and do not communicate with each other. Immediately after the move we started experiencing performance problems with a big quantity of waits - one-third of active ...

Linked server error in SSMS

Darius - 19 Apr 2007 7:33 AM - 5 messages

Hi all I have installed Sql Server 2005 + Sp2 developer edition. Once trying to add a linked server in SSMS Server Objects => Linked Servers => New Linked Server I'm getting the error immediately saying " Cannot show requested dialog. Cannot find table 0. (System.Data)". Additionally Providers tree ...

RESTORE DATABASE is terminating abnormally

HawleyBeach - 19 Apr 2007 4:40 AM - 3 messages

Hi DBA there, I am restoring a bakup from CD with SQL Statement: RESTORE DATABASE WITE FROM disk ='e:\wite.bak' WITH RECOVERY, MOVE 'wfield_dat' TO 'c:\Program Files\Microsoft SQL ...

import dtsx file

00ScarlettJohnson - 19 Apr 2007 3:42 AM - 2 messages

How do I import dtsx file to SQL2005?Thanks ...

Install Client Utility only

LaEsmeralda - 18 Apr 2007 10:02 PM - 2 messages

How do I install Client Utility only in SQL Server 2005 installation? Thanks. ...

Installing SQL Server 2000 on WindowsXP

Gloria - 18 Apr 2007 9:14 PM - 11 messages

Hi All, Can you install the Standard Edition of SQL Server2000 on WindowsXP? Thanks, Gloria ...

Query compiling time

Tom - 18 Apr 2007 8:18 PM - 4 messages

In SQL2005 is there a way to find out just how much time CPU is using on compiling a plan for a query and how much on executing that plan? There is quite a lot of compiles/second (200-400/second) while running some ...

SQL Server Hiccups

Audrey Ng - 18 Apr 2007 7:57 PM - 2 messages

Hi all, I am currently using SQL Server 2005 database with an Access 2002 front-end. I have noticed that every once in a while, I get a lock on an object table and sometimes freezes other users (probably because they ...

Left outer join v. Union

mGracz - 18 Apr 2007 7:55 PM - 3 messages

Hello everyone, I wonder how we can optimize following query: SELECT a.a,a.b,a.c FROM tab1 a LEFT OUTER JOIN tab2 b ON (a.quantity <0 AND b.pid = a.id) OR (a.quantity>=0 and b.rid = a.id) ...

SQL Execution Performance Problem

igor - 18 Apr 2007 7:42 PM - 2 messages

I have a sql statement that completes in under 10 seconds when executed using the Query window, but when I try to execute it from a sql job or from a vbscript it takes almost 2 minutes. Any ideas would be helpful. ...

Running SQL 2k and SQL 2005 on the same box

Phillip Vong - 18 Apr 2007 7:33 PM - 3 messages

Is it possible to run SQL 2k and SQL 2005 on the same server? I know it can be done with V Machines, but I want to put them on the same box under the same OS. I have one application that's keeping me from upgrading to SQL 2005 and they ...

SQL 2005 Object extraction in Management Studio

JoeyD - 18 Apr 2007 7:33 PM - 3 messages

Hi all, I was wondering if there was some type of a profile/configuration switch in Management Studio that would include an object's permissions when you use the 'script object as..' option? Thanks, JD ...

How do I ignore server errors in Stored Proc run via SQL Agent

Lorne - 18 Apr 2007 6:21 PM - 3 messages

We have a weird application from a vendor which requires logins to be established in TempDB. The problem comes in when the server is rebooted TempDB is recreated wiping out the logins. I have created a stored procedure that is copied to TempDB from ...

How to Improve SQL Server performance with web application

alps - 18 Apr 2007 6:06 PM - 2 messages

Hi all, I am facing some difficulties with web application performance. I have web application in front end and SQL server 2000 Enterprise Edition in Backend. Now , some web pages in application takes very long time while getting data from SQL server. I want to improve the speed with ...

UPDATE won't execute on 2k5 installation

codypo - 18 Apr 2007 5:52 PM - 3 messages

We recently upgraded a machine from SQL Server 2000 to SQL Server 2005 Developer Edition. The process itself went fine, but now something very strange is happening: we can't run any updates against one of the databases. Inserts and Selects are fine, but even the simplest ...

Monitoring free space in database and log files with script

Mark - 18 Apr 2007 3:59 PM - 3 messages

I'd like a tool (I am willing to build it) that once a day goes out and identifies how much free space is left in my databases and log files. I'm aware that notification/alerts can be setup, but I don't need/want it to ...

Server migration

Terri - 18 Apr 2007 3:29 PM - 2 messages

I am migrating a 2000 SP3 installation to new hardware. I also need to upgrade to SP4 with TRACE flag 9059. A few questions if I may. What would be recommeneded timing for the SP4/trace flag upgrade? -install SP3 on the new hardware, perform the migration, and then install ...

Need help with server configuration.

vlad - 18 Apr 2007 2:51 PM - 6 messages

I'm in the process of configuring IBM X3850 server 4xDual-Core Xeon 3.0 GHz, 8GB RAM for a 30GB SQL Server 2005 OLTP database. Disk arrays are currently configured: Direct attached disk device with IBM ServeRAID 8i controller (battery ...

BCP problem on different servers

spiccolotto - 18 Apr 2007 2:37 PM - 3 messages

I´m using BCP command inside VB6 DLL to import data from csv file to database. Normally it works fine, but when my database is installed in a server with Windows 2003 and SQL Server 2005 I had problems... bcp not ...

Problem with scripting in SQL 2005 after SP2

GAZ - 18 Apr 2007 1:34 PM - 3 messages

Hello everyone, We hit a snag after installing SP2 for SQL Server 2005 Standard. Basically, when we want to script the database the server takes ages to determine objects in the database and then it takes another age to actually script the ...

Scheduled backup in SQL Server 2005 Express

Kjell Arne Johansen - 18 Apr 2007 8:52 AM - 3 messages

SQL Server 2005 Express does not have any possibilities to schedule backup so I have made a simple application for scheduling backup, running a stored procedure in my database. The procedure backup up to the same backup device so all backup sets are ...

Ad hoc update to system catalogs is not supported?

Kjell Arne Johansen - 18 Apr 2007 8:32 AM - 9 messages

Hi SQL Server 2005 Express. 25 january 2007 I added a new procedure to my database using ole automation procedures such as sp_OACreate and sp_OAMethod. These system procedures requires 'Ole Automation Procedures' to be enabled. So I added the following to my installation script: ...

Should be a simple select...

David Thielen - 17 Apr 2007 11:42 PM - 6 messages

Hi; Ok, this should be an easy select but everything I have tried has not worked. I have 2 tables with a PK:FK relationship. So Customer.customerId = Purchase.customerId. I need all rows in Customer where they have zero ...

Recompile vs Recreate

Frank Rizzo - 17 Apr 2007 10:24 PM - 9 messages

I have an intermittent problem on SQL Server 2005 64bit where the stored procedure query will get out of sync with the data and it starts taking a long time to return the data. I've tried issuing sp_recompile on the stored proc and the performance ...

Question about best practices..

Tim Greenwood - 17 Apr 2007 8:51 PM - 8 messages

Given the need to update data, is it better to have 500 procs that update a table as needed for a specific situation or given a table like: create table dbo.People ( ID int identity(1,1) not null, ...

Query posting wrong information

Greg Larsen - 17 Apr 2007 6:00 PM - 3 messages

Why does this query post the wrong total_elapsed_time? Note you need to run this query twice to see results. select execution_count abc_exe_count, total_elapsed_time, qt.sql_handle, last_execution_time, ...

Import & Export

msnews.microsoft.com - 17 Apr 2007 3:56 PM - 2 messages

How do I Import and Export a table in SQL 2005? Thanks, ...

Storing T-SQL code so it can't be read

Greg Larsen - 17 Apr 2007 3:28 PM - 11 messages

If you want to create a new database and some T-SQL (stored procedures) on an external partners SQL Server machine that will be used by Reporting Services RDL files but don't what the external partner to see or change the code what ...

Change only USER tables to a new user

Tmuldoon - 17 Apr 2007 3:10 PM - 4 messages

Hello, I have a database created with several tables. There are two types of table - system and user. I want to change all the user tables ownership from dbo to another user. Is there a script that would allow me to do that - but only affect the ...

can't access server from another PC

InNeedOfAssistance - 17 Apr 2007 3:08 PM - 5 messages

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did that I have been unable to access the SQL Server on my laptop from another PC. When I go to register it from another PC I get: ...

xp_msver

Greg Larsen - 17 Apr 2007 2:56 PM - 3 messages

When I run xp_msver on a machine that has 2 an Intel Pentium 586 CPU's this XP returns 4 from ProcessorCount. Now my question is do I need to by 4 CPU licenses for SQL Server, or only 2? ...

Rolling Back from build 3159 to build 3152

Chris Wood - 17 Apr 2007 2:13 PM - 8 messages

Hi, We were on build 3152 after hotfix 933097. Build 3159 hotfix 934459 was applied by accident. 933097 says it can be uninstalled by using Add/Remove programs and hotfix 934459 shows up in the list in Add/Remove programs. So ...

HELP!!! I/O error (torn page) when attaching mdf and ldf files

Kristen - 17 Apr 2007 1:32 PM - 2 messages

We are using cloning software to directly backup the mdf and ldf files. I am testing a restore of these files by using sp_attach_db. When I do this I am receiving an error on the ldf file: See below: ...

SQL 2005 Performance

Noah Hamilton - 17 Apr 2007 1:25 PM - 5 messages

All, I am running Windows Server 2003 x64 with SQL 2005 64 with 8 gigs of ram. My system is running extremely slow. The system is paging very hard running a raid1. Is there a startup parameter that I can use to make SQL use more ...

SQL 2000 SP4 Backup Fails but no error?

brymer28303 - 17 Apr 2007 12:40 PM - 4 messages

I copied the following out of the log file: Executed as user: PANTRY\sqlsrvr. ...es, contact your system administrator. [SQLSTATE 01000] (Message 2528) Processed 74624 pages for database 'BEST', file 'BEST' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for ...

Major SQL Server 2k5 x64 configuration problem

Nick - 17 Apr 2007 9:54 AM - 4 messages

Dear All, I've just installed two brand new SQL Server servers with Windows 2003 Server 2003 R2 + SP2 and SQL Server 2005 Standard Edition + SP2. I now need to configure the network protocols for SQL Server on these machines, but on both machines the SQL Server instances are not showing up in ...

Multiple database versions on same server.

stuckish - 17 Apr 2007 7:35 AM - 2 messages

We have a environment where we have one development server, one stage and one prod. On dev and stage we need to have multiple versions of the database to be able to do hot fixes for previous versions of the ...

One table returns ODBC timeout error

Bobby - 17 Apr 2007 7:33 AM - 8 messages

Hi I've arrived in work this morning to find that my normally smooth running database is apparently "down". In reality, this means that I have one table, called "Timebookings", which has a problem. I use SQL Server as BE for and Access FE. When Access tries to use the ...

ssrs

othellomy - 17 Apr 2007 6:09 AM - 5 messages

I create this report using wizard and placed some fields. Then I placed a dummy field (text) on the body. However, that dummy field does not repeat for each row of the report instead it is displayed at the end. Any idea how to fix this? Basically I am trying to get row ...

Best practise on Database security

harifajri@gmail.com - 17 Apr 2007 2:30 AM - 4 messages

Hi All, In our development server, everyone (Developers) are member of system administrator (SA). So on development server, anyone can do all database access. In our production server, there are only two type of account which are SA and Public Account. ...

Can you spot a security problem here with XQuery!?...

Jeff Wang - 17 Apr 2007 1:38 AM - 3 messages

Hi all, i am experimenting to see what vulernabilities there may be with user provided inputs of Xquery. One minimum safety measure that should be enforced is that any single quote input from the user should be escaped with another ...

Problem with TCP connections to SQL 2000 application

ken.sumner - 17 Apr 2007 12:51 AM - 3 messages

I am running a large mission critical application on a cluster. This is a 2003 server latest SP with SQL 2000 Enterprise latest SP also. This app has run for years with little change. Today at around 3:00 ...

deleting a tx log backup

Ant - 17 Apr 2007 12:46 AM - 3 messages

Hi, I backed up my transaction log in order to perform a point in time restore. I backed it up to an ad hoc folder. The database actually does backup the log file once a night to a different location. I'm going to change this to ...

DBCC IND

Leila - 16 Apr 2007 10:00 PM - 2 messages

Hi, I need a brief description about the columns of DBCC IND result. Thanks in advance, Leila ...

How can I troubleshoot eratic, slow SQL Backup job?

Sanctus - 16 Apr 2007 9:51 PM - 2 messages

I have a SQL 2000 sp3 server running on a server class machine with local drives. I'm backing up a 50 gig db from the e partition to the F: partition. Sometimes the backup takes 20 minutes...sometimes it takes 2.5 hours. ...

database copy

Port Man - 16 Apr 2007 8:58 PM - 4 messages

I'm a total newbie to sql server 2005 and need to copy a database from a production server to a test server. Can someone tell me how to do this? The servers are in two physically different locations and I ...

How to KILL a Suspended Sys Process?

Michael Kansky - 16 Apr 2007 6:24 PM - 3 messages

I have a suspended process that sits in running processes returned by SP_WHO for 3 days already. SPID:10 Status: SUSPENDED Login Name: sa DB NAME: master Command:CHECKPOINT CPU Time: 2625937 DiskIO: 358622 An attempt to "kill 10 " failed saying that only user processes can be ...

SQL backup files... ascii or binary ?

Hassan - 16 Apr 2007 6:03 PM - 2 messages

The SQL backup files. What kind of files are they ? Is it ASCII or binary or something else ? ...

Why scale out and not scale up ?

Hassan - 16 Apr 2007 5:03 PM - 11 messages

In todays ecommerce space, why do we scale out and not scale up when it comes to SQL databases? ...

Backup not working in 2005

Emma - 16 Apr 2007 5:00 PM - 4 messages

I am trying to backup a database that was moved from 2000 to 2005 and I get the following error message: The backup of full-text catalog â€˜Attachmentâ€™ is not permitted because it is not online. Check errorlog file for the reason that full-text catalog becomes ...

Sql Server 2005 & Visual Studio.Net

Uday - 16 Apr 2007 3:54 PM - 9 messages

Pardon me, if this is not the right group to post..... We are planning to buy Sql Server 2005 for our new project. Recently, I realized that it comes with Visual Studio.Net also. So my questions is, if we are planning to build web application in .Net ...

SQLServer Log Full / Disk Full / Backup-Shrink Not Working

gary - 16 Apr 2007 3:53 PM - 3 messages

Hi All, I am getting "The transaction log for database 'MyDatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases" The referenced column is set to REPLICATION. Looking at the database files, the problem is that the log has grown ...

Restore problem

Willie Bodger - 16 Apr 2007 2:58 PM - 6 messages

So, I have setup log shipping and it works fine for a while (like a1-2 days and then one time when it is trying to restore the data it freezes and the database says it is (Loading) and it does nothing. At all. Just sits there. ...

oledb to ibm db2 - no tables?

Import CSV File with FTP as Source

Basic Questions about SQL Server IO Optimization

Naming a Database

Can the SQL Server Managament Studio connect to ODBC sources?

Mail Profile sql 2005 : How to retry until successfully sent?

Importing More Than 10'000 Rows

How do i limit number of rows in a table based on dates?

Inserting German Charactors through application in SQL Server 2000/2005

SQL alerts to invoke a windows form - Help

Indexes

Avast Antivirus causing SQL Server 2005 not to start up

SQL 2000 Question

TEXTIMAGE_ON

number of connections

Disabling a Login (or Denying)

Views corrupted after schema change

Truncating log file

What does Grid Technology mean ?

Using 4 CPU by SQL Server 2005

QA Alternatives

Lock escalation