SQL Newsgroups: Microsoft SQL Server Administration

conversion

jack.smith.sam - 28 Oct 2006 9:19 PM - 3 messages

Hi All, I am pretty new to sql server. I have a column with data in the format of #ddd,dddd where d is a number between 0 and 9. e.g. one entry of column #34,56 What is the easiest way to convert it to integer? #56,5-->565 ...

Open View from SQL Server Management Studio

515331Jack3490 - 28 Oct 2006 8:20 PM - 2 messages

Why the order is lost when I Select Open View?? My query really includes an ORDER clause and the Execute query was fine. ...

2005 x64

param - 28 Oct 2006 6:34 PM - 7 messages

Hi all, We have a 2-node SQL2005 SP1 cluster running right now connected to an EMC SAN. We are considering moving to the x64 edition of SQL for performance reasons. The servers currently have 64 bit CPUs, but are running 32-bit OS ...

Hi, trouble with the db owner

Emmanuel - 28 Oct 2006 4:49 PM - 2 messages

Hi everybody... I'd like to change the db owner in a SQL Server 2000, is it possible? I'd like someone to tell me how can i do this ...

Update Query

Goldking - 28 Oct 2006 6:48 AM - 4 messages

Hi all, I need ur help. I have data like this. Table name : mytable. ...

about deployment with database

raju - 28 Oct 2006 6:00 AM - 10 messages

Hai, We created one application, in .net with sql server 2005. we created the setup file also. Now we want to install the application in client place, But, client don't have any sql server in their system. I heard about with ...

problem with distribution agent-

Vishal - 28 Oct 2006 4:22 AM - 2 messages

Can anyone help me on this?? I have a transactional replication going on from Server A to server B (Sql Server 2005) The replication was working well till yesterday.. But now, the replicated transactions are not getting applied at the ...

Do some statistics on calling a specific stored function

Ivan - 28 Oct 2006 4:18 AM - 2 messages

Dear all, We would like to keep a counter on how many time a specific stored fuction is called. At first, we want to add this counter inside the function but update record to table is not allow in stored function. ...

Replication Problem? Very high undistributed commands --transaction replication

Vishal - 27 Oct 2006 11:17 PM - 5 messages

Can anybody help me we have a transactional replication going on from server A to Server B. (sql server 2005) The replication working properly till yesterday..but now i dont find the recent data at subscriber .. synchronization status shows "Delivering replicated transactions" When i checked replication monitor ...

automated testing

Alex - 27 Oct 2006 10:41 PM - 4 messages

Hi friends, Are there any tools for automated testing on server side code on market? Thanks a lot in advance Alex ...

Block MS Office Connection

T Morris - 27 Oct 2006 10:10 PM - 4 messages

SQL Server 2000. Is there a simple way to block MS Office connections to a SQL Server database? Thanks, Tom ...

Number of Days Of Week

Jim.Mueksch - 27 Oct 2006 9:43 PM - 2 messages

Hi, I need to find the number of Mondays within a given date range. Example: How many Mondays between 01/01/2006 and 06/30/2006. ...

SQL Server 2005, SBS 2003 Premium

Timothy Peer - 27 Oct 2006 9:36 PM - 6 messages

Yesterday I upgraded an SQL Server 2000 to 2005 (rolling upgrade). When 2005 was installed, I selected the Windows Integrated Securityand subsequently changed security to Mixed Mode from the Management Tool. Problem: .NET ASPX pages which reference a 2005 database are not ...

SQL Server running data off of USB / Firewire hard drive

mrobins - 27 Oct 2006 9:20 PM - 2 messages

Does anyone have any experience setting up SQL server with the data stored on an external (USB / Firewire) hard drive. This setup would be used by 1 or 2 users for data analysis, it would not be intended as a production server. ...

About implicit transactions in temp table

UncleSam89 - 27 Oct 2006 8:57 PM - 3 messages

