SQL Newsgroups: Microsoft SQL Server Administration

Remove Non alphanumeric

hatsumoto - 28 Jan 2006 11:14 PM - 3 messages

Hi there, I was wondering if there is a way for me to remove non alpha numeric characters from a String field in SQL? Thanks, Hat ...

compressed and encrypted SQL Server backups

Beth Med - 28 Jan 2006 8:28 PM - 5 messages

hi, does anyone can tell me some program that creates compressed and encrypted SQL Server backups other than SQL LiteSpeed? thanks in advanced! Beth ...

One large database or a few smaller databases?

Jeff Turner - 28 Jan 2006 7:29 PM - 7 messages

Does it make sense to break up data into a few smaller (identical) databases to keep from having hundreds of millions of rows in a few tables in one single database? I ask because I've got a website that's pumping about 500k new records ...

Asking for a little help with sql 2000

TravisF - 28 Jan 2006 6:59 PM - 2 messages

I am an Lan admin, in a bind on this Saturday..I'm going independant, but fairly green with MS Sql. But I can muddle around as needed though. Here's my problem and proposed solution. Can someone verify this? Thanks in advance! ...

...unable to begin a distributed transaction

Young, Corey - 28 Jan 2006 6:30 PM - 2 messages

I have two SQL Server 2003 servers with SQL Express 2005 installed. The servers are not on the same network (and not on a VPN), so they are communicating across the Internet. On both servers, MSDTC is properly configured, the Windows firewall is turned off, credentials are setup ...

Deploying a database to multiple servers - smooth sailing?

Rod - 28 Jan 2006 5:59 PM - 3 messages

Hello, I need to copy a database to multiple servers, all of this using SQL Server 2000. -- this will enable the testing of an application with identical databases. I'm concerned here with the original installation of the database ...

sp_attach_db master not working

harshraj.sanghvi - 28 Jan 2006 11:16 AM - 2 messages

Hi All, I am creating a replica of the data warehouse server. I tried to restore master database by logging in single user mode but that did not work and gave me an error saying "The backup of system database on device E:\Master 130106 cannot be ...

How do i block SQL browse list?

JMCD - 28 Jan 2006 7:54 AM - 4 messages

Hi, I have a Windows 2003 Terminal Server running a 3rd party app that stores data on another 2k3 server running SQL 2000 SP4. When regional sites log into the terminal server they need to change to a different database. When they do this they have to browse for the SQL server ...

SQL Sever 2005 install error

Chuck - 28 Jan 2006 3:43 AM - 3 messages

When installing SQL 2005 i received this error message: SQL Server Setup has determined that the following account properties are not specified: 'RSACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and ...

Backup

Arpan - 28 Jan 2006 3:32 AM - 3 messages

Is there any way by which I can get the database which I had created from the Registry? Due to a sudden power failure, the MSSQL7 directory under the C:\ drive got deleted. I had the DB backup in the BACKUP ...

A database file is demaged, no backup, anyway to fix it?

Frank Lee - 28 Jan 2006 1:30 AM - 3 messages

A database file (*.mdf) is demaged, no backup, anyway to fix it? --frank, using sql2000 ...

Help interpreting DBCC CHECKDB output

pshroads - 27 Jan 2006 11:54 PM - 3 messages

I ran DBCC CHECKDB on a database that has corruption. I don't understand which tables it is telling me have problems. I ran: DBCC CHECKDB ( 'qamain1' , NOINDEX ) WITH ALL_ERRORMSGS Here's a snippet from the output: DBCC results for 'tz_datatype_key'. ...

How to exclude the collation property when scripting a table in SQL Server 2005

Andrew Houghton - 27 Jan 2006 11:17 PM - 2 messages

In Sequel Server 2000 when I used to script the creation of a table, it was possible to go to the scripting options in SQL Query Analyser and switch off the Include Collation statements. However, I cannot seem to find this setting in SQL Server 2005 - can anyone ...

DTS packages in SQL 2005

