SQL Newsgroups: Microsoft SQL Server Administration

How do you all configure Symantec AntiVirus on a Microsoft SQL Server?

Spin - 24 Jun 2006 4:27 PM - 4 messages

Gurus, How do you all configure Symantec AntiVirus on a Microsoft SQL Server? Do you simply exclude the MDF and LDF files from real-time scanning and call it a day? ...

How to debug sprocs in 2005?

Frank Rizzo - 24 Jun 2006 3:11 PM - 4 messages

With SQL Server 2000, you could debug a stored proc from SQL Query Analyzer. I've looked all over the new integrated IDE that comes with SQL Server 2005 and I couldn't find a way. Is debugging still part of ...

SQL 2005 Memory/AWE questions

TomT - 24 Jun 2006 1:59 PM - 5 messages

We have a Windows 2003 Enterprise server (32 bit) set up with 5 gigs of memory, running SQL 2005 Standard. Currently, SQL 2005 it is configured to use AWE, and has 2048 mb as the mininum server memory. The server has 2 dual core amd 64 bit processors, but we use Neverfail, ...

Tape Drive backup now fails in SQL Server 2005

RonE - 24 Jun 2006 1:01 PM - 6 messages

If this has been posted, I'm really sorry. I've been searching for days for a solution to this problem. Keep also in mind that I'm a developer and not a systems administrator. I appreciate your patience. ...

SQL '05 Log File Viewer Filter Doesn't Work

Calen - 23 Jun 2006 11:46 PM - 6 messages

Hi all, How does the SQL Server 2005 Log File Viewer Filter work? Or why doesn't it work, and when will it be fixed? When I try to filter on the Source not being "backup", no log entries are ...

SQL Server crashes... memory leak?

Mike - 23 Jun 2006 10:50 PM - 5 messages

Hi, Our SQL Server crashes every few days and needs to be rebooted. After doing some research I believe this may be due to bug 897572 ([link]). In short, that the MemToLeave area ...

SQL partitions/volumes....

Mrpush - 23 Jun 2006 8:56 PM - 2 messages

Hello, Using SQL 2000 on 2003 server. My question is with SQL server, what is the best way to partition/volume the OS, SQL app, Data, etc? I'll have 3 to 6 each, 33 GB drives, and I have a hardware based RAID 5 at my disposal. ...

Torn Page Restore

Tam OShanter - 23 Jun 2006 7:44 PM - 2 messages

Hi All, Quick question... I've found that a database in our system has encountered a torn page error. DBCC CheckDB hasn't worked any wonders so we're going to restore from a backup. The torn page error began occuring several days ago. ...

Re: INCLUDE option in CREATE INDEX

Alexander Kuznetsov - 23 Jun 2006 7:12 PM - 2 messages

Gert-Jan Strik wrote: More to the point: even if you filter on it, but the first column(s) is selective enough, including instead of indexing might be more efficient. Also consider a unique index on employee_id including email_address. The query ...

Simple DTS question

shub - 23 Jun 2006 6:51 PM - 2 messages

Basically I have got a sample code here that generates couple of errors when I run through Query Analyzer (SQL 2000). When this same query is executed from within a DTS pacakge I would like to be able to see the ...

attempt to copy 2005 db ouside my network shows wrong db?

Les Caudle - 23 Jun 2006 6:42 PM - 5 messages

I connected to an sql 2005 located out on the Internet. I can export the database I have permissions for and its data ok. When I right click on the db and choose copy, I get an error at the end of the ...

Concurrent MSDE SQL and SQL 2000/2005

Emily - 23 Jun 2006 6:15 PM - 4 messages

We have two servers that need to be upgraded. One has an app that uses the MSDE version of SQL. The second uses SQL 2000. Neither has very many users. Could we purchase a single new server, and run both versions of SQL on it ...

SQLIOStress

Harold - 23 Jun 2006 5:19 PM - 5 messages

I'm trying to figure out the utility using my workstation and ran into an error that I can not find on the web anyware. 06/23/06 12:28:52 00000840 Simulating CheckPoint of 23290 pages like SQL ...

Access SQL Server Behind Firewall