I have a .net program which usually create temp table in SQL Server 2005 and populate it from com contrlol to apply later to the main table.But sometimes I need to delete some of previously inserted rows to replace them with maybe ...

Number of Days Of Week

Jim.Mueksch - 27 Oct 2006 8:51 PM - 2 messages

Hi, I need to find the number of Mondays within a given date range. Example: How many Mondays between 01/01/2006 and 06/30/2006. ...

SQL Server running data off of USB / Firewire hard drive

mrobins - 27 Oct 2006 8:02 PM - 4 messages

Does anyone have any experience setting up SQL server with the data stored on an external (USB / Firewire) hard drive. This setup would be used by 1 or 2 users for data analysis, it would not be intended as a production server. ...

ratio of disk traffic to network traffic

DCole - 27 Oct 2006 7:40 PM - 3 messages

What is a normal ratio of disk traffic to network traffic on a SQL Server? I've got 5x the disk traffic as network traffic and wondering whether this indicates inefficiency in query design. ...

Table locks / logging

Mike M - 27 Oct 2006 6:59 PM - 5 messages

I have a client who is repeatitly looking at SQL tables in SQL manager when our software is making an attempt to write and update those tables. I'd like to impliment a logging program that will log each time the table is ...

Sql Database Recovery

inter - 27 Oct 2006 6:49 PM - 7 messages

Can not attach database, Error message; The file you've specified is not a valid SQL Server database file. mybe Database some corrupt. ...

Check Disk Size in SQL 2000

cpatel1 - 27 Oct 2006 5:37 PM - 2 messages

I was wondering if there is a way to check the total disk size using SQL 2000. There is a function to check how much is left, but havnt found anything to check total size. ...

Where does "Application" come from in Activity Monitor?

Jeremy - 27 Oct 2006 5:25 PM - 8 messages

In sql 2k5 activity monitor, there is a column labelled Application. It is showing names for applications in some cases. Where is it getting this name? I ask because many are blank for apps we've written internally, or in ...

How to Restore SQL2K Full bkup then tran logs?

Chris - 27 Oct 2006 5:23 PM - 2 messages

I am upgrading from SQL2000 to SQL2005 - I want to restore a full SQL2000 backup, then the transaction log backups to 2005. Am getting error below w/ full in standby - How to resolve? Thanks. RESTORE DATABASE [MyDB] FROM DISK = N'\\srvimgdb2\bkData\MyDB.bak' ...

SQL2K cumulative/rollup hotfix build 2187 stable?

DisgruntledTechGuy - 27 Oct 2006 5:02 PM - 3 messages

Does anyone know when exactly this cumulative hotfix was first released, as dates on MS KB articles change as the article is updated, making it difficult to tell? More importantly, is it stable. For example, the SQL2K cumulative hotfix/security rollup build 818 was the standard for quite some time, so ...

Incorrect syntax near keyword "function".

Rockitman - 27 Oct 2006 4:25 PM - 2 messages

First a little history: We have a Pentium II server running SQL 7.0. The SQL has a database that our users connect to using a client front end app that was created by a former programmer in our office. The file server name in the beginning was ...

Explain temdb please

labsRcool@community.nospan - 27 Oct 2006 4:19 PM - 5 messages

I understand that tempdb is a "temporary database", but in the real world, can someone explain: 1)In the real world, when would I use tempdb? 2)Is it imporant that I understand tempdb? - Or is it rarely used? ...

Updating linked server table

danielp - 27 Oct 2006 3:10 PM - 2 messages