John Holmes - 27 Jan 2006 10:34 PM - 3 messages

I see them show up under a node called Legacy in Management Studio. What is the plan for migration of DTS packages from 2000 to 2005? We have lots of these that we'll need to migrate that are in use with various SQL jobs. ...

Object Browser in Query Analyzer

MANCPOLYMAN - 27 Jan 2006 10:30 PM - 3 messages

In Test environemnt user has access to DB1, they log in and in the drop down box of DB names is DB1 but it does not appear in the object browser. In Dev environemnt I do the same thing and the user can see DB1 in object ...

Q: insert image into SQL Server

JIM.H. - 27 Jan 2006 9:40 PM - 2 messages

Hello, Is there any way to insert an image into a table with an SQL statement by giving image path? ...

(local) vs. the actual name of SQL Server when using a named instance

Leo - 27 Jan 2006 8:10 PM - 4 messages

Hello, My question is this: in a named instance installation of a SQL Server, when you reference the server as (local) from a Stored Procedure that accesses a table for example, will that point to the Named Instance or will it access ...

Error checking.

Frank Rizzo - 27 Jan 2006 7:22 PM - 3 messages

Forgive me for what maybe a dumb question, am fairly new to SQL. I see a lot of code like this in stored procs: update SomeTable set ThisField = 'This' where ThatColumn = 'That' select @intError = @@ERROR if @intError <> 0 begin ...

database locking malaise / restarting SQL Server fine points

google - 27 Jan 2006 6:51 PM - 2 messages

Our company, primarily a software dev house, also manages an SQL Server DB for one of our clients. A few days ago, we experienced repeated timeouts in our .NET web and desktop applications, which threw this error: System.Data.SqlClient.SqlException: Timeout expired. The timeout ...

SQL 2000 Processor License

dallasja - 27 Jan 2006 6:42 PM - 2 messages

I am upgrading my server from 1 to 2 processors. The licensing we currently have is a 1 processor for SQL 2000. I was told you could only purchase the 2005 licenses and that if I did purchase a 2005 it would be compatible with ...

BLAST (Basic Local Alignment Search Tool)

Fred Pannell - 27 Jan 2006 6:15 PM - 3 messages

Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search BLAST (Basic Local Alignment Search Tool) Thanks. ...

2005 Internal Functions

JB - 27 Jan 2006 5:54 PM - 4 messages

There are several instances where I've seen this sort of thing: %%ColumnEx(ObjectID = @object_id, Name = @identity_column).SetIdentityNotForRepl(Value = @value). Anyone know what the full syntax is, where they are listed, if we can take advantage of them etc? TIA ...

How to make a portabol Database

Neogortex - 27 Jan 2006 5:54 PM - 4 messages

I have a database that I am going to have to travel with for presentations. I have never created a database that I needed to travel with; does SQL Server 2005 Standard have a way to make your tables still work with ...

Auto starting the sqlserver service

FranklinST_Admin - 27 Jan 2006 5:53 PM - 4 messages

Hello all, I am by no means a SLQ admin/DBA I am the Layer2/3 network admin who somehow got thrown into figuring out how to fix an issue on one of our production servers. We have a machine that is regularly rebooted (this is a whole ...

2005 Maintenance Plans

JB - 27 Jan 2006 5:50 PM - 2 messages

Hi, can anyone tell me if it is possible to cycle the backup files. They just seem to append, but I wany to cycle them based on a 7 day period. TIA ...

Alternative to textcopy.exe in SQL2005

jeffromiller - 27 Jan 2006 5:34 PM - 3 messages

We have been using the textcopy.exe tool since SQL7 (we were able to still use this tool when we upgraded SQL2000) - we have a VB6 app that a user can use to attach a file (a .pdf file or a .doc file, etc.) to a "job", or record ...

Sql Server 2005 - Securables - Viewing permissions by User ?

tobemdx - 27 Jan 2006 5:03 PM - 2 messages

When I enter a database role's properties, initially the "Securables" grids are empty and remains empty after adding permissions to objects. If I want to see which permissions are assigned I must click Add/All objects of the ...

AWE Memory

Dario - 27 Jan 2006 4:11 PM - 3 messages

Hello We have 2 servers in a cluster environment with 12 GB each. We install SQL server 2000 in them and use the switches /3GB /PAE and use AWE enable option. We allocated 7GB for SQL along with enough room for the OS and other ...

One data files to multiple data files.

msqldba m via SQLMonster.com - 27 Jan 2006 4:08 PM - 2 messages

Hello. I have a database with single data file and i want to split that data across multiple data files. Coulf u pls help me how to achieve this Thanks, ...

How to reduce the log file size

sasachi sachi sachi - 27 Jan 2006 3:26 PM - 3 messages

Hi There, 1) I have a production database in which log file is growing very drastically eventhough I used "simple recovery model". I am using SQL server 2000. In order to get rid of this log I have been detaching the ...

