SQL Newsgroups: Microsoft SQL Server Administration

Error 3621

dogdog - 25 Mar 2006 3:19 PM - 5 messages

For some reason I'm getting the following error on my MS2000 MSSQl server. THe message is being written into my logs on the server. MSSQL Error Msg 3621 The statement has been terminated THis is then followed by the information message ...

Upgrading SQL 2005 Evaluation Edition

Andre S - 25 Mar 2006 2:41 PM - 2 messages

Hey, I am planning to upgrade my copy of SQL 2005 Evaluation Edition (2 instances) to SQL 2005 Workgroup Edition. According to Microsoft this is possible and supported as an upgrade path. Any tips or ideas would greatly be appreciated. I also thought to stop ...

-S.O.S- Error 927: Error 21776:

cdiazs - 25 Mar 2006 11:37 AM - 9 messages

I need your help please. I was restoring a database from backup complete, When I remember that I Not may do it. I CANCEL the accion inmediately. And them when click on BDname properties, say me: Error 927: ... the BD is in restoring accion. ...

Stored Procedures for updating question

Jason Huang - 25 Mar 2006 6:03 AM - 2 messages

Hi, In my company we have 10 different departments. And our company is more like an union of 10 companies rather than a company having 10 departments. Each department has it's own Customer database, and they are quite insisting ...

what user security allows just Stored Procs?

HK - 25 Mar 2006 3:47 AM - 4 messages