Hello, I am trying to execute something like the following (SQL Svr 2000 on Window svr 2003): UPDATE SeerverA.Database.dbo.Table1 SET col=(SELECT col FROM ServerB.Database.dbo.Table2 AS T WHERE t.colPk= ...

Connections

Erencan SAÐIROÐLU - 27 Oct 2006 2:34 PM - 3 messages

Hi Folks, I have a question. I've developed a desktop application. But i can't decide sql server connection strategy. The application uses by 15-20 Windows client and it connects to same sql server. What am i do ? ...

Transaction Log Backup Job Failing

Steve - 27 Oct 2006 2:27 PM - 13 messages

I'm currently trying to setup a transaction log job using SQL Server 2000 and Enterprise Manager. Other jobs have been setup (database backup), however, this job always fails. I receive this error for 'Step 1' when expanding the history to show step ...

Maintenance Plan

Brandon - 27 Oct 2006 1:41 PM - 3 messages

I have a maintenance plan that is setup to delete backup files older than x days. And it was deleting the files just fine until a few days ago . . . now it will not delete older files. I even setup a new maintenance plan and ...

Open Connection

Erencan SAÐIROÐLU - 27 Oct 2006 1:08 PM - 3 messages

Hi to all, I know that we should close sql connection when it's complete its job for performance and sql server's resources. But i can't find article or text for this subject on the internet. Or i know not true? ...

Performance

Erencan SAÐIROÐLU - 27 Oct 2006 1:07 PM - 2 messages

Hi to all, I know that we should close sql connection when it's complete its job for performance and sql server's resources. But i can't find article or text for this subject on the internet. Or i know not true? ...

Adding Data Files

Hari Seldon - 27 Oct 2006 1:01 PM - 8 messages

I inherited a server with a database that has 3 data files in the primary filegroup, but SQL Server is only writing to the first one. It looks like the 2nd and 3rd files were not created when the database was created, but ...

Performance

Erencan SAÐIROÐLU - 27 Oct 2006 12:37 PM - 2 messages

Hi to all, I know that we should close sql connection when it's complete its job for performance and sql server's resources. But i can't find article or text for this subject on the internet. Could you share with me if you have like this article ? ...

Developer Edition

Prad - 27 Oct 2006 5:01 AM - 5 messages

Hi All, I have a question regarding the usage of SQL Server 2005 Developer Edition. Can I use it in a client - server architecture say I install Developer edition on a server and install client tools(Management studio / profiler) on desktops and acess as we use Enterprise Edition? The purpose is only ...

query governor for users?

DallasBlue - 27 Oct 2006 2:05 AM - 2 messages

How to make only some users not to run long running blocking queries ? TIA ...

Replacement for sysprocesses dbid?

stavros - 26 Oct 2006 11:20 PM - 2 messages

In SQLServer 2005, how can you select just the processes that are connected to a specific database? In 2000, I could do it with this query: select * from sysprocesses where dbid = 5 BOL recommends using any of the dynamic management views ...

init DateTime to UTC time?

David Thielen - 26 Oct 2006 10:25 PM - 3 messages

Hi; Is there a way to have the initial value for a column be the UTC time rather than the local time? ...

How to Use Fixed memory Size in SQL Server 2005

sheinaz - 26 Oct 2006 10:11 PM - 2 messages

Hi all, I will label myself a total newbie and i desperately need direction. Here it goes...I installed SQL Server 2005. I am trying to follow direction and set the memory to use fixed memory size. I can not find ...

How to Use Fixed memory Size in SQL Server 2005

sheinaz - 26 Oct 2006 10:08 PM - 8 messages

Hi all, I will label myself a total newbie and i desperately need direction. Here it goes...I installed SQL Server 2005. I am trying to follow direction and set the memory to use fixed memory size. I can not find ...

Table Truncation in SQL2005

Chris Wood - 26 Oct 2006 9:22 PM - 2 messages

Hi, In SQL2000 if we truncated a table we had to take a full backup otherwise the log chain is disrupted. If you tried a log backup after the truncate table it would complain. This is not happening in SQL2005. A simple truncate ...

Deadlocks and trace 1204

Ron - 26 Oct 2006 9:16 PM - 4 messages

We had a deadlock the other day and would like to identify the offending process. Is it too late if there were no traces? If we set trace 1204 to capture future deadlocks, will it write to the sql ...

Copy Database Wizard Problems

Jim Zhao - 26 Oct 2006 8:43 PM - 6 messages

Hi, I am trying to use the copy database wizard to copy a database from SQL server 2000 to SQL Server 2005 on the same machine. When I run it, it fails on the create package step with error message "Error loading type ...

Integration Services Install only

DXC - 26 Oct 2006 8:40 PM - 5 messages

Can Integration Services only be installed on a server without installing any other componenets of the SQL Server 2005 ?. If so, do I need a separate license for it ? I have SQL Server installed on a Server and I am trying to execute a IS ...

Load question: would this be a trivial or non-trivial query for a SQL Server installation to calcula

kenfine - 26 Oct 2006 8:17 PM - 6 messages

I've been asked to speculate about server load issues related to a query we might be interested in running. I have no experience with the specific query in question, and no time to actually generate a comprehensive test with fake ...

How to GRANT VIEW for triggers?

tootsuite - 26 Oct 2006 8:09 PM - 2 messages

Hello, I would like to give our developer here permissions to view trigger definitiions in a db. Usually, when granting VIEW permission, I just run a statement like this: SELECT 'GRANT VIEW DEFINITION ON OBJECT::' + TABLE_name + ' TO myUser' FROM INFORMATION_SCHEMA.TABLES ...

Fatal error exception after SP installation

Catalin NASTAC - 26 Oct 2006 7:38 PM - 5 messages

Hello, I installed one week ago the last SQL SP on SQL 2k5 64 bit / Windows 2003 64 bit. The actual version 9.0.2047. Starting from that day the service restart periodically (one time a day) because a fatal exception. The ...

acc97 switchboard error. 3146 Can someone look and tell a rookie what is wrong?

BrianMultilLanguage - 26 Oct 2006 5:30 PM - 2 messages

Onl;y one user has the problem. I have given them a new copy of the switchboard but same startup error. IOSDSQL 664-964 ENTER SQLSetStmtOption HSTMT 0A0B1EC8 ...

How much performance gained by qualifying tables with dbo. in the database?

Dan Gorrison - 26 Oct 2006 4:55 PM - 2 messages

Hello Folks: The great majority of our queries and stored procedures do not reference the tables with the dbo.table_name format. Due to some production issues, we're not facing a situation that is forcing us to redo our database by scripting it out, making a few modificationsm, and ...

Differential Backup disproportionately large

tootsuite - 26 Oct 2006 3:48 PM - 8 messages

Hello, Just recently I noticed that on one of our databases, the diff backups are HUGE compared to the full backups. For example, the regular full backup is only 80 MB, however the diff backups are 800 MB to 1.2 GB in size. The activity on this database is ...

Can't see D partition

John - 26 Oct 2006 3:01 PM - 5 messages

I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one physical drive divided into 5 partitions. When I choose to backup or restore I can only see C and E partitions but not the D partition. All three are ...

sp_send_cdontsmail Stored Procedures

Joe K. - 26 Oct 2006 2:06 PM - 2 messages

How can I modify the example listed below to use all the parameters that go along with the sp_send_cdontsmail stored procedure? Please give me example that uses all the parameters from the sp_send_cdontsmail. Thanks so much. Example: exec sp_send_cdontsmail 'some***@example.com','someo***@example.com','Test ...

SQLServer2000: estimate diskusage by 1 table?

Erwin Moller - 26 Oct 2006 12:56 PM - 3 messages

Hi group, How can I get (a rough) estimate of the diskusage by 1 table in SQLserver 2000? TIA Regards, Erwin Moller ...

SQL 2005, SQLAgent process

ipramod - 26 Oct 2006 12:40 PM - 2 messages

Is SQLAgent or SQLAgent90 a process of SQL Server? ...

How to identify the progress of running query

Somesh - 26 Oct 2006 12:19 PM - 8 messages

Hi, I am executing an update query on a single table which has tons of rows (approx. 60-70 lacs) therefore the query is taking too much time (in hrs.). Here I am concerned with the progress of query, Is it possible to check the ...

Is it safe to bcp sysindexes out and in

Paul Cahill - 26 Oct 2006 12:01 PM - 8 messages

SQL 2000 sp4 I am trying to move pages held by statblob on sysIndexes. Some are right at the end of my primary datafile. Having done a load of archiving we can get a lot of space back. Is it safe(ish) to bcp it out, truncate and bcp in the sysIndexes table. ...

kb 328551 - splitting tempdb question?

John - 26 Oct 2006 11:50 AM - 3 messages

All, I am testing the remedy specified in subj kb article on a test mssql2k server with SP4. I've added a 2nd file to tempdb and pre-allocated space to both tempdb files now to 1g. I've believed I've turned off auto-grow and system indicates "autoshrink" is ...

Problem while taking script

SouRa - 26 Oct 2006 11:40 AM - 2 messages

Hi all, I have some stored procedures in my database. When I take script of a stored procedure using Enterprise manager from a client system, the alignment of IF, ELSE, END,etc... are changed. They are not in a format that I typed in query analyzer. ...

Strange default location for txn log file on SQL Server 2000

Hans Dingemans - 26 Oct 2006 9:49 AM - 7 messages

On SQL Server 2000 SP3, I run the instpubs.sql script. In it, the database gets created by the command CREATE DATABASE pubs. It turns out that the LDF file has been created on the root directory of the C: drive. When I view the ...

Unable to rebuild non-clustered indexes usng DBCC DBREINDEX.

csajid - 26 Oct 2006 8:33 AM - 5 messages

Hi, I am using MS SQL Server 2000 Enterprise edition with no SP. In one of my database i have one table Mytable on which we four non-clustered indexes. when i issue dbcc showcontig command it is showing below output. ...

Memory

Erencan SAÐIROÐLU - 26 Oct 2006 6:45 AM - 3 messages

Hi All, I have a question. SQL Server 's memory increase always. How can i release SQL Server's memory? When i do stop-start so SQL Server release memory. But i have to release memory a different way. Thaks alot. ...

Log shipping from SQL 2000 to SQL 2005

Hassan - 26 Oct 2006 6:39 AM - 8 messages

I have a DB on Server A ( SQL 2K) and just restored the DB on Server B( SQL 2K5) with norecovery. Now i want to use the maintenance plan wizard in 2000 to set up log shipping but since i cannot register the destination i.e the SQL 2K5 box in 2000 ...

Why not create all stored procedures in master?

stevehunter_1 - 26 Oct 2006 6:31 AM - 2 messages

I would like to move all my stored procedures to master. 1. does it make a difference if i call them sp_myProc, or proc_myProc 2. i am looking to do this because i have about a dozen databases on the server and many of my stored procedures will references the other ...

Learning SQL

Moshe Cohen - 26 Oct 2006 4:13 AM - 6 messages

Where can I find SQL exercises based on Northwind database ? ...

sql 2005 developer edition question

Paul - 25 Oct 2006 11:55 PM - 7 messages

Hi I have vs 2005 and one of the dvds is listed as SQL svr Developer Edtn 2005. I installed this and expected to see SQL 2005 management studio. I did notice that SQL 2005 express seems to be installed, just wondering if ...

Can't start SQL on 2005 Cluster

Leon Shargorodsky - 25 Oct 2006 10:32 PM - 3 messages

The SQL Server (MSSQLSERVER) service terminated with service-specific error 3417 (0xD59). This is what I get on my 2005 Cluster when I try to start SQL on one of the nodes. Another node is running fine, no problems what so ever. ...

Second to the max (aka previous max) logic help.

Matthew - 25 Oct 2006 10:21 PM - 5 messages

I am working on a Query that give the current free space of a drive based upon the latest date and time. However I would also like to get the previous free space so I can compare it to the current one. This is ...

CREATE ASSEMBLY - .dll dependencies fail to load because they need to be Unsafe

Keith - 25 Oct 2006 10:17 PM - 6 messages

Hello, I have an assembly that depends on an interop assembly which wraps a COM ..dll. When I use CREATE ASSEMBLY to load the main assembly into SQL Server, it fails because the server tries to load the interop assembly as 'Safe', ...

Connection Timeout

Chris Marsh - 25 Oct 2006 8:40 PM - 3 messages

Hello, We have a sitaution at a client site where the connection string in the our application times-out on 2 of the PC's yet 2 other PC's work fine and the server works fine. I tried altering the Remote Connection Timeout in the SQL ...

Linked Server

sck10 - 25 Oct 2006 8:05 PM - 4 messages

Hello, I am trying to link to an ORACLE server? I was given the following for the location of the database: login: MyLogin Password: MyPassword (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ihg.mysite.com)(PORT = 1521)) ) ...