Repair a Sql Server

GC - 27 Jan 2006 3:14 PM - 3 messages

Hi, I have an instance of Sql Server 2000 on a Windows Server 2000 The server has 2 mirror hard disk On disk failed and we replace it by a new one Since than, some DTS does not work because the connection to another ...

Blank or null datetime variable converts to an actual date

Trishmi - 27 Jan 2006 2:58 PM - 4 messages

Hi, I'm doing dynamic queries. When I try to insert blank or null date data into a table, I'm getting the default value of '01-01-2000' or '01-01'1900' respectively. What I really want it to do is insert a null into the table. ...

Copy and move the database to another server

VBB - 27 Jan 2006 2:47 PM - 3 messages

I have a SQL Server database(NWind) available in a stand alone server. I have a CD writer in this stand alone server. I need to create an instance of this NWind database into another server. How can I copy the database from my first server into my second server. ...

BIG LDF file size

Vikram - 27 Jan 2006 2:07 PM - 3 messages

How to check for LDF file size I.e. my database ldf size is 10 times the size of mdf. is it ok. For having smaller ldf do i need to check for some sp or tune sps and other DTS packages. ...

Faster database

Kyle Bush - 27 Jan 2006 1:47 PM - 2 messages

I have a database called MySessions that holds some volatile information for web sessions. This database should be configured for fastest read/write operations.I don't need to back it up (In a catrastrophic failure I just need to fix the ...

MSDE doubts

uday - 27 Jan 2006 11:02 AM - 2 messages

am having a problem with MSDE. My application uses the MSDE databse. Sometimes when my application is trying to connect to database (PMP_v3_0), then the following error is generated: Description = Cannot open database requested in login 'PMP_v3_0'. Login fails. This error is also getting to other databses sometimes: ...

sqlserver2000 --> sqlserver2005

Hrvoje Voda - 27 Jan 2006 10:16 AM - 2 messages

Is it necessarie to 'upgrade' old database 2000 to database 2005? I tried to attached it and it works. Hrcko ...

Installing SQL 2005

PIT - 27 Jan 2006 9:08 AM - 4 messages

Hi, i haved installed SQL 2005 and i didn't while installing any option that i can tell to setup install database on another drive. Now how can i change die database and programm on diferent drives? Thanks PIT ...

log shipping enquires

maxzsim via SQLMonster.com - 27 Jan 2006 8:58 AM - 7 messages

Hi, I have set up log shipping in the following : load/copy frequency - 1 mins backup frequency - 5 mins secondary db - standby mode issue : when i made some changes to a record of the primary db's tbl , it was not ...

Syncronisation of multiple databases

Vinci - 27 Jan 2006 8:15 AM - 2 messages

Hi All, Currently I am working on a project where we have run into a few problems. The current application we are redesignig is the core of the business. The application writes ito the database from which 8 to 10 other ...

Insert data into nText Row by Row

Kamal Ahmed - 27 Jan 2006 7:49 AM - 2 messages

Hi All, I have a field in table of type nText. I want to store large data in this field. I used UPDATETEXT command to update data in it. But after a specific point i.e. 896 it does not update more text ...