harel.davidm - 23 Jun 2006 5:04 PM - 11 messages

I have an SQL server that resides on my local LAN. My local LAN is behind a firewall that we do not maintain. We have been told that we cannot have any additional ports opened on the firewall, meaning that ...

Nasty SQL Server 8 Bug??

K-OS - 23 Jun 2006 4:24 PM - 3 messages

This is the wildest thing to ever happen to me. Look at this query's where clause: select pid, product_type, riv.res_ref_id, pid from mb_planning_service JOIN tyg_research_item_vw riv on riv.ps_id = mb_planning_service.pid join tyg_user_recently_viewed urv on urv.research_id = riv.res_ref_id ...

Manually Remove SQL 2005

stoney - 23 Jun 2006 4:11 PM - 2 messages

Help is needed fast in removing sql 2005 manually thx in advance ...

Replication understanding

cbrichards via SQLMonster.com - 23 Jun 2006 3:46 PM - 4 messages

I am trying to gain an understanding replication. I have listened to some webcasts and read from BOL, but there is something that is escaping me on the implementation. For simplicity let's say I that I have 10 databases in ...

AdventureWorksDB

mmc - 23 Jun 2006 3:46 PM - 10 messages

I can't view the AdventureWorksDB database diagram even after the ALTER AUTHORIZATION statement. Thanks.. ...

how can I have this package execute in loop....I want to change every lines that are not correct, no

Fernand St-Georges - 23 Jun 2006 3:41 PM - 2 messages

declare @tlongtextvar as varchar (8000), @tspecK as int select @tlongtextvar = dbo.tLongTxt.tLongTxt, @tspecK = dbo.tLongTxt.k FROM dbo.rTable INNER JOIN dbo.tLongTxt ON dbo.rTable.K = dbo.tLongTxt.tSpecK ...

Help - All Users can Access All Databases

Dan - 23 Jun 2006 3:27 PM - 4 messages

Hello. I am using SQL Server 2005 Std. 32bit on Windows 2003 R2. I am having an issue where, when I create a new user, even before I assign them any rights they can connect to any database in my SQL instance and read/write ...

Text/Scientific Number

Ysandre - 23 Jun 2006 2:48 PM - 7 messages

I'm bulk inserting a .csv file into a SQLtable. All the columns in the SQL table are varchar. I have some values in the .csv file that are: 921000256646, 921000256695, etc. After the file has been bulk inserted into the SQL table, the values all ...

will backups block other processes

Dan D. - 23 Jun 2006 2:25 PM - 5 messages

Using SS2000 SP4. If scheduled jobs are running that are trying to read from and write to tables, will a backup on the same database cause blocking and locking? Or are the backups done in such a way that the backups don't ...

SQL 2005 Memory Error

Ron - 23 Jun 2006 2:22 PM - 9 messages

I have a 64 bit sql 2005 server run on a 64 gig windows 2003 64bit server. The sever has been running fine for the last few months. In the last couple of days a problem has come up though. ...

SQL Server 2005 disaster recovery options

SAM - 23 Jun 2006 2:22 PM - 3 messages

[link] This article discusses advantages, disadvantages and requirements. Are they the same for SQL Server 2005? Because it discusses SQL Server 2000. ...

Data File and Filegroup in DB Properties

Melih - 23 Jun 2006 2:14 PM - 3 messages

Hi All, Is it possible to change db file to single file from multiple files? Thanks any help Melih ...

W2K3 IIS 6.0/SQL slowness with conncetion issues.

Matthew - 23 Jun 2006 2:05 PM - 3 messages

Ok here is a weird one. Background. Currently or system is set up with a dedicated Web Servers on the front end and SQL Servers backend, and communicate to each other over our network. Recently we upgraded our Web Servers OS from W2K IIS 5.0 server to W2K3 ...

Database Backup in SQL Server failover Clustering.

csajid - 23 Jun 2006 1:40 PM - 10 messages

Hi, I have done MS SQL Server failover clustering with SQL Server 2000 as One Active node and one Passive Node. I have set G: drive as a Clustered Drive where Database Files are ...