ok to install sql2005/2000,vs2005/2003 on same machine

Paul - 25 Oct 2006 7:45 PM - 5 messages

Hi just wondering if anyone has run into any problems installing and running vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003, or if it will effect sql 2000 or vs2003 in any way, thanks. ...

SQL to Oracle

TM - 25 Oct 2006 7:40 PM - 7 messages

Does anyone have any experience using DTS to move SQL to Oracle? I have a very small table (4 columns of basic datatypes) with 1 million rows. My first attempt using Microsoft OLE DB drivers for Oracle took 3 hours 51 ...

300MB DB uses 1.4GB RAM!?

William Bernat - 25 Oct 2006 7:12 PM - 11 messages

SQL Server 2000 running nothing but a 300MB database over the course of a month of continuous use from a single application winds up grabbing 1.4GB of RAM. Is that normal or excessive? (No performance degradation at all, jut a ...

Why can't I retrieve more than 256 chars from my extended properti

Dan - 25 Oct 2006 6:55 PM - 3 messages

Hi, From everything I've read, SQL 2000 extended properties should allow descriptions (or whatever) with a length of up to 8016 bytes. My usage so far of extended properties has had me unable to retrieve more than the first 256 characters of any extended properties I have loaded. I ...

Unwanted truncation on Import - pls help

tootsuite - 25 Oct 2006 6:04 PM - 7 messages

Hi, I am using SQL Server 2005, SP1. This is what's happening. 1.) First, I select the data I want: SELECT CAST(h.Notes AS varchar(4000)) AS Notes, -- this is text field CAST(h.message AS varchar(4000)) AS Message -- this is a text field ...

Select Statement -- Last Date

Jonathan Jesse - 25 Oct 2006 5:36 PM - 8 messages

I have a script that inserts a lot of information into a database, such as computer name, service running, regestry path, and finally date the scan was run. I would like to run a select that would grab only the ...

Index fragmentation issue - SQL2005

Nick - 25 Oct 2006 4:53 PM - 5 messages

Hi, We've upgraded to a SQL 2005 box from SQL 2000 and are having a problem where our indexes are going from 100% unfragmented to 30% unfragmented (According to dbcc showcontig) in the space of 10 minutes when we insert ...

Named Pipes problem on Clustered SQL Server

wuteva - 25 Oct 2006 4:42 PM - 3 messages

We recently have had issues connecting to clustered SQL Server instances and have been working with PSS. I was unable to find any useful information to assist in the troubleshooting process, so I have decided to post this here in case anyone else searches on this like I ...

CPU usage by DB

jason - 25 Oct 2006 3:21 PM - 7 messages

I have a SQL server cluster that hosts about 40 db. The CPU utilization went from an average of 6% to 30%. I did not add any more DBs during this timeframe. I can see from the running processes that it is sqlservr process ...

Object_ID and db_id functions

SalamElias - 25 Oct 2006 2:16 PM - 3 messages

I am using sql functions with some DMVs as follows SELECT * FROM sys.dm_db_index_physical_stats (db_id(), NULL, NULL, NULL, NULL) and getting the following error : Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '('. ...

filegroup and table

SalamElias - 25 Oct 2006 2:13 PM - 6 messages

In SQL studio, when examining a table properties, we can see on which filgroup the table is, Which catalog view/DM /SP can give the same info "on which filegroup my table is"? ...

Query Analyser and SQL Server CPU resource

KayC - 25 Oct 2006 12:26 PM - 2 messages

Hi I use SQL Server 2000 I have 3 sessions of query analyser open with results returned in all 3 windows (no query is currently running but I have datasets in the results panes from past run sql) Can anyone advise me whether this is a drain on the sql server resource ...

Larger (100gig+) SQl database backup time

Stedak - 25 Oct 2006 11:31 AM - 8 messages

We have some databases (100-130 gig) that take 30 plus hours to backup. Is this normal and is there a better way to do this than using the built in backup tools? Or a bteer way to use the tools? ...

Page File Usage Query

Ivan - 25 Oct 2006 9:53 AM - 4 messages

We have doing the server testing on SQL2005 64bit with SP1 The server had 4G Physical Ram. During testing, we saw the Page File Usage in Task Manager reach 4.23G After testing, the Page File Usage drop to 3G. ...

sp_grantlogin and full domain name

Pavel ®ákavec - 25 Oct 2006 8:54 AM - 2 messages

Hi, I have a question. How can I use 'sp_grantlogin' with full domain name? I tried use sp_grantlogin 'KAROLINA.CZ\pavel' but I get this error message: Windows NT user or group 'KAROLINA.CZ\pavel' not found. Check the name ...

Raid for DB server

Louie Lubangco - 25 Oct 2006 2:23 AM - 3 messages

Hi guys, quick question. i have a DELL Poweredge 6850, 4 dual core processor. my problem is what raid configuration would be best suited for my server? I'm thinking of raid 10. Will wait for your response. Thanks, Louie ...

SQL Server 2000 Multiple Intances for performance improvement

Ajit T - 25 Oct 2006 1:47 AM - 7 messages

Hi, Currently at our production server we have SQL Server standard edition and 4GB RAM. But I noticed that SQL Server can maximum use 1.7GB of RAM only and not full 4GB. I know that if we can upgrade to SQL Enterprise/SQL 2005 and ...

SMTP Alerts

Joe K. - 25 Oct 2006 1:46 AM - 2 messages

I have a SQL Server 2000 database server with Windows 2003 operating system. I created the sp_send_cdontsmail stored procedure listed below and configure the Smart Host. Still had no luck send alert e-mail. Please help set up me easy stored procedure to send SQL Server alerts. ...

SQL Server Database Internals

MATTBIONDI - 25 Oct 2006 12:54 AM - 3 messages

Hello guys, I am working in a simple work for my college where I have to choose a database to talk about optimization, structures, transaction control, recuperation, and distribution. I chose SQL Server, but I can't find anything on the Internet. Where can I find this information or which database should I ...

Need to learn best approach to extract SQL2000 data for reporting

pbrill1 - 24 Oct 2006 10:03 PM - 7 messages

I am attempting to learn more about how to best approach the following SQL problem: As administrator for a small/mid-size company running an ERP that still uses SQL 2000 Standard (our ERP software provider has not tested for SQL2005 until ...

Simple DTS to Oracle Failing

TM - 24 Oct 2006 9:36 PM - 3 messages

I have a very simple DTS package that transfers one SQL table to Oracle. I have moved tables like this many times in the past, but today I am getting this message. I ORA-01740: missing double quote in identifier ...

Sybase/Sql server Outer Joins, nulls, and counts

dba_222 - 24 Oct 2006 8:33 PM - 10 messages

Dear Experts, I'm an Oracle guy, but I've been given an assignment to compare data in two different Sybase "databases". Given that I don't have the MINUS, or the INTERSECT command, and in this Sybase version, not even the inline views, I am trying to use ...

how to create .sdf files ?

John A Grandy - 24 Oct 2006 7:44 PM - 4 messages

For a SS05 database , how to create the corresponding SQL Everywhere .sdf files ? ...

Help with addition to Missing date query

Michael - 24 Oct 2006 7:22 PM - 2 messages

Hi Everyone, I hope someone can help out some. I have a report that displays the days our clients missed there sessions. That was working great, and I've got some new requirements now for the report. They needed to store the number of days the ...

How to send e-mail w/o using SQL Mail in SQL Server

Joe K. - 24 Oct 2006 7:20 PM - 2 messages

I have a Windows 2003 server with SQL Server 2000. I am working the Microsoft article [link] to set up SQL Server alerts without SQL Mail. I completed setting up the SMTP virtual server and made sure the SMTP server ...

Query on date/time data type

donsql22222 - 24 Oct 2006 6:26 PM - 4 messages

I need everthing from 1AM to 10:55AM. Can't figure out the syntax. Need from "2006-10-24 01:00:00" to "2006-10-24 10:55:00" I've been trying CONVERT and CAST but to no avail. There's no examples on ...

SQL 2000 performance objects doesnt appear on performance monitor

PV - 24 Oct 2006 5:12 PM - 3 messages

Hi, Machine HP dl3600 2 xeon 3.4+4Gb ram Windows 2000 server + SQL2000 this machine have near 700 dinamic sites with some portals with heavy traffic. Some days ago, due SQL use all the recurses of machine, the machine was a ...

Sum on Time

Leila - 24 Oct 2006 5:04 PM - 3 messages

Hi, I want to store time of each movie and then calculate sum of them. For example the user enters the length of each movie like this: 1:35 or 2:05 ... Should I use datetime type or..? Thanks in advance, ...

Building New SQL Server

a_user - 24 Oct 2006 4:21 PM - 4 messages

Hello all, I am hoping some can spend a minute to educate me a little here. We are looking at building a SQL server for our Network applications. This would be WSUS, our inventorying solution, our helpdesk software and a number ...

Hardware specification query

Robbie Niblock - 24 Oct 2006 4:11 PM - 2 messages

Hi I am specifying some hardware for an application server. It will be running two SQL applications - both applications will have about 20 users. Throughput will be relatively low with regards to transactions. Both software vendors would prefer their own server, but I'd rather keep both on ...

Monitoring SQL Database

Potential Concurrency Issue?

xp_cmdshell returns null

Event Notification vs. Triggers

Disabling SQL 2005 Case Sensitive

distributed transaction

Problems Defragging Indices (SQL2005 64-bit)

DBCC SHRINKDATABASE

dbo.DTA.Tuninglog table

Open Connections - Can't Drop

Capture counters to analyze disk I/O contention

sp_send_cdontsmail Add parameter for SMTP server

BCP for SQL2005

Database Mirroring - unable to mirror 59th database

sys.dm_db_index_physical_stats

SQL 2000 Reporting Services

Why is this SP not working properly?

High CPU usage after backup

Disconnected Edit in SSIS 2005

Windows authentication and SQL login roles

RESTORE FILELISTONLY

SQL 2005 Profiler

Poor row count prediction when using an index on a timestamp colum

How to enable a non-SysAdmin user to start a job

18546

How to distinguish user and system objects in sysobjects

System date/time function

index database

SQL 2005 rerun import package

Determine if database objects are being accessed

Index statement on SQL 2000 vs. SQL 2005

can tables themselves be fragmented? Index ID 0?

Advanced Index Statistics Query

Is the default Owner for an Object always 'dbo' ?

no "properties" option on stored procedures (cant set permissions)

Sorting

SQL error in App Log

SQL Server Sizing - Hardware requirements for SQL Server 2005

sql server and VPN

Database backup time

Storing names in an own table...

microsoft sql server 2005 along with the microsoft visual studio 2005

Index enquiry

Drop identity propert

Restoring a Database

Generating a list of databases in SQL2005?

High performance system and table and index structure

Strange error

memory drop issue again !!!!

Stack overflow on new installation of sql server 2000

RAID & Drive Type for Server?