setting up log shipping

maxzsim via SQLMonster.com - 27 Jan 2006 3:26 AM - 6 messages

Hi, First of all , not exactly sure where shld this be fall under which posting group I am planning to setup log shipping for a db and i believe my SQL Server 2000 is Enterprise edition (how can i check btw) ...

How to copy object between SqlServer 2005

ad - 27 Jan 2006 3:06 AM - 2 messages

How to copy objects like View or Tables from on SqlServer 2005 to another? ...

Adding Linked server

David - 27 Jan 2006 1:29 AM - 3 messages

Hi guys, My linked server (from one SQL Server 2000 to another SQL Server 2000) is not working. My settings are as follows: Checked other data source Provider string: DRIVER={SQL Server};SERVER=SERVER_NAME;UID=TEST;PWD=TEST; Under Security tab: ...

Can not connect remote SqlServer

ad - 27 Jan 2006 1:09 AM - 2 messages

I can not connect a SqlServer (version 2005) in remote. I have checked there are no firewall problems, and the server have been set to allow remote connection. How can I do? ...

need stored proc to append table 1 to table 2

Paul - 26 Jan 2006 11:10 PM - 4 messages

HI just wondering if there is a simple transact statement to use to copy the contents of table one and append it to a second table. Each table has the same columns and datatypes, thanks. ...

Cannot generate SSPI context

Covi - 26 Jan 2006 10:59 PM - 2 messages

Hello to all, thanks for any assistance... This problem just started with in the last day. Accessing a SQL Server from Enterprise Manager(EM) on my note book. However when I access via EM on the local sql server, windows authentication works fine... ...

Need Urgent Help!

Me - 26 Jan 2006 10:23 PM - 2 messages

I imported xl spreadsheet data into sql server. Some data is converted with <NULL> value even though the data exists in the xl spreadsheet column. The funny part is it is not <NULL> for the entire column. For eg. I have a ...

easy way to list tables & columns?

Bob - 26 Jan 2006 10:15 PM - 3 messages

I have a newbie question about MS SQL EM: Is there an easy process to list all the tables and columns of a particular database? I just got this task and I wouldn't know where to start just yet. ...

Deleting additional data files in a database primary filegroup

kdirks - 26 Jan 2006 9:27 PM - 3 messages

I created two additional data files in our database so that when the primary location was full it would write to the added files. I though it would write to the 2nd file and fill it before writing to the 3rd. It is writing to ...

Object ID to Page List

Frank Rizzo - 26 Jan 2006 9:26 PM - 2 messages

I'd like to get a list of all the pages that are contained in a certain table. How do I go about it? Thanks. ...

Processor question

Alex Anderson - 26 Jan 2006 9:15 PM - 5 messages

Hello Everyone, When a certain platform let it be standard or enterprise, the processor limitation on Standard is currently 4. Does that mean 4 physical processors or if you had 2 physical processors with hyper threading which in Windows ...

Microsoft SQL Server Management Studio Express - Release Date?

JohnJohn - 26 Jan 2006 9:08 PM - 2 messages

Does anyone know if Microsoft has set a release date for Microsoft SQL Server Management Studio Express? I haven't been able to find any info on their web site, so my guess is no. :) Thanks, John ...

Logical

Joe K. - 26 Jan 2006 9:08 PM - 2 messages

I would like to re-index two tables (t1 and t2) if the logical scan fragmentation is greater 80% on these tables. Please help me create a t-sql script to create this task. Thank You, ...

update multiple records in one go

Nitu via SQLMonster.com - 26 Jan 2006 8:22 PM - 2 messages

I want to update multiple records in one instance, it can even be a storedprocedure. I have data from user on a asp page. these are number of records with different unique identifiers. how can i update the corrensonding table with ...

Problem using BCP

Eduardo Sicouret - 26 Jan 2006 8:09 PM - 5 messages