Query always times out until SELECT *..?

Neil B - 23 Jun 2006 11:27 AM - 2 messages

Hi all, I have an SQL Server 2000 database which contains an addresses table. This table has 20+ columns and about 1.2 million rows, so it's moderately large. I have a simple requirement to query that table for addresses matching ...

The identifier that starts with...is too long. Maximum length is 128

Pedro - 23 Jun 2006 11:14 AM - 7 messages

Hi, i'm trying to run a stored procedure: "EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT', '2006-02-01 00:00:00', '2006-02-28 00:00:00'" and gives me this error: The identifier that starts with ...

logshipping

Melih - 23 Jun 2006 10:45 AM - 4 messages

Hi, I'll take FULL and transaction LOG backups via a custom written stored procedure. But its working only for single database file. Does not dynamically pick up database files/filegroups from the backup files themselves. Is it possible to take backup of database contain files/filegroups? ...

Compare tables from one server/database to another

Wilfrid - 23 Jun 2006 9:59 AM - 5 messages

Hello, I know for mysql there is a tool that compares tables (like a windiff tool). Is there anything for MS SQL? thanks Wilfrid ...

Rollback Transaction

jouj - 23 Jun 2006 8:55 AM - 5 messages

Dear All, I'm using SQL Server 2000 I have a table named Table1(f1 int) and a trigger: ========================== CREATE TRIGGER t ON [dbo].[Table1] FOR INSERT AS IF (Select Top 1 f1 FROM inserted) <3 Rollback Transaction ========================== I wrote that code in a SP: ...

Capacity planning question

George Kwong - 23 Jun 2006 7:18 AM - 8 messages