In 2005: What SQL Security options will allow the execution of only stored procs? The sprocs do SELECTs, UPDATEs, DELETEs and INSERTs. When I click on the security node inside the database, and then right click a user to see properties, there are "Schemas owned by this user" (such as ...

SELECT INTO question

Jason Huang - 25 Mar 2006 3:32 AM - 3 messages

Hi, In my SQL Server 2000, I have 2 tables, TableA and TableB. Actually the TableB is generated from the "SELECT * INTO TableB FROM TableA" 2 weeks ago. And 2 weeks ago TableA and TableB have same data, saying 500 rows (ID ...

trusted vs sql user connections

John A Grandy - 25 Mar 2006 2:07 AM - 3 messages

For a highly scalable web app, what are the pros/cons or better-fit scenarios for : option 1 : config the sql svrs with "Windows" security mode and have the ASP.NET webapp , any Windows Services, any app servers, etc. always use ...

what does the message after executing BULK INSERT mean?

Quentin Ran - 24 Mar 2006 11:25 PM - 5 messages

Group, when I execute the following statement: BULK INSERT DBName.dbo.TableName from "C:\FolderName\FileName.dat" with (CODEPAGE = 'RAW', DATAFILETYPE = 'native', TABLOCK) the Messages pane in Query Analyzer returns the following message: (159358 row(s) affected) (27 row(s) affected) ...

How to return all tables that have an index?

HK - 24 Mar 2006 10:25 PM - 5 messages

Using 2005 I want to generate a list of all tables that have indexes, so I can reindex them. I don't want to bother doing a reindex on a table that has no indexes. I thought it would be easy enough to pull this data from ...

Copying encrypted stored procedures.

nickwilson.nick - 24 Mar 2006 9:46 PM - 2 messages

I have several stored procedures, created in a development environment, that I need to move to a 'QA' environment, and then in turn, to various production environments. When I move these stored procedures, I would like to encrypt them, using the 'WITH ENCRYPTION' clause. ...

Remote server VS linked server

mecn - 24 Mar 2006 8:55 PM - 4 messages

hi, Could any one tell me what is the diff between remote server and linked server? I know linked server is for current sql server to access tables....... what about remote server> thanks, ...

Script out server properties and configurations

g8r via SQLMonster.com - 24 Mar 2006 7:50 PM - 3 messages

Does anyone know how to script out the properties and configuraiton settings for a 2005 instance to compare with another instance? Thanks in advance if you do... ...

Geometry Data type in SQL Server 2005

docsql - 24 Mar 2006 7:22 PM - 4 messages

Does SQL Server 2005 have a geometry data type? I am trying to figure out to use SQL Server 2005 or Oracle The primary requirement is to be able to use any GIS software in the development of a new workflow, to access data, analyze and map data stored in a database. ...

Yikes! Can't rebuild log because database was not cleanly shut down

Jeff Turner - 24 Mar 2006 6:43 PM - 6 messages

big problems, hoping someone can help. I'm trying to attach a database after a server failure, and it won't let me attach it with the transaction log I have OR w/o the transaction log and trying to get it ...

Model database has unknown owner

jhmosow - 24 Mar 2006 5:30 PM - 9 messages

I am trying to run the sp_helpdb stored procedure and am getting the following results: Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails. ...

Monitor SQL Server?

JSM - 24 Mar 2006 5:05 PM - 3 messages

Hello, I have a request from a client to have monitoring of a specific database in case any errors arise to help them isolate the problem. Would using Profiler accomplish this? Is there a way to set it up so ...

How allow normal users using profiler

RizFra - 24 Mar 2006 4:36 PM - 5 messages

Hi guys, Is there any way to allow a local users using Profiler without SQL System Administrator Server Roles? If yes, how can I do it? Many Thanks Francesco ...

Exponential Growth in SQL log files (.LDF)

Doug - 24 Mar 2006 4:14 PM - 3 messages

We have a customer running our software that is experiencing a strange occurence. We have thousands of customers and this is the only one that has this issue. Recently, we upgraded him from using MSDE to Full SQL. Since, any time he performs certain tasks in our software, the log file ...

Help in setting up SQL Server 2005 Express database and users !!!

mateo - 24 Mar 2006 3:51 PM - 2 messages

I'm working on a project where SQL Server 2005 Express will be installed on a Windows server 2003 server. Two client applications will access the database remotly. One will be for administrative task and the other one just as a reporter kind off application. ...

sql 2005 restore

mecn - 24 Mar 2006 3:42 PM - 5 messages

Hi, Am I able to restore sql2000 backup dumps in sql 2005 server? Thanks ...

What does runnable mean in sql server?

buketwhite - 24 Mar 2006 3:22 PM - 3 messages

What does runnable mean in sql server, process info status? Does iit mean the job is running? Thanks for your help ...

SQL 2000 Enterprise to SQL 2005 Standard

Trevor Miller - 24 Mar 2006 3:10 PM - 7 messages

We find ourselves needing to move from SQL2000 Enterprise to SQL2005 Standard. A former employee mistakenly installed the Enterprise version when we rebuilt our database server about a year ago. We make use of no Enterprise level functions. ...

Move SQL Server 2000 database C: to D: drive

Joe K. - 24 Mar 2006 2:31 PM - 3 messages

What is the best way to move a SQL Server 2000 database from the C: to D: drive? Thanks, ...

Degradation of performance with time

andsm - 24 Mar 2006 1:00 PM - 4 messages

I have OLTP database, 24x5. The database used by application. The application have new version like every half a year. During deployment of new version, old database renamed, creating new database with same structure and move data from old database to new with DTS. After deployment of new version I see ...

problem backing up transaction log

scottrm - 24 Mar 2006 12:00 PM - 2 messages

I am running SQL Server 2005 Standard Edition on Windows Server 2003 SP1 I had a couple of databases which developed large transaction logs. I cleared them out by doing a detach, deleteing the transaction log and re-attaching so it created a new one. ...

SQL Server 2005 Express user instance

Arturo Buonanni - 24 Mar 2006 11:31 AM - 6 messages

Hello, I hope I've posted this question in the right gruop, were wondering if post it here or MSDE group. Anyway, I've a couple of question about the "user instance" mode. I need to attach two or more databases to an instance. I should I do ...

insufficient system memory during Tbackup (maintenanceplan)

Michel van Marion - 24 Mar 2006 10:59 AM - 8 messages

I'm using maintenance plans to make backups of our databases. I've created 2 type of maintenace plans, one for simple recovery model databases and one for full recovery model databases. My plan for full recovery databases includes a hourly Transactionlogfile ...

SQL 2000 Linked Server...

Luca Fabbri - 24 Mar 2006 10:22 AM - 2 messages

Good morning. I have Windows 2003 Advanced Server with SP1 and Clustered SQL Server 2000 with SP3. I need to use Linked Server to connect to Oracle 9i database. So I installed on each node Oracle Network Utilities. After setup Linked Server ...

insert a row with conditions

lnoldori - 24 Mar 2006 9:32 AM - 6 messages

I tryed to find something about this but i couldn't so i am sorry if i am posting something already answered. The problem i have is that i am trying to insert a rwo in a table only if the entries for this user doesn't exceed a certain limit. ...

The new Schemes for users on SQL 2005.

Neil Cadman - 24 Mar 2006 8:57 AM - 2 messages

Hi, I have been trying for the last 2 days now to find a paper on how the new shemea stuff works for users privlages on databases, we have just imported a copy of our SQL 2000 database onto a 2005 server and its moved accross all ...

Prefixing

Shawnmb - 24 Mar 2006 7:11 AM - 5 messages

Hey everybody, I've never had to write a script of this sort, so any help would greatly be appreciated. I'm looking to "prefix" every entry in a certain column, for example lets use column "test2". The data I have is "1" then "2" then "3". How could I append a "k" for ...

Need advice on db maintenance plan

jcvoon - 24 Mar 2006 6:59 AM - 7 messages

Hi: I need advice on creating the maintenance plan. 12:00 AM ~ 1:59 AM DTS / Archive Job 02:00 AM ~ 2:59 AM Full DB Backup 03:00 AM ~ 3:59 AM DB Integrity Check 04:00 AM ~ 5:59 AM Defrag Index ...

page faults / sec -> performance

Tim Moor - 24 Mar 2006 6:06 AM - 3 messages

dear sql gurus, can someone please give me an idea, what (memory) 'page faults / sec' values are acceptable in a normal w2k3 environment. thanx alot tim ...

SQL Server 2005 Query Execution slower than SQL Server 2000

puneet.agrawal - 24 Mar 2006 5:27 AM - 11 messages

Hi, I recently upgraded my database from SQL Server 2000 to SQL Server 2005. To my surprise, few queries which were running very nicely, have become pathetically slow. All the indexes etc. are the same and I'd updated the statistics after upgradation of the database. ...

Version Problem

news.microsoft.com - 24 Mar 2006 3:47 AM - 2 messages

Dear Sir/Madam, Could I install SQL server 2000 (Chinese version) in Windows 2000 Server (English version)? Thanks ...

SQL Server 2000 View question

Jason Huang - 24 Mar 2006 2:00 AM - 3 messages

Hi, I am wondering can we UPDATE or INSERT data in a VIEW, given in SQL Server 2000. Thanks for help. Jason ...

Re: Isn't my SQL Server hardware sufficient for my server load? Why does it keep getting slow?

georgetevelde - 24 Mar 2006 12:25 AM - 4 messages

Try checking the fragmentation of your indexes on teh tables. Rebuilding or Reorganinzing them can dramatically increase performance. puneet.agra***@gmail.com wrote: Try ch ...

Re: bug - insert miliseconds

DickChristoph - 23 Mar 2006 10:47 PM - 2 messages

Hi Dave, Thats curious, in SQL 2000 this script: create table #t (col1 int identity,col2 datetime) insert into #t (col2) SELECT '2006-03-21 18:59:50.985' select * from #t Results in: 2006-03-21 18:59:50.987 ...

SQL Server 2005 Notification Services

Joe K. - 23 Mar 2006 10:46 PM - 2 messages

I would like to obtain the instructions to install SQL Server 2005 Notification services. Thanks, ...

Re: slow insert, logical fragmentation

Erland Sommarskog - 23 Mar 2006 10:41 PM - 10 messages

Dave (daveg***@gmail.com) writes: It depends on what your clustered index is on. If it is on a column that is monotonically increasing, for instance an IDENTITY column or a datetime column with the default of getdate(), then will be few splits, ...

SQL Server Desktop Install

Liz - 23 Mar 2006 10:22 PM - 9 messages

Can I install SQL Server Desktop on an Win XP Media Center Edition computer ? I want to do some limited web development with database access while I'm mobile. Thanks .... ...

TempDB

Soma Shekar - 23 Mar 2006 10:20 PM - 3 messages

SQL Gurus: The "TempDB" database on my sql server 2000 was less than 50MB one day and the following day, it grew to 10GB and I have no idea why. Microsoft says, that "TempDB" will reset to its default 8MB when you restart ...

Converting data to UPPERCASE

John Steen - 23 Mar 2006 9:15 PM - 9 messages

Setup: SQL2000 Server running on Win2k Server I can't find any difinitive answer to this. I need to convert the data in a column to uppercase. Do I simply change the collation from the default of ...

tempdb is locked

airagos - 23 Mar 2006 9:10 PM - 3 messages

Here is the background: - A database user define with readonly access. - Six views to be used by that user - The views reference objects in a different database and the user has readonly access to those tables. - The user does not have access directly to tempdb but they can create ...

linked server problem slow queries

Dan D. - 23 Mar 2006 9:00 PM - 2 messages

We're using SS2000 SP4 on both servers. We've been running the following query for 6 months or so. I'm not sure exactly how long it used to take because the whole job has about 10 queries. But the whole job used to take ...

***Update Trigger ***

kevincristo - 23 Mar 2006 8:49 PM - 3 messages

Hi Group Members Description of table ALPHA col1 int col2 int col3 int Description of table BETA tar1 int tar2 int tar3 int ...

elapsed time vs cpu time

subbu - 23 Mar 2006 8:02 PM - 7 messages

Table 'Worktable'. Scan count 3, logical reads 8, physical reads 0, read-ahead reads 0. Table 'vgn_version'. Scan count 8, logical reads 875, physical reads 0, read-ahead reads 0. Table 'vgn_version_tag'. Scan count 2, logical reads 4, physical reads 0, ...

Sql Server Express 2005

antimon - 23 Mar 2006 6:47 PM - 8 messages

Hi, I am planning a web based game project. And i decided to go with asp.net + sql server. Since it is a personal project i want to use sql server express but i'm not sure about it. It's limitations are known to be 1gb ram, 1 cpu ...

To use or not to use 3GB switch

Hassan - 23 Mar 2006 6:14 PM - 9 messages

We have most of our servers with 8GB RAM and have no other application but SQL Server running. There are lots of conflicting remarks made about the pros and cons of it. Is it best not to use it ? Also, what would one set the max available memory ...

Could not start the SQL Server Reporting Services

jonathan_antoine - 23 Mar 2006 5:43 PM - 3 messages

I am running SQL Server 2005 Enterprise and cannot get the Reporting Service to start. When trying to start the Reporting Service from the Control Pannel/Administrative Tools/Services I get the following error: [ERROR] Microsoft Management Console Could not start the SQL Server Reporting Services (MSSQLSERVER) service ...

How to create schem

hanklvr - 23 Mar 2006 5:26 PM - 2 messages

Hello all, I've always tried to write my SQL script so that they could run multiple times without error so when I was creating a new schema i get an error USE AdventureWorks GO IF NOT EXISTS(SELECT * FROM sys.schemas where [name] = 'temp') ...

TCIP and Naned Pipes

csomberg - 23 Mar 2006 5:23 PM - 2 messages

Windows 2000 and SQL Server 2000 Wondering if there are any issues with running multiple protocols in this same network environment ? Thanks, Craig ...

New CLuster server for sql 2005 ent

mecn - 23 Mar 2006 5:12 PM - 2 messages

Hi all, This is the first time i am experience cluster server for sql server(no SAN). My question is what id the best way to configure partition the hard drive for performance and security. Log and data files are needed in separate ...

Receiving Error: 'QUOTED_IDENTIFIER' when updating

Ric - 23 Mar 2006 4:50 PM - 2 messages

Hello, I am getting the following message when running a stored proc: Server: Msg 1934, Level 16, State 1, Procedure SZ_ProcessToCPInvoices, Line 261 UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. I cannot find any information about this error. This happens with ...

Strange deadlock scenario

Tom - 23 Mar 2006 4:35 PM - 6 messages

I'm consistently getting a deadlock on a single table between two processes. One process updates the table and has an exclusive lock on a clustered index row, and is requesting an exclusive lock on a non-clustered index to update ...

Text Required

microsoft - 23 Mar 2006 4:35 PM - 2 messages

Hi All I am new to SQL. What text would you recommend to assist a newbie in using this application. Setting up and configuring... etc Thanks ...

migrating sql 2000 db's to sql 2005

edgar - 23 Mar 2006 4:34 PM - 3 messages

I just received a copy of Microsoft SQL 2005 standard, and i wanted to migrate my existing databases from 2k stnd to 2k5. Is there a script of something that can do the migration for me? BTW, the server running 2005 is a fresh build on a new server. ...

SQL Server 2005 Upgrade Advisor Messages

Mike G - 23 Mar 2006 4:33 PM - 3 messages

Hi everyone, I am getting some odd messages when running the SQL 2005 (32 bit) upgrade advisor against my SQL 2000 databases. They state that these need to be fixed before I upgrade. I've searched the web and cannot find any reference ...

'QUOTED_IDENTIFIER' when updating

Ric - 23 Mar 2006 4:28 PM - 2 messages

Hello, I am getting the following message when running a stored proc: Server: Msg 1934, Level 16, State 1, Procedure SZ_ProcessToCPInvoices, Line 261 UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. I cannot find any information about this error. This happens with ...

SQL Server 2005 Failovers during Transactions

Adam St. Pierre - 23 Mar 2006 4:10 PM - 4 messages

Greetings! My company is invetigating SQL Server 2005's failover capabilities. A major concern we've had pertains to failovers during large transactions. My question can best be explained through a scenario. Suppose a large transaction is occuring on our database.. Let's say, 10,000 ...

Increase column length in all tables with column

Alan Z. Scharf - 23 Mar 2006 4:09 PM - 4 messages

Hi, I there a way to increase the length of the same-named varchar column in all tables at once in SQL2000? Thanks. Alan ...

Upgrade to SQL 2005 and Keep Logins in All DB and login password

q_test - 23 Mar 2006 3:11 PM - 5 messages

I need to migrate SQL 2000 to SQL 2005 on a different machine. I want to migrate logins and keep password intact. I am able to use Copy Database Wizard to copy databases. However, I cannot achieve both (copy database ...

Connection String with Named Instance and Port?

bradwiseathome - 23 Mar 2006 2:38 PM - 2 messages

I am trying to create a SQL Server 2000 and 2005-friendly connection string that will allow me to connect to a named instance on a non-standard port. I can't get the syntax right, can anyone show an ...

ways to improve performance of SQL queries

sahon - 23 Mar 2006 2:29 PM - 7 messages

Hello I have table: CREATE TABLE [dbo].[Data_TD] ( [iID_Dataset] [int] NOT NULL , [dDate] [smalldatetime] NOT NULL , [fVal] [real] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Data_TD] WITH NOCHECK ADD CONSTRAINT [PK_Data_TD] PRIMARY KEY CLUSTERED ( [iID_Dataset], [dDate] ...

problem in usage of CONVERT

SouRa - 23 Mar 2006 2:13 PM - 3 messages

Hi, DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET EndDate = '06/01/2005' SET EndDate = '12/01/2005' -- query 1 select * from table where convert(varchar,dateColumn,101) between @StartDate and @EndDate -- query 2 select * from table where convert(varchar,dateColumn,101) between convert(varchar,StartDate ...

how to obtain space allocated by file(group)

Yaro - 23 Mar 2006 2:06 PM - 2 messages

Hello sql 2005 I have to check from time to time disk space allocated by filegroups (can be files). I found only - sp_spaceused - but this give me information about whole database ...

Need to update up to 3000 user DB

Steve B. - 23 Mar 2006 1:39 PM - 3 messages

Hi, We have an SQL 2005 Server with the whole enterprise data. We are building an application that requires a per user database with its own data (horizontal filtering). Our first idea is to create 3000 mdf files, one db for each user. This DB is ...

The dbName of user Instance

ad - 23 Mar 2006 1:00 PM - 2 messages

I wnat to use sp_detach_db to close the conneciton of a User Instance The .mdf file of my User Instance if myDB, but if I call with sb_detach_db 'myDB' The system error with message "myDB dose not exist" How can I close the user Instance? ...

Can u please check this queary?

dev.amit - 23 Mar 2006 11:30 AM - 4 messages

Dear Friends Hi!!! I have written this query having a few join its showing "syntax error in FROM clause" when i am trying to execute it If u can help me i would be very Glad Here is my code ...

is there a way to overcome sp_executesql 4000 chars parameter limitaion? <EOM>

Prashant Barnwal - 23 Mar 2006 11:04 AM - 4 messages

...

[FR/EN] How to make several hundreds of recording at the same time?

Alextophi - 23 Mar 2006 9:56 AM - 2 messages

FR -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- bonjour, J'effectue plusieurs enregistrements provenant de plusieurs serveurs dans une base SQL. Mon problème est que l'enregistrement écrit des données dans plusieurs tables et donc quand il y a plusieurs centaines d'enregistrements à la même heure les données sont mélangées dans ...

Whats a good server spec for what is planned?

Paul - 23 Mar 2006 9:42 AM - 3 messages

I'm trying to establish whether the hardware we have is good enough to drive the databases we plan to put on it. Its my view that it will be, but I don't have the experience to say if that is the case. ...

stored procedure for update

Jason Huang - 23 Mar 2006 8:11 AM - 4 messages

Hi, I wanna write a Stored Procedure ( NOT Trigger) for updating tables. So if CustomerName updated in table CustomerA, it will then update in CustomerB. Would some tell me how to do this? Thanks for help. Jason ...

Good Enterprise Level Monitoring Tools

Hassan - 23 Mar 2006 7:35 AM - 4 messages

What are some good enterprise level monitoring tools that one would suggest for a 24/7 shop that monitors end to end application performance.. i.e from Web to Application Server to SQL Server. Please do share your experience. Thanks ...

Hi guys, how to monitor and purge log files/transaction files? Tha

Iter - 23 Mar 2006 4:13 AM - 2 messages

Hi guys, how to monitor and purge log files/transaction files in SQL Server? Thanks ...

installed eval and only have config tools

ruthsieg - 23 Mar 2006 3:26 AM - 2 messages

I installed the Sql Server 2005 Enterprise Edition 180 day eval. However, under SQL Server 2005 program group, all I have is Configuration Tools. What happened to Query Analyzer, Enterprise Manager, etc??? ...

tables in a file

mike menard - 22 Mar 2006 10:00 PM - 4 messages

does anybody have a quick query to show what tables are in what filegroup? and maybe their size? i'm trying to improve some IO perfomance for this one application that hits multiple files and i want to spread them around. ...

Query Analyzer Locking Up

Preacher Man - 22 Mar 2006 9:18 PM - 4 messages

I just installed client tools and when I use the QA it will hook up to the Database just fine, but if I go to the file menu, it locks up. Any ideas? ...

CheckPoint question

donsql22222 - 22 Mar 2006 9:06 PM - 7 messages

Is the quantity of data written to disk during a checkpoint, related to the size of the table? The checkpoint takes place when the log file is 70% full. Compare these two identical files on separate servers except for rec amts. ...

help importing large flat file into relational tables

Macisu - 22 Mar 2006 9:01 PM - 2 messages

I am trying to find the best (fastest) way to import large text files into sql server 2005 relational tables. The database has simple recovery model. The total size of data to be load is about 1gb (each file) source: ...

SQL Mail

docsql - 22 Mar 2006 8:49 PM - 2 messages

Hi! I am testing the xp_smtp_sendmail extended stored proc. I am testing using the following script (with my own parameters). The return code is zero, but I donot receive an email in my inbox. I did receive emails twice, but after that everytime I run the script I donot ...

DTS package Scheduled Job does not run correctly

Carly - 22 Mar 2006 8:35 PM - 2 messages

Hi I have a DTS package that is running a VB script that reads all the files from a folder one by one and processes them. After a file is processed - file is read and the content entered in a table in one of ...

full text searching...

Ollie Riches - 22 Mar 2006 8:25 PM - 2 messages

I am working on a system where we wish toc reat a full text catalog in sql server 2000. I created a test catalog and started a 'full population' but it failed. After several attempts I restarted the 'Mircosoft Search' service and it is failing with the following error: ...

GRANT command error

David - 22 Mar 2006 8:04 PM - 3 messages

Hello, I am running a very simple command to grant a stored procedure an EXEC permission to a login that is created for a NT group. The command is as follows GRANT EXECUTE ON [dbo].[sp_RptUsersData] TO CORP\AppDev. I am getting the error like "Incorrect syntax near '\' " ...

SQL Mail

Dave S. - 22 Mar 2006 8:00 PM - 2 messages

Is it possible to email attachments (excel, txt, etc) to a SQLserver that will then process and update itself with these new records? ds ...

Automatic Backups

Ale - 22 Mar 2006 7:17 PM - 7 messages

Hi: Somebody knows how I can program a stored procedure for automatic backup to disk in SQL Server 2005 checking the transaction log? Thanks in advance Ale :) ...

what do you do when logic just stops working

Mike - 22 Mar 2006 6:56 PM - 2 messages

I have this stored procedure which was working fine yesterday but today no matter what I do only returns -1. I even changed the procedure to select * from some table and return 0 (I've tried 1 as well) but regardless of what ...

Index Fragmentation and Datatype Issue

JumpingMattFlash - 22 Mar 2006 6:37 PM - 3 messages

I've got an issue where by certain types of records in a particular table are becoming fragmented. The table is made up of an ID Column (identity), a Reference Column[FK](int) , a Date Column (timedate) and an Account ID Column ...

Schema vs separate database

Patrick Cournoyer - 22 Mar 2006 6:34 PM - 3 messages

Hi, This is an architecture related question. The context is the development of a project with a SOA - Service Oriented Architecture. There are several service providers in the project each being the owner of a disjoint database (i.e. group of database objects). There is a single redundant database ...

Fragmentation of Table Differs Between 2000 and 2005 Client on 200

JumpingMattFlash - 22 Mar 2006 6:07 PM - 3 messages

I'm examining the logical fragmentation for a table running on SQL Server 2000. If i run dbcc showcontig the fragmentation appears as 0.21% however if i examine the same index in SQL Management Studio 2005 it's 20.64%. So which ...

splitting tempdb into multiple filegroups

AO - 22 Mar 2006 5:55 PM - 3 messages

Hi. Anyone know the tsql to split tempdb into multiple filegroups? Thanks ...

SQL Server Standard Management Console / Studio Not Available

thef150 - 22 Mar 2006 5:53 PM - 3 messages

I have tried several times using the SQL Server 2005 Standard DVD included at the "Ready to Launch" event to install SQL Server 2005. No matter what options I choose I never find the "Management Studio" installed. This was to replace the Enterprise Manager of SQL 2000. All ...

How to drop user names after copying database?

HK - 22 Mar 2006 5:52 PM - 3 messages

I copied a database from a SQL 2000 server to a SQL 2005 server. In the node for that database, and in the security > users node, it shows the users from the 2000 box. Of course, those users don't exist on the 2005 box. ...

Creating an Assembly that calls a COM object

KMP - 22 Mar 2006 5:41 PM - 13 messages

Hi, I am trying to create an Assembly in SQL Server 2005 that calls a C# DLL which in turn calls some COM stuff. I get an error message in SQL Server 2005 related to COM interoperability (does not exist in SQL catalog). I can give ...

Local instance registration on 2005

cbrichards via SQLMonster.com - 22 Mar 2006 5:07 PM - 6 messages

I just installed the workstation components for SQL 2005 and have opened Management Studio. I am trying to register a local instance for testing and am not having any success. If I select "New" under database engines, I do not have any local ...

Tables deleted

Samuel Shulman - 22 Mar 2006 4:57 PM - 4 messages

Hi I tried to copy some stored procedures and the Wizard seem to delete some tables I need to quickly undo the delete Thank you PS does anyone know why would that happen? ...

SQL Server 2000 error in Enterprise Manager while returning all or few rows.

sushma_sondhi - 22 Mar 2006 4:43 PM - 2 messages

Everytime I attempt to open a table returning all rows or Design Table in my SQL Server 2000 Server Enterprise Manager returns the following error An unexpected error happened during this operation [MS Visual Database Tools] Not enough storage is available to complete this operation. ...

Problems with SQL 2005 64bit sending emails

marian@dumitrascu.net - 22 Mar 2006 4:35 PM - 8 messages

I have SQL 2005 on WS 2003 64 bit Whenever SQL agent is trying to send an email, it fails and I get this error message in logs: [264] An attempt was made to send an email when no email session has ...

Custer an index or not?

_Stephen - 22 Mar 2006 4:13 PM - 3 messages

I see this as potential problem. I have Indexed columns for a Clustered Index as follows: Merchant_Account_ID DateOfReport Standard_Entry_Class_Code This would repage my index on the daily insert of say 300+ returns where they are going in by Merchant + Data+ Code. ...

partitioned view to help query perform better? -- repost

Quentin Ran - 22 Mar 2006 3:47 PM - 3 messages

The following has been posted but did not receive any response. Any feedback is appreciated. Group, I have been trying to use the partitioning feature of the partitioned view to help query performance with the reasoning that, when I can have the query ...

SQL database currupt\ suspect

Isn't my SQL Server hardware sufficient for my server load? Why does it keep getting slow?

query to display all clustered indexes

asking for opinions

mirror

Sub-sub-query problem

q: replication

Backup Size - Larger than db size

Error in inserting value by trigger in linked server

Constraints and query plans

Inserting values

SQL error

About Sql25K and MDAC libraries

for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs

Full Database Back and Diffrential Database Backup

Corrupt Database

Data Archiving

query

trigger to parse a string from insert statement

Recommended software for data dictionary, ERD

Permission

How to configure MemToLeave memory option?

Reindexing and Transaction Log

Write Notification to Windows Application Log

SQL Server 2005

TEMPDB initial size (at server start up)

Data Load from cmd line prompt...how??

limit the resources of a job

Performance issues after migrating from sql server 2K to 2005 Express

VSS Copy doesn't work I can't do Backups!!!

Sql 2005 Integrated security vs custom implementation

Login Trigger?

How do I shrink the Log file

How convert an named instance to a non named instance

Log copy job using robocopy reports errors

Merge Join

SQL Server 2000 stop responding

SQL 2005 and deleting old backup files

Throttle DB's/Users

RAID

Query timeout

is it possible to tell when a dts package has last been used

SQLExpress

NULL value gives unexpected query result

qualifying Stored Procedure with owner. Why is it important/

Sql Mail Problem

Optimized & fastest way of taking backup & restoring database through C# code

how to automate a SQL database restore

'Space Available' Is 0, but I can make records, tables...

sp_who and sp_locks on occurrance of deadlock

Whats better for storing files

Undo database import

Can I replace SQL Server Standard Edition with MSDE?

Is there a equivalent tool to Oracle HTML DB for SQL Server

Query Analyzer out of memory

SQL 2005 on member server

re: REINDEX and INDEXDEFRAG

Urgent-- May need to rebuild a box.

DBCC INDEXDEFRAG.. no impact?

Version Number and Patches Applied

partitioned view to help query perform better?

sql server 2000 on windows server 2003

SQL Server 2000 DB Restore Question

creating index on calculated field in table -sql 2000

stored procedure: what does N mean?

compression of database backups -

Monitor table changes without triggers.

Missing Operators Error

is sql 2005 based on imdb (in-memory database)?

trigger for update

db error

Heinous performance problems after SQL 7 --> 2000 migration

Mirroring Questions.

SQL Server 2000 SP4

Domain Controller and SQL Server 2005

file growth problem in 2005

Copy database - same server

Error 7102

Strange problem with SQL Mail

Why are Parallel INSERTs slower than non-parallel when you have a

name of instance

sp_who & sp_who2

Replacing a Primary Key

Switch from Per Processor to Per Seat

SELECT statement

any way to attach a printscreen

SQL Server 3rd party monitoring tool

Move Table to different filegroup.

not able to create trigger

Not configured for DATA Access

Restore database and trx log

DTS

SQL Server Stored Procedure Syntax

SQL 2005 and IIS

Nested Views are not getting executed.