Hello, I have the following scenario: I need to migrate several SQL Server tables to MySQL 5. The tables have aprox. 2'000.000 so i need to use the SQL Server BCP program because is the fastest. The problem is with the Null handling. With BCP the Null is a '' empty ...

Windows Authentication with sp_addlogin

blinky44 - 26 Jan 2006 8:09 PM - 4 messages

Hey, I want to use sp_addlogin through VBScript to add a user to the SQL Server with Windows Authentication. Anything I have found this far says I need to hardcode a username and password, but if I am using ...

Insufficent memory to run this query

Pyush Kumar - 26 Jan 2006 7:40 PM - 3 messages

We're rolling out a new version of our application thatincludes upgrading to SQL Server 2005. SQL runs on the following hardware 1) DELll 6650 with 4 3.0 GHZ processors 2) /PAE /3GB 3) 16 GB RAM 4) EMC CX700 SAN ...

Free up the transaction log

Prabhu - 26 Jan 2006 7:31 PM - 8 messages

Hi , When full db is backed up (using maintenance plan) , does transaction log get shrunk (inactive transactions are dropped from log) . Also does this space get released to OS . Can you pl. let me know answer for same question , when log is backed up ...

Maximum number of logins?

DJ - 26 Jan 2006 7:03 PM - 8 messages

SQL Server 2000 Enterprise SP3a Is there a limit on the number of logins that can be created? ...

EXEC security question

Chris Patten - 26 Jan 2006 6:12 PM - 6 messages

I am not an expert with SQL security first of all. I have a sql user account setup and I want to grant database wide SP EXEC access, is there a way to do this or do I have to grant each SP EXEC access on that users ...

Kill command don't work

Teo(I) - 26 Jan 2006 5:51 PM - 4 messages

I've this problem: A process (SPID 62) with some locks on some tables. The application which had generated the query are not running, is closed! In SQL server I can see the SPI 62 that are blocking other users. ...

Query 6.5 db

ChrisD - 26 Jan 2006 5:09 PM - 4 messages

I know that 2005 does not support dbs with 6.5 compatibility level. However, I can see the db and I can run a query against it. If this is possible and works great, why can't I view/edit the SPs that are on those dbs? It is ...

DTS (Data Transformation Services)

SteveS - 26 Jan 2006 5:05 PM - 3 messages

Given: I'm using a DTS Package to import data into a table. Each row from a text file gets placed into a corresponding table. What I need to do: I'd like to modify the DTS Package to change the data saved to a table based ...

Missing sysjobhistory in sql job

mecn - 26 Jan 2006 4:36 PM - 3 messages

Hi, I have a sql2k job to do the log backup. For some reason, I don't see the job history. When it finish running I see the job history "completed sucessfully". Next morning the history disappeared. I ran the trace over night and search ...

SQL Server Integration Services

Arne - 26 Jan 2006 4:28 PM - 2 messages

Where can I find some documentation? I am looking for a step by step getting started example. ...

timeout trouble in SQL Server 2005

Contraptor - 26 Jan 2006 3:56 PM - 2 messages

In December my company converted our databases/server and all of the applications that connect to it to MS SQL Server 2005 when we had been running InterBase 6.x. Since then queries return much faster, except there will be periods throughout the day ranging from 5-45 minutes ...

NIC Card in SQL server

Niles - 26 Jan 2006 3:15 PM - 2 messages

The network folks would like to change the NIC on SQL server to support a new Gig port that the server will be connecting to. Any issues that may affect any databases that I should be concerned about? Thanks, ...

Urgent: Can't (Re)Attach Database

joey.powell - 26 Jan 2006 2:35 PM - 2 messages

Please forgive me for cross-posting this message. I left it in another group but never received any solutions. Hello, We temporarily lost a raid array that was housing a SQL database (MDF and LDF files) for our web site. When we fixed the problem with the ...

TCP/IP is faster than named pipes?

Gaspar - 26 Jan 2006 2:33 PM - 4 messages

For a client computer to connect to SQLServer, which method if faster: TCP/IP or name pipes? ...