I am working on a RFI for a SQL Server 2000 database apllication, I am looking for some general answer the question below: Capacity and resource planning for SQL Server 2000 1) resource requirements for 500, 1000, 2000 concurrent users (database, ...

tempdb concurrency

Hassan - 23 Jun 2006 5:13 AM - 4 messages

I want to implement the trace flag per this article [link] Instead of using-T1118 to the startup parameter and restarting SQL Server service,can I run the DBCC Traceon(1118) ? ...

Virtual IP per Instance

Racheal - 23 Jun 2006 2:00 AM - 2 messages

Dear All, Does anyone know how to configure virtual ip bind to each instance, I need to configure 2 Virtual IP addresses on the Server and have each instance on a different Virtual IP address so they could both use the ...

Site for SQL Server Patches

Jason - 23 Jun 2006 1:43 AM - 2 messages

I am doing patch management on SQL servers. Windows update does not detect patches for SQL. Does anyone know if Microsoft has a website that lists all patches for sql server? ...

SQL Server locking up

Alex Cheng - 22 Jun 2006 11:23 PM - 3 messages

Hi there, I've a problem in the SQL Server 2000 that any update/insert (all tables) will be timeout from both application and SQL query analyzer. The select statement is working though. Do you have any idea? There is no open ...

Can't run my scheduled job which accesses a linked server: other options?

ryan_willow - 22 Jun 2006 10:35 PM - 5 messages

I have a stored procedure in a database on a server, and this stored procedure uses a linked server. The login I was given is only granted DBO permissions on this database. I am trying to set this up so that the above stored procedure runs once ...

Number of per seat Licences configured in sql server.

MariaGuzman - 22 Jun 2006 9:00 PM - 2 messages

Hi, I have a server running windows 2000 server sp4, sql server 2000 sp3. When i installed the sql server software i Configured a 500 per seat licences. this week i check that the sql server is running about 578 concurrent ...

INCLUDE option in CREATE INDEX

cbrichards via SQLMonster.com - 22 Jun 2006 8:30 PM - 5 messages

What is the difference in the following CREATE INDEX statements when using the INCLUDE option? CREATE INDEX index1 ON table1(col3) INCLUDE(col1, col2) CREATE INDEX index1 ON table1(col3, col1, col2) I have read BOL on the INCLUDE option and it says that it "Specifies the ...

Would you suggest contacting MS paid support?

gshawn3 - 22 Jun 2006 7:14 PM - 3 messages

Hi, I am having what seems to be an obscure issue with SQL Server 2000. I posted about the problem in these groups about 2 days ago but did not receive any suggestions. I have never contacted MS paid support before, so I am not sure what to ...

Outlook locked when using sql 2005 - please help

Jack - 22 Jun 2006 6:31 PM - 4 messages

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the email operator and defined notifications on a job to send out emails when job completes. The issue is the my outlook client on the server gets locked once sql server ...

Reporting solution

cbrichards via SQLMonster.com - 22 Jun 2006 6:21 PM - 6 messages

I was interested in knowing (my experience is limited) what might be the best solution when using Reporting Services to return data that can be 15 minutes old, tops. We are looking to have a separate, second data set dedicated to ...

How to hide triggers from SQL Server?

Peter - 22 Jun 2006 6:05 PM - 2 messages

Hi, I wonder whether there is a way to temporarily hide triggers from SQL Server 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want to do this is because even though I disable triggers, SQL Server will take times ...

Creating Outlook rule

MC - 22 Jun 2006 5:48 PM - 5 messages

We try to create "Out of office" notice but not to reply, if Subject contain SPAM how do we do that? Rule that we want to create is simple - Relpy to anyone - If subject DOES NOT Contain "SPAM" Thanks MC ...

Moving The Transaction Log file location

Rob - 22 Jun 2006 4:57 PM - 11 messages

Is there a way to safely move the transaction log file ? Tried to detach the db, move the transaction log file, then tried to re-attach the database with a the modified transaction log path, but that was not successful. ...

using joins to find date and exchangerate

Rajeev - 22 Jun 2006 4:49 PM - 2 messages

I have two tables Expense_Addl and ExchangeRates These are the scripts CREATE TABLE Expense_Addl ( FileId int, HostAmt money, HostCurrencyCd char(4), ...

Some Difficult joins

Rajeev - 22 Jun 2006 4:47 PM - 2 messages

I have two tables Expense_Addl and ExchangeRates These are the scripts CREATE TABLE Expense_Addl ( FileId int, HostAmt money, HostCurrencyCd char(4), ...

Poor Performance - Identical Databases Different Performance

BTabios - 22 Jun 2006 4:42 PM - 2 messages

Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with ...

Poor Performance - Identical DBs But Different Performance

Brian Tabios - 22 Jun 2006 4:38 PM - 4 messages

Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a ...

Installation Problem -- SQL Server 2005 Standard & Windows XP Professional Service Pack 2

Padmanaban - 22 Jun 2006 3:57 PM - 6 messages

Hi I am trying to install SQL Server 2005 Standard on my laptop, which has Windows XP Professional with Service Pack 2. I could not able to install properly and i am getting error always. i tried whatever the people mentioned in Google, but I could not able to fix the problem. ...

Event ID: 17052 - Urgent

RM - 22 Jun 2006 3:45 PM - 9 messages

Good afternoon, I'm getting the error with the Event ID: 17052 with the following text: Error: 1105, Severity: 17, State: 2 Could not allocate space for object 'X' in database 'Y' because the 'PRIMARY' filegroup is full. And the processo aborts. ...

Unlock Login

pleblanc - 22 Jun 2006 3:28 PM - 3 messages

I am working on Windows 2003, SQL Server 2005 Enterprise Edition, Active Passive Cluster. We are using the Great Plains system, which requires all users to have a SQL Login. Our Sox Auditors have requied that we enable check_policy and ...

current_timestamp vs getdate()

Tom W - 22 Jun 2006 3:21 PM - 6 messages

Is one preferable to the other? bol says of that current_timestamp "This function is equivalent to GETDATE()." Do they both exist in sql 2005? (I only have 2k) Is one for backward compatibility? gracias Tom ...

Formatting Database Server Need Procedure for Restoring Database

Chris Witthoft - 22 Jun 2006 3:17 PM - 2 messages

Hello, I have a database server running windows 2000 server sp4, sql server 2000 sp3. I want to format this server and start fresh with an install of windows 2003 server standard edition and reload sql server 2000. My sql server ...

How to query for transaction's isolation level...

SammyBar - 22 Jun 2006 2:36 PM - 6 messages

Hi all, Is it any way to query a running transaction to see the isolation level it is using? I'm debugging a mobile .net application that access a SQL 2K database and I need to verify if it is running transaction on the desired ...

Deleted Database

Ricardo Massad - 22 Jun 2006 2:11 PM - 3 messages

Hello there, yesterday i was changing some things on my SQL and I wanted to dettach one db of SQL.. But i Deleted this dabase. I don't have any backup... Anyone have some tips to me ? I need to restore this .mdf! ...

A request to establish a connection with transaction manager denie

Brad Ashforth - 22 Jun 2006 2:01 PM - 11 messages

A user has reported the message "A request to establish a connection with the transaction manager was denied". The code is at this point attempting to START a transaction. So far I have been unable to duplicate this, though the ...

Return Error Code From DTS Job

rmcompute - 22 Jun 2006 1:19 PM - 3 messages

I am running a DTS job from Access which runs some Data Transfer tasks and SQL stored procedures. The SQL stored procedures are set up to test the @@Error variable and return the error number when the error occurs. Can the ...

Executing a stored procedure that uses linked server from vb.NET

bermik - 22 Jun 2006 12:59 PM - 6 messages

I can't execute my stored procedure from .NET (I think it might be because the stored proc has joins in it via linked servers). I get timeout error from .NET MyBase.connString ="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DB;Data Source=Server;" ...

.NET exception whenn calling CLR user-defined functions

FwMsdn - 22 Jun 2006 12:53 PM - 9 messages

hello together! currently we are developing a server database which is using an assembly with some very simple clr-functions (eg check regular expression or converting local time to universal time). from some indefinite time we receive the following errormessage each time ...

how to accquer certain number of records

Crespo - 22 Jun 2006 11:46 AM - 5 messages

hi,every body. I want to use SQL syntax to get records from a database table. As the table may contain large number of records,I would like to get a certain number of records first and also can get more records later as necessary.Can ...

sql server 2005 user_id() issue

Server App - 22 Jun 2006 10:05 AM - 2 messages

Hello, We have 2 "identical" AD users, A and B, that we have created in a SQL server 2005 (SP1) They have the same permissions, setting etc. If they execute select user_id() select user_id(user) A gets the same result for both queries (the user id), but for B they ...

Cant see the username in the Owner Combo box during job creation

Double_B - 22 Jun 2006 8:51 AM - 3 messages

Hi All Am trying to schedule a job , but when I try selecting the username for the Owner... I dont see the username in th list , I cant even type the name of the user in the combo box .... The username exists in the logins of my SQL Server.... ...

SQL Server 2005 and Cursors

steve_craze - 22 Jun 2006 7:59 AM - 4 messages

Hi Everyone! We are using a cursor for paging results in SQL server, mainly due to the performance gains achieved when working with large results sets. We have found this to be of great benefit when working with SQL Server ...

sql 2005 express management tool equivelant

P Platan - 22 Jun 2006 6:48 AM - 6 messages

Hi, a friend of mine told that there is a SQL Server 2005 express Management Studio equivelant application (non MS) which i would like to give it a try! Does anyone know how it is called or the web address of the company? ...

Transaction Log file size Automatically Truncating.

csajid - 22 Jun 2006 6:20 AM - 10 messages

Hi, I am using MS SQL Server 2000 as my database server. I have database and transaction log backup like, In Night 9:00 PM -------- Full DB Backup In every 30 Minutes ------- Transation Log Backup. The Transaction Log Backup Command which i scheduled is, ...

Error when running sp_helpdb query

Kush - 22 Jun 2006 5:17 AM - 4 messages

I get the following error when running command "sp_helpdb" in Query Analyzer. Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100371F02'; column does not allow nulls. INSERT fails. ...

Check on Replication

FJC - 22 Jun 2006 5:15 AM - 2 messages

i, I have the following scenario: One server (Publisher) is in one domain "Domain A" and the other server (Subscriber) is in a different domain "Domain B"; the mail server is in "Domain A" for which the subscriber is unable to send email notifications ...

Logging NT Events

ipramod - 22 Jun 2006 4:44 AM - 10 messages

Hi, Is it possbile to retrieve all the Event Id's of a registerd source (Ex. MSSQLSERVER)? If it possible then can we retrieve the description of those Event Id's and can we generate the NT Event with the above NT ...

How do I monitor mirroring?

ChrisR - 22 Jun 2006 3:47 AM - 2 messages

SQL2K5 SP1. I set up mirroring and the target DB now says (Mirror, Synchronized / Restoring) but it would seem as though there should be a way for monitor as well? To make sure its staying in synch, doesnt fail, etc? ...

SQL server replication from non-clustered database servers

G.Fink.Nottle - 22 Jun 2006 2:32 AM - 2 messages

Hello, Being a bit of a SQL Server novice, need some advice with the following situation. Server A and Server B have SQLServer 2000 based databases. The vendor of the application/system has implemented their own replication process to ensure the 2 databases are in sync. However, there is no clustering ...

SQL2000 SP4 Error Script: Replsys(1)

Joe K. - 22 Jun 2006 1:38 AM - 3 messages

I received the following error message when applying SQL Server 2000 service pack 4 on a Windows Server 2003 Enterprise Edition service pack 1: Error Message: Error Running Script: Replysys(1) No error messages were placed in the SQL Server errorlog file or the event ...

schedule dts at a remote server

Ricky - 22 Jun 2006 12:47 AM - 3 messages

Hi Can somenone help me build a DTS in SQL Server 2000 that allows to schedule the execution of a executable file in a remote server without sql server?... [] Ricky ...

use of cd2 while installing sql 2005

Jack - 22 Jun 2006 12:33 AM - 2 messages

I copied the cds on the network and went to cd1 and clicked setup and the sql install went through - I installed everything except reporting service. In the whole process, I never got prompted for cd2. Is this normal or have I ...

Outlook locked when using sql 2005

Jack - 21 Jun 2006 11:10 PM - 3 messages

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the email operator and defined notifications on a job to send out emails when job completes. The issue is the my outlook client on the server gets locked once sql server ...

SQL Server 7.0 Pages/sec

magno32@gmail.com - 21 Jun 2006 10:30 PM - 3 messages

Hi, I am having somewhat of an issue with my SQL server. I am running SQL 7.0, which MS no longer supports. We have been running our database at this facility for well on 2 years now, with no problems. ...

Data diiferentator tools

Sobhan.Vezzu - 21 Jun 2006 10:15 PM - 2 messages

Hi All, We have a kiosk application which will be distributed across the states and connected to network on a cellular broadband connection. Kiosks transmit records to our central server on a periodic basis. We use a 3rd party vendor database in kiosks which needs to be updated ...

Loading Oracle into SQL

Richard Douglass - 21 Jun 2006 10:03 PM - 4 messages

I have a backup of an oracle database I need loaded/imported into SQL. Any ideas on how I can get this done relatively painless and cheap? Thanks Richard ...

Read the profiler output.

_Stephen - 21 Jun 2006 9:41 PM - 4 messages

In 2005 I am running the profiler on 2 large batch processes that we run. I am focusing on READS. Query below. select * from ecdbprod.[ASPState].[dbo].[Tweaks2] where Reads > 15000 and substring(TextData, 1,31 ) != 'exec MAR_Get_Daily_Trans_Report ' ...

dbo.tLongTxt.tLongTxt concatenation

Fernand St-Georges - 21 Jun 2006 9:34 PM - 4 messages

dbo.tLongTxt.tLongTxt is a Ntext 16 does it have to do with the message error UPDATE dbo.tLongTxt SET dbo.tLongTxt.tLongTxt = '<EntityDescription>' + dbo.tLongTxt.tLongTxt + '</EntityDescription>' FROM dbo.rTable INNER JOIN dbo.tLongTxt ...

Database Version 539 vs. 611 (using SMO)

Amos Soma - 21 Jun 2006 9:25 PM - 4 messages

I am using SMO in my .NET application to determine the version of a database (2000 or 2005). When I get the version of a SQL 2000 database, it returns 539. When I get the version of a SQL 2005 database, it returns 611. ...

sql 2005 schema alias

Nalaka - 21 Jun 2006 8:46 PM - 4 messages

Hi... I have and sql server 2005 based application.... with all data in a schema called "TreeHouse". So I have hard coded schema name "TreeHouse" all over my application. Now I have to create a separeate test environment for user acceptance ...

schedule backup

Me - 21 Jun 2006 8:32 PM - 6 messages

Is it possible to schedule backup of all the database on a sql server while the database is up and running? If yes, what tool should I use? Is it reliable? What happens to transactions that are happening while backup ...

Sql 2K replication

mecn - 21 Jun 2006 7:38 PM - 4 messages

Hi, I have a sql2k server A database replicated with another one B. I took off the server A from production. How do I delete all the subscription from Server B? Thanks ...

How to convert KB into MB in a query

Ricky - 21 Jun 2006 7:14 PM - 6 messages

Hi I need some help in how to convert a certain value in KB into MB. Please see the bellow script where i put the question. Thanks [] Ricky select location+space(1)+'-'+space(1)+dept as 'Location', compname as 'Computer Name', ...

MCP Exam Study Query

Simon Harris - 21 Jun 2006 7:00 PM - 3 messages

Hi All, I'm currently studying for MCP exam 70-229. I'm on the database logical modeling section, and have come up with this question: In a non-identifying relationship, how would a join work, or is the term ...

Creating an INSERT UPDATE Trigger that works on certain account

Jaime Rios - 21 Jun 2006 6:46 PM - 5 messages

Hi folks, I have to create an INSERT UPDATE Trigger that pushes data from MS SQL 2000 to another proprietary database server. The other database server will occassionally push data back into MS SQL via JDBC. I don't want the MS SQL ...

SQL 2000 Views

sk - 21 Jun 2006 6:45 PM - 2 messages

Can a view read tables in a different database from the one it is created in? Thanks Sarah ...

SQLServerAgent Errors

Attila - 21 Jun 2006 6:39 PM - 2 messages

After recovering from a power failure, my event log has been filling up with SQL warnings. I am using SQL 2000, sp 4. It is running on SBS 2003 Server, but I was referred here becuse it was determined the issue is now purely SQL ...

Can dump file naming convention be specified using Maintence Plan

romandvoskin - 21 Jun 2006 6:00 PM - 2 messages

Hi, For a 'complete backup' using Maintenance Plan the naming convention now is DBNAMEmo.dy.yr_hr_sc Can this changed or is it hardcoded? TIA -Roman Management Console 2.0 SQL Enterpise Manager 8.0 ...

Connection Error SQL Server Error 10060 / 17

Nanou - 21 Jun 2006 5:52 PM - 3 messages

Hello, I have the following error from one workstation connecting to a sql server : SQL Server Error 10060 [Microsof][ODBCSQL Server Driver][TCP/IP sockets]Connection Open (Connect()) SQL Server Error 17 [Microsof][ODBCSQL Server Driver][TCP/IP sockets]SQL ...

CFE2SQL Server does not exist or access denied.

JDS - 21 Jun 2006 5:49 PM - 4 messages

Does anyone have any idea what is causing the following error. "CFE2SQL Server does not exist or access denied." ...

Cannot change specific fields or row without truncating error

kurt.baker - 21 Jun 2006 5:42 PM - 7 messages

Greetings All, I am running across a problem that I have been trying everything and researching for the last couple days and am going absolutely nowhere. What I have are several tables (probably 15 or so) in one of many ...

Varchar to Float

Ysandre - 21 Jun 2006 5:00 PM - 4 messages

I'm inserting a field from one table to another. The source field is 'Varchar', and the destination field is 'Float'. Is there a generic way to set any value that has a letter in it to be 'NULL' in the destination field? ...

ERROR sql2005 sobre win2000 ad server

bajopalabra - 21 Jun 2006 4:52 PM - 5 messages

hi when i try to save a maintenance plan i get an error like "GUID must have 32 characters y 4 hyphens" "xxxxxx-xxxxx-...-xxxxx" this occurs in production ( sql2005 over win 2000 advanced server ) but, on dev environment ( over win 2003 server ) ...

Performance between Server and PC

Venedict - 21 Jun 2006 4:34 PM - 2 messages

Hi All, Recently we have an application running for 9 hours+ on an HP DL760 G2 with 8 Processors, 12GB RAM, 4 HDD 15K RPM 142GB running on Raid 1+0. We have tested with the same database and application on a normal pc which only have ...

Long Running SQL Job

FreeFish - 21 Jun 2006 2:29 PM - 4 messages

I've got a SQL SP that when executed in QA takes 5 minutes to run, but when scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as to why the difference? ...

How to change collation on MODEL ?

Pat - 21 Jun 2006 2:08 PM - 6 messages

I have a 2005 SP1 server with the wrong server collation. All user databases on this server have the right collation. I am getting collation conflict errors when I use temp tables. I believe this is because tempdb is created based on "model", and model has ...

Sql Server Performance Problem

ilyas - 21 Jun 2006 12:31 PM - 7 messages

i ve a laptop and server the laptop has centriono 1.8 , 1.5 gb ram , xp service pack 2 and sql server 2000 the server has p4 3.0 , 4 gb ram , Windows server 2003 , sql server ...

SQL 2005 64 BIT EE & Linked server to an ODBC DSN

Data displayed in duplicates

No disk in drive a:

Looping through tables

different waittypes info

side by side sql2000 & 2005

SQL Server book

error 1603 installing microsoft sql native client

SQL Server 2005 Column Encryption

in sql server 2000+ is there some stored procedure that shows your current disk space usage?

Consuming all Memory

SQL Server 2005 System Catalog Delete

SQL to Oracle update trigger fails due to distributed transaction error 7391

why to backup "master", "model" and "msdb" ??

OSQL output

SQL Server 2005 Encryption question

Slow SQL Server 2005

SQL Server 2005

MSSQL 2000 Developer Edition limit of connection ??

Getting the whole 'text' fileld.

Automatically export foxpro data to an xml file

Two server instances pointing to same files

Changing Logical Names

SQLAgent not running as domain account and Jobs getting hang in SQL Server 2000

BackUp Log ...

CHECKDB on master ?

t-sql errorlog

Problem restoring a SQL 2005 database from a backup device

Help with SQL planning

row_number query

Need Source for Information_Schema Views

Maint. Plan Backups and Single User Mode

Horizontal Scalability

Syntax error or access violation when executing Stored Proc.

link from sql2005 (64-bit) to sql 7 (32-bit).

Backup - [WildPacket]

SQL Server 2005 Hash Partitioning?

Move database to another partition

Error: 3314 serverity: 21, state: 4

SQL2005 Setup

2000 + 2005 Instance

DTS Truncates data to destination

File Copy using SQL Server

Error: 625, Severity: 20, State: 3

Runnable jobs

SQL 2K to SQL 2K5 : Upgrade in place ?

how to transpose a table using sql statement

After rename the computer

Isolation level setting scope

Dbo access does not work.

Profiler Events for Unused Indexes

SQL 2005 - REBUILDDATABASE not working

How to execute msdb.dbo.sp_start_job when the user is not member o

Does a database need contiguous space?

DataBase Backup

Use <db>

String Manipulation Performance

No report builder models.

Schema problem - sqlmembershipprovider created on MSSQL2005 then moved to 2000

Renaming machine

accing to shered volumes

recreating system stored procedures

Query name change

Sql 2k Log shipping

'dbo' mapped to non-existent login - what to do? (SQL 2000)

Are clustered indices always in physical order?

Log File Size reduction

Problem with connecting to SQLEXPRESS

Edit a step from a job

How to log each database access (SQL 2000 / 2005)

two instances of sqlservr.exe running

Anyone use Polyserve ?

Storage & Extraction - Importing and exporting file data SQL2005

Problems creating mirroring on 2005.

Questions on 2005 DBMail.

Accessing SQL 2000 servers from 2005 Management Studio

articles on sql 2005

sql server cann't be accessed

equal distribution of start and finish dates

Cant start SQL 2005 with /T 1400.