Problem

Michele_ISP - 26 Jan 2006 2:31 PM - 5 messages

I do link between two Server but when execute a sp like this create procedure sp_Prova as select * from MICHELE.ISP003a.dbo.CAT_MERCE GO I have this result: erver: Msg 7391, Level 16, State 1, Procedure sp_Prova, Line 2 [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be ...

Licensing and operability with two processors

Ant-nee - 26 Jan 2006 2:01 PM - 4 messages

Hi, I have a SQL Server that has two processors installed. I only have one Per Processor license to use. Right now, I put a /onecpu switch in the server's boot.ini to limit the server to one processor. I don't like this solution for two reasons - a) the ...

can't get in anymore

middletree - 26 Jan 2006 1:55 PM - 4 messages

I installed SQL 2005 on a new machine last week. Created a database using scripts. Worked fine for a few days. Yesterday, I attached a database that had been created on another machine, with SQL 2000. Seemed to work fine. I closed SQL Server to work on something ...

Shink log

Gaspar - 26 Jan 2006 1:44 PM - 3 messages

In 2-3 days of work my transaction my transaction logs grows up to 500 Mb (is it normal?). So I do the following: 1) BACKUP LOG Mydatabase WITH TRUNCATE_ONLY 2) Using SQLManager I shink the log (truncate free space) and returns to 500 ...

Add a user via a script

Chris - 26 Jan 2006 1:41 PM - 3 messages

Hello All, I've got a script that will Create a Database and install the tables onto a SQL server. what code is used to add a user/username and password to allow the user to login? I am aware that I can do this from the SQL Server, However, I've been asked ...

DBCC CheckDB and CheckAlloc

Tom Frost - 26 Jan 2006 12:35 PM - 2 messages

I've recently joined an organization which has no practice of regularly running DBCC's with the explanation provided that since SQL Server is now file based and many improvements have been made to the file system, that file corruption/database corruption including allocation issues are no longer a ...

Seeking Recommendation Confirmation

Robert R via SQLMonster.com - 26 Jan 2006 12:28 PM - 6 messages

I have a SQL2K enterprise box with performance issues. It is composed of a single RAID 5 with 6 disks, identified as the "D" drive. It has 8Gb RAM, a fixed memory setting of 6079, with AWE enabled and 3GB/PAE set in boot.ini. ...

No process is on the other end of the pipe SQL 2k5

Joe - 26 Jan 2006 11:45 AM - 7 messages

SQL Server 2005 Developer Edition, running on Server 2k3/SP1 (not a domain controller). Setup with pretty much all defaults. When accessing the server using sqlcmd (both client and server running locally), I get the following error on a regular basis . Seems to require me to restart SQL ...

Statement settings

Gerko - 26 Jan 2006 10:51 AM - 2 messages

When use SQL Server Management Studio (SQL 2005), how can you see if READ_COMMITTED_SNAPSHOT is ON or OFF? ...

SQL Server 2000 Editions details

James - 26 Jan 2006 10:21 AM - 10 messages

Hi Does someone have the Microsoft Site link for the SQL Server 2000 Editions restrictions please? I can only find the SQL 2005 editions details. I need to prove to a customer that SQL 2000 Std cannot read over 2GB RAM. ...

perfmon collection into SQL table

Hassan - 26 Jan 2006 6:34 AM - 2 messages

How can i run perfmon and have it collect data into a SQL Server table ? ...

Production debugging of SQL Server 2005 without VS 2005?

Alan Cobb - 26 Jan 2006 4:00 AM - 4 messages

Hi, Apparently Visual Studio 2005 is normally needed to debug SQL Server 2005 problems. For example stored procedures written in managed code. What is the recommended way to do debugging on a production server that doesn't have VS ...

Page ID to Object ID

Frank Rizzo - 26 Jan 2006 1:54 AM - 3 messages

I have a page id. How can I find out what object it belongs to? I am running Sql2k. Thanks ...

Interpreting deadlock info

Frank Rizzo - 26 Jan 2006 1:29 AM - 2 messages

I have a trace flag 1204 on my sql2k box. It prints out deadlock info when they occur. I got the dump below. My question is how to interpret a line like RID: 9:1:587432:0 ...

Backup only new databases

CR - 26 Jan 2006 12:45 AM - 3 messages

Is there any way with SQL 2000 SP3a to backup all new databases that have been created and have not had a full backup run yet? ...

Copying database to same machine?

gman997 - 26 Jan 2006 12:27 AM - 2 messages

Hi all, I've read a lot of posts about copying a SQL database to a separate machine; but, what about to the same machine. In practice for others who have done what is the simplest reliable method? Also, is there any reason not to detach the database, copy the physical ...

Displaying Failed job in SQL Server 2005 Management Studio

imarchenko - 25 Jan 2006 11:54 PM - 3 messages

Hello! I have noticed that failed jobs in SQL Server 2005 Management Studio have the same icon as succeeded. This makes difficult visually identifying ones requiring immediate attention. Am I missing something? Is there a way to assign different icon to failed jobs? Currently I have to inspect each ...

Restoring SQL server from log files

bertiew - 25 Jan 2006 11:18 PM - 12 messages

I am using SQL serve. We have a probelm after our log backup have been damaged. Problem is we have only log files for the daily backups. ie., after the entire datbase files were backed up few days ago, it has been a daily ...

Link Server problem

Jamie - 25 Jan 2006 10:25 PM - 3 messages

Hi, there, I have two SQL Server 2000, which are SQLA -- with SAN connected; SQLB -- just a bald SQL Server. I want to set up linked server from SQLA , so I can run query like "select * from SQLB.dbname.dbo.tablename". The command I use is ...

Scalability questions for extended stored procedure

ppateel - 25 Jan 2006 10:01 PM - 4 messages

Hi, First I would like to apologize for cross posting in three groups as I did not know which one would be the appropriate group. If some one points me to the correct one I will use that in the future. ...

Failed to notify 'operator name' via email????

Amit - 25 Jan 2006 9:43 PM - 2 messages

Following command sends email fine: EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test message' However, SQL Job with a notification to above operator doesn't work. Job history comfortably mentions following with no other clues: NOTE: Failed to notify 'operator name' via email. ...

Memory issue?

Robert R via SQLMonster.com - 25 Jan 2006 9:08 PM - 6 messages

I am running SQL 2K enterprise having 8GB RAM, with AWE enabled, using the 3GB/PAE switch in the boot.ini. Fixed memory is set at 6079MB. I returned the following performance counters and was hoping somebody could tell me if there ...

hand under database icon

mecn - 25 Jan 2006 8:48 PM - 3 messages

Hi, How do I disable the "hand" icon right under the database icon in sql enterprise manager? Thanks ...

truncate table

DeeJay Puar - 25 Jan 2006 8:38 PM - 3 messages

I need little clarification on truncating tables. Here is what BOL sys: TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable. Just to make sure I undertand it correctly: ...

Physical Disk bottleneck?

Robert R via SQLMonster.com - 25 Jan 2006 6:54 PM - 5 messages

I am running SQL 2K enterprise, using RAID 5 with 6 disks. I returned the following performance counters and was hoping somebody could tell me if there are any signs of disk bottlenecks. The values specified are in the order of ...

query syntax issue

Mark - 25 Jan 2006 6:47 PM - 3 messages

What is the difference between use [aes50] DBCC SHRINKFILE (N'aes50_Log', TRUNCATEONLY) And use [aes50] DBCC SHRINKFILE ('aes50_Log', TRUNCATEONLY) What does the N represent? ...

Job Schedule

John Carlton - 25 Jan 2006 6:41 PM - 3 messages

I would like to view all the scheduled jobs , sorted by Next Run Date. When I use Enterprise Manager and sort by that column, they are not sorted correctly. Suggestions? ...

database (read-only)

Arne - 25 Jan 2006 6:00 PM - 3 messages

I attached a database with sp_attach_db but it ended being read-only. Is there a script that can change my database from being read-only? ...

Pretty Display of XML

elaineuk123 - 25 Jan 2006 5:47 PM - 2 messages

Can anyone tell me if there is a simple way to force the FOR XML output to generate the Tags and Attributes in a human friendly format. Many thanks in advance. ...

Queries in parallel

Robert R via SQLMonster.com - 25 Jan 2006 5:34 PM - 4 messages

I have some users running an application against a SQL 2k enterprise database with 4 CPU's. When multiple users execute the same task in the application at the same time, it appears from a duration standpoint that the ...

Is there a migration path from Sybase to SQL2005?

Decimal values

SQL XML and 2034 limit

SQLExpress and OSQL

Page Size

Log File Truncation

What's the recommended way for me to keep two databases in sync?

sp_updatestats

Cannot add MSDE registration

Simple Query hangs!!!!

date/time fields

How SQL server databases are safe ?? URGENT

Problem with SQL Agent using Database Mail

run an external file

Query returning inconsistent results - please help

how to reset identity field value

Work with 2 same database with 2 differents name

How can I get the @x?

remember old passwords

How to change server name in SQL2K ?

incremental Population not starting

Named instance connection problem

SQL Server conversion tools

SQL Server Service don't start

Dependencies.

Bulk Insert in 2005

How to force a recompile on the stored procs?

Backup in MSDE

Monitoring Query Performance

Comparing 2 SQL Server Database schemas

Slave (replicated) database to improve SELECT performance?

SQL Server Agent stops

Restoring a large database

Transaction logs won't backup

Need a real-time replication mechanism.

Ability to import Data into SQL Server Express Edition

faster box but slower database

Restore database from a network drive

Sql 2005 can't update maintenance plans?

How to drop a full-text that references an invalid path

ID SQL CPU hog

SSIS subsystem failed to load

SQL 2005 performance

OpenQuery with variable

SQL Server Performance Counter

combining tables

Leading Zero's Quick Help!!!

CURSOR OPERATION CONFLICT

Recurring problem of unused space in SQL Table

SQL Server 2000

Developing for 2000 (SQL8) on 2005 (SQL9)

Where is the Wizard tool in SQL 2005?

Performance difference between SQL 6.5 and SQL 2000 server

SQL Server named instance problem with Windows Server 2003

Can I run SQL 2000 with a SQL 2005 license/CALs

Model and File Paths

How can I tell when a password was changed

migrate database incl. user and password to other server

Scheduled Task to restore Database ?

Restore mdf file

restrict user access

Dynamic memory setting

SQL Mail

log files

XP_SENDMAIL

Licensing SQL Server Tools

Restricting access to certain applications

SQL to read errors from event log ?

Urgent : SQL Monitoring

Sql Server Data Cleansing

Select query from a file

visual basic transformation script

can't delete log files

Reads in Profiler

Deadlock on TAB level

Mem to Leave...

minimum value

Monitoring Trans Log

PhysicalDisk: % Disk Time

Don't print anything on screen

SQL Server Name CHange

Available Memory

SQL hardware spec ?

Attaching & Detaching SQL 2000 Databases

Linking Excel and SQL

SQLExpress

Index Changes

Problems using Linked Server.

Check Data and Index Linkage FAILED

Could not locate file 'data01_log' in sysfiles

Commit, rollback...

TO DO List for HA DB Server

Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server

[SQL2005] Backup Schedule

Upgrade database from SQL 7 to 2000

Owner of a database

SQL server RAID and query parallelism

FillFactor and Intermeditory Pages

Cannot Generate SSPI Context

MSDE 2000 and SQL 2005 Express on one machine

Sysindexes table error - cannot repair

Restore

Benefits of 64bit SQL?

Writing time problem

SQL Server 2005 and VS2005

SQL Server 2005 Express

Unable to grant rights to user

SQL 2005 unrestricted log file

Changing the database from MSAccess to MSSQLServer.

Backup