Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Issuing multiple calls to SET IDENTITY_INSERT ON
Amir Shitrit - 7 May 2005 9:17 PM - 11 messages
My table's primary key is an identity column. When I delete a row, I first copy it to another table and afterwards delete it from the original table. When I want to restore the row, I use the SET IDENTITY_INSERT statement, in ...
Score whats native and character format
Hassan - 7 May 2005 9:02 PM - 2 messages
They talk about native and character format in bcp.. What is it ? Whats the difference ? Can you give me an example ? ...
Score SQL Memory KEEPS on GROWIN!
Espo - 7 May 2005 8:16 PM - 5 messages
We have a sime app, supported by RS.  When the server starts up, it consumes roughly 40k by the end of a day (and we have low transaction and small records) memory grows to around 500k. What can be consuming and not releasing memory on the server? ...
Score db_owner and administrator role
ft - 7 May 2005 3:06 PM - 4 messages
if I associated an user to role : db_owner, he has automatically administrator role or I have to define another thing ? I yes what I have to do thanks ftct ...
Score Suspect Database
Ivan - 7 May 2005 2:01 AM - 3 messages
Dear all, One of the database in my SQL server became "Suspect" suddenly.... How to get it back to normal??? Thanks in advance. Ivan ...
Score SP 4 is Out
Michael C# - 7 May 2005 12:50 AM - 9 messages
Woo Hoo! [link] ...
Score SQLDMO Drop Replication on Restore
Shane Lim - 7 May 2005 12:26 AM - 3 messages
Is there a way to drop replication on a restore. Or, is there a way to backup without saving the replication information? gslim ...
Score SQLDMO Restore KEEP_REPLICATION
Shane Lim - 7 May 2005 12:21 AM - 2 messages
Does anybody know there restore statement to turn keep_replication off? I cant seem to find it. I was thinking it should be something lik e dim objRestore as SQLDMO.Restore objrestore = new SQLDMO.Restore objRestore.KEEP_Replication = 0 or 1 or KEEP_REPLICATION_FALSE ...
Score Converting from Filemaker Pro to SQL Server
Youssef - 6 May 2005 11:10 PM - 2 messages
Hi! I would very much appreciate your help with the following. I have a database that has been created in Filemaker Pro 5 &6. We have convinced our client to migrate to SQL Server instead and they have accepted. ...
Score DTS w/ C#
seth via SQLMonster.com - 6 May 2005 10:56 PM - 2 messages
I am executing a DTS package with a Console app and everything works fine. I am now constructing a "Windows Application" to execute the package.  This fails (using the identical code).  I can't figure out how to display the ...
Score Memory Allocation for Jobs Running under SQL Agent
Mike Mattix - 6 May 2005 9:36 PM - 3 messages
I use the job processing functionality to do a variety of things by running DTS packages.  One of my DTS packages has been failing as run a .NET application to convert/modify the data extracted from an Oracle Database in a ...
Score How Can I Prevent any activity on a SQL Server
Paul Bergson - 6 May 2005 9:34 PM - 3 messages
I'm getting close to migrating my db's across to a new server and wonder what is the best way to prevent users from accessing any of the db's on the sql server? I have a very LARGE dts package to run that will do all the work for me but ...
Score Removing SQL server from SBS 2003 server
AllenM - 6 May 2005 9:28 PM - 2 messages
I think I screwed up with the installation of SQL server and would like to remove it. My only fear is that if I use the add and remove option in Control Panel would this actually remove my MSDE instances used for ...
Score How can I find the allocated size of an index?
Snake - 6 May 2005 8:30 PM - 4 messages
I ran sp_statistics on a table and the indexes were displayed along with the SIZE  of the table, but the index SIZE's are NULL. I ran statistics on the table and the indexes SIZE's remained NULL. So what's the trick to obtain the ...
Score Disable SQL Mail
Newbie - 6 May 2005 7:41 PM - 3 messages
I was told my sql mail was enabled, how do I disable it?  Thanks. ...
Score Instance not showning up
Christopher Knapp - 6 May 2005 6:51 PM - 4 messages
Hello, I have MSDE installed on the Win2003 server named 'server1' and it's instance is called 'manufacturing' so it's name should be ( server1\manufacturing ).  That is the only place SQL is installed on the network.  Then there are four XP SP2 workstations that connect to the ...
Score connection failed port 25
manoa - 6 May 2005 6:36 PM - 2 messages
I have two w2k3 SP1 server setup with smtp for relay.  Both servers are pretty much a mirror of each other.  Locally, I can telnet from one server but not the other.  When I tried to telnet locally from the servers with its ...
Score Tempdb *.mdf disappeared after 'alter' command
Magoo - 6 May 2005 6:19 PM - 2 messages
I can't understand how, but after attempting to move tempdb from one drive to another following the article below, I go to SQL 2000 Ent Manager and see that "Tempdb" has data files on: File name = tempdev  however the location is on: ...
Score How to determine table size?
Snake - 6 May 2005 5:16 PM - 2 messages
Is there a stored procedure or command for determining the allocation size of a table and related info?  thanks ...
Score When to expect SP4? And is it required for W2k3 x64?
Mike Kruchten - 6 May 2005 4:21 PM - 4 messages
We have a new x64 capable server and would like to test SQL2000 on W2k3 x64. Does anyone know if SQL2K SP3 will run or is SP4 required? The following page seems to imply that SP4 is required and that it's available now. ...
Score Rename File
DXC - 6 May 2005 4:12 PM - 7 messages
I have a text file (*.txt) created from a DTS Package. I need to change the file name after it is created to add the current timestamp in the file name (i.e. date and time). Ex: The filename is 'Myfile.txt' and I need to make it 'Myfile0506051022.txt' ...
Score SQL XML Support
ReportFAQGuy - 6 May 2005 3:26 PM - 4 messages
Hi In SQL2000, is the xml support installed by default or do we have to install it seperately after the initial installation or maybe check some checkbox during the initial installation. Any help would be appreciated. Thanks ReportFAQGuy ...
Score Msg 18456
dziegel - 6 May 2005 2:52 PM - 2 messages
I am getting error message on login as follows: K:\>isql -U BSCI\ziegelmd Password: Msg 18456, Level 14, State 1: Login failed for user 'BSCI\ziegelmd'. DB-Library: Login incorrect. I can login using isqlw, and the test connection via Visual Studio 2003 ...
Score SQL Licensing Question
Mike Johnson - 6 May 2005 2:19 PM - 3 messages
How can I tell what licensing is set up on a machine?  I have gone into Licensing in Control Panel, but it only lists for Windows Server.  We are running in a clustered Active/Passive environment. ...
Score SQL Server Upgrade to Windows 2003
Disney - 6 May 2005 2:18 PM - 2 messages
We are upgrading the OS from Win 2k to win 2003. There is an existing DBServer on this server. What the steps required for the SQL Server ? Do I need to reinstall SQL ? Please Help ? Has anyone done this before. Let me ...
Score SQL Server state for Point-in-time copy
Mark R - 6 May 2005 2:16 PM - 6 messages
I wish to use a storage array snapshot capability to take point in time copies of a SQL Server 2000 database. The database and logs etc, need to be placed in a consistent state to make the snapshot valid (i.e. flushed and no writes being performed). How do I put ...
Score Database size increasing
Srini - 6 May 2005 12:00 PM - 3 messages
Hi all, When are performing data upload into our system the size of the database increases very high . Only after we defrag does the database size decreases. We have tried setting the autoshrink option as true but it still does not ...
Score copy permissions grp to grp
Simon - 6 May 2005 9:54 AM - 2 messages
Hello all, running Win 2k & SQL 2000. I have created a new group and would like it to have all the SQL permissions of one of our older groups. What is the best way to copy the permissions? All advice greatly appreciated, Simon. ...
Score sp_spacedused give me negative value for unused space
Jason Chan - 6 May 2005 7:36 AM - 3 messages
i use sp_spaceused to query how many space used by a table here is the result name                 rows        reserved           data ...
Score SQL Server within a ISP
Marcin S. - 6 May 2005 7:30 AM - 4 messages
Hi, We are running SQL server 2000 and we have 100+ databases on the server. Is there a possibility to limit the databaselist to the current user? Case: 1) User MSSQL67 has only access to the database with name MSSQL67 ...
Score what version of sql server should i install in testing server
Joe - 6 May 2005 4:52 AM - 5 messages
Dear all, 1.) If i want to install a sql server into the testing server for testing propose, what version of sql server should i install? 2.) Should i install the standard edition of sql server(the same one on ...
Score Index tuning wiward, 98% improvement
guoqi zheng - 6 May 2005 4:32 AM - 2 messages
When I used the index tuning wizard to analysis MSDE. It came up with a recommendation says that: If you choose to implement the recommended changes, you should see the following improvement: 98% improvement in performance based on the sampled ...
Score how to check Analysis Server is on SP3a ?
Hassan - 6 May 2005 3:39 AM - 2 messages
How can i check the service pack version for Analysis Server and to make certain im on the latest SP which i believe is 3a ? ...
Score Is /PAE needed when you dont have more than 4GB of RAM?
Hassan - 6 May 2005 3:32 AM - 2 messages
If you dont have more than 4GB of RAM, would having /PAE in the boot.ini hurt ? I know its needed when you have more than 4GB of RAM.. ...
Score Hot fix 821334
Loke Kit Kai - 6 May 2005 2:55 AM - 5 messages
Hi, Anyone knows where to download the above? The kb article doesn't have a link to download it. ...
Score Developer Server performance on WinXP
Brian Burgess - 6 May 2005 1:49 AM - 3 messages
Hi all, I have a strange performance issue on one of our developer stations.   This station is Trad Chinese WinXP Pro with SQLServer 2000 Dev Ed installed on it. The problems are: 1)  The tools (like QA for instance) cannot connect to other SQL Servers on ...
Score IO question
Hassan - 6 May 2005 12:05 AM - 6 messages
I have a set of databases. I could get multiple arrays of disks laid out say 6 drives D,E,F,G,H,I of 100GB each RAID 10 Would it help from an IO perspective if i created all my databases striped ...
Score linked server for a named instance
ChrisR - 6 May 2005 12:00 AM - 3 messages
sql2k sp3 Im doing some testing on my local pc. The name of my pc happens to have "-" 's in it. I have two instances of sql on it. So lets say I have the names of my SQL instances are: ...
Score How can I tell if a SQL Agent job is running?
pshroads - 5 May 2005 11:40 PM - 6 messages
I'd like to put logic in a SQL Agent job so that it doesn't run if the job is already running. Is there an easy way to tell if a job is running? Thanks ...
Score Problem backing up XLog using db Maint plan
Roger Denison - 5 May 2005 9:12 PM - 5 messages
Like many who have posted, I am getting a failure when backing up my transaction log.  It is part of my db maint plan and all the other routines run fine: Integrity check, db backup.  Looking at the history I see the ...
Score Server Migration.
Pradip - 5 May 2005 8:41 PM - 2 messages
Please let me know if there are any known/possible issues I might run into by performing the following Test. We have SQL Server 2000 sp3 Ent Ed on WINNT(Server-Prod). I want to get that server out of our domain. Rename some other(Server-Test) machine as ...
Score Matching Collation and Sort
Skip B - 5 May 2005 8:16 PM - 6 messages
I am attempting to match the following collation and sort. I cannot seem to make the right choices to prevent collation conflicts in my stored procedures. Can ANYONE please give me some insight on what options to select in order to match this in SQL 2000 Service pack 3? The server that produced ...
Score Seeking help to automate SQL Maintenance via VB6
Joseph Geretz - 5 May 2005 8:00 PM - 6 messages
We have certain SQL tasks which we've been carrying out by running scripts in Query analyzer (sample below). In some contexts, the users won't be sophisticated enough to execute these scripts in this manner. We'd therefore like to develop a small VB SQL script execution utility program which we can ...
Score Rolling back a transaction
waltmallon@yahoo.com - 5 May 2005 6:56 PM - 2 messages
I'm a little confused about rolling back my transaction.  It seems that when sql server gets an error after a begin tran statement, it aborts when it gets the error and leaves the transaction open.  For example: ...
Score CAL License Question
RKinder - 5 May 2005 6:03 PM - 4 messages
I know that the number of CALs licensed to a given server is stored in some system table because at one point I had and ran a script to provide that information.  But I either didn't keep the script or didn't name it well as I ...
Score SQL Server 64-bit vs 32-bit
John - 5 May 2005 5:39 PM - 3 messages
We will be installing SQL Server 64-bit and want to do log shipping to a 32-bit SQL Server. The 64-bit sql will be the primary and the 32 bit the secondary. Will this work? And would failover to the secondary(32-bit) work ...
Score Connectectivity problem after Alias is created
Civic - 5 May 2005 4:38 PM - 5 messages
I have an SQL 2000 DB that was upgraded from SQL7.  I can connect to and work with the 7 DB with out any problems.  After I upgrade the DB to 2000 sp3 I can connect to it through enterprise manger only on a workstation that does ...
Score Transaction Log not recycling
scott t - 5 May 2005 4:10 PM - 4 messages
SQL Server 2000 SP3a Size: 60 GB Simple Model Recovery Transaction Log Automatic Grow File: 250 MB Have a problem where the transaction logs continues to grow and never reuses the VLF's that are already created. I will manually increase the logsize ...
Score How can I refactor these GROUP BY queries to be faster?
John Peterson - 5 May 2005 4:02 PM - 8 messages
(SQL Server 2000, SP3a) I'm trying to construct a VIEW that will return *one* row per DossierUNID, and the row should be the DossierUNID row with the lowest SortOrder value. However, I have some cases where SortOrder is NULL (which should be treated ...
Score Newbie:why osql doesn't let me logon ?
Magoo - 5 May 2005 3:55 PM - 6 messages
I need to move tempdb from c: drive to d:on the local server. I try to go to osql to perform the deattach database command, but here is what I get: My user is an administrator on the local SQL server. ...
Score Help with T-SQL Coding
The Gekkster via SQLMonster.com - 5 May 2005 3:52 PM - 5 messages
I'm trying to come up with a procedure for part of a validation process using the criteria below (shown as 'steps'). New to SQL Server, and with T- SQL I'm really not sure about the best way to accomplish all of this so I ...
Score Best way to copy large number of databases to new server?
Chris Ashley - 5 May 2005 3:44 PM - 4 messages
We're in the process of migrating to a new database server, and have a large number of databases to move across (approx 100). I found the 'copy database wizard' which seemed to be exactly what I needed, only it didn't work ...
Score What does SQL Profiler's Duration include?
Tom - 5 May 2005 3:01 PM - 3 messages
Hello, I was wondering if the SQL Profiler's duration column includes the time it takes to get data back to the client's pc. My guess is no.  I have a table that stores Word documents and I have a stored procedure called ...
Score SQL Enterprise Manager Question
Nancy Kafer - 5 May 2005 2:32 PM - 3 messages
I have a user that is defined on my SQL Server (not through an AD or SQL group). The only reason for the user being defined this way is because they need access to SQL Enterprise Manager to create views and stored procedures ...
Score Collation question
James T. - 5 May 2005 2:13 PM - 2 messages
Hello! I am building a Russian web site. Site request and response encoding is set to windows-1251, data is displayed correctly. But in MS SQL Manager evrything is messed up... like this ??? ?? ???? Database table field colaltion is set to: COLLATE Cyrillic_General_CI_AS ...
Score SQL Server Hanging... While doing Maintenance...
dave.mudgett - 5 May 2005 1:20 PM - 2 messages
I have a Windows 2000 Server running SQL 2000 3a.  I am using SourceGearVault for the application and have three different physical Disks.  One for the Operating System, one for the Database and one for the Logs. When I do a backup at night, my server locks and I have to reboot it using ...
Score why a log grows so big?
Gil - 5 May 2005 1:06 PM - 2 messages
Hi, What can it make a dump for a log make it so big? About 3 GB, but normally is about 1 MB. Regards, Gil Tapia ...
Score Some users reads too much records from databases
Ala - 5 May 2005 11:51 AM - 5 messages
Hi all ! I've got MS SQL 2000 I need set different priority for user. Some users reads too much records from databases. I will send a information - "You must ask another question" or when the user reads too much records, I can make the connect out. ...
Score maintenance fails
msde - 5 May 2005 10:03 AM - 4 messages
Hi Im running a Windows 2003 server and MSSQL 2000 that manages some 45 databases. I created an maintenance plan that does an integrity check, backups all databases, and backup all transactionlogs. If I look at the "Jobs" list it looks like backing up the databases runs OK, ...
Score Problem migrating from sql7 to sql2000 - connection failure
LL - 5 May 2005 9:01 AM - 4 messages
We have an inhouse app written in Delphi which connects to a local server running SQL7. When we migrated the database to a server running SQL2000 we ran into problems. When a user uses the Delphi app to browse data, it seems ok, but when the ...
Score Failure to start up SQL Server
Leonard - 5 May 2005 7:30 AM - 3 messages
SQL fails to start up - no error message is given- in SQL Server Service Manager or in Enterprise Manager The problem first occurred when starting up my computer and SQL failed to start automatically (Auto start service when OS starts check box is ticked) ...
Score SQL server management software?
Tom - 5 May 2005 7:05 AM - 3 messages
Hallo! Any suggestions about management software for SQL server? I would like to monitor a number of SQL servers in larger environment and would like that software to be able  to: - monitor performance counters, job executions... - send notifications, alerts... ...
Score View Image column
Hassan - 5 May 2005 6:19 AM - 2 messages
How can i view the image column in a table ? ...
Score gmaniz service failed
ekodian - 5 May 2005 4:39 AM - 2 messages
Dear all, please help me to find error about 'the gmaniz service failed to start due to the following error' Thanks ...
Score Backup corrupted after de-fragmentation
Ram - 5 May 2005 4:14 AM - 6 messages
Hi We have a database of about 40GB and a full backup of that database.  The backup resides on "E" drive and recently we de-fragmented that drive.  After de-fragmentation we restored the database and we ran dbcc checkdb command ...
Score Data Lost
Edward - 4 May 2005 4:16 PM - 3 messages
Excuse me if my redaction is bad, but I don't speak english very well. My Question is: I have a SQL DataBase in which every day I save a lot of records. I'm sured that the records are in the Database because I can see them. ...
Score How to trim off the time part of a DateTime field
ad - 4 May 2005 4:18 AM - 5 messages
I have a tabls of SQL 2000, about the data of student. The data is migrate from another databse, There is a field called birthday, it stores the data with the formate like: 1994/11/03 AM 02:09:00 ...
Score RAID 5 vs RAID 10 for read only db
Hassan - 4 May 2005 3:49 AM - 3 messages
Assuming I have a read only database, which ones better RAID 5 or RAID 10 from a performance angle ? ...
Score Storing JPG Image in SQL Server 2000
Jason - 4 May 2005 2:31 AM - 4 messages
Hi, We are using an Access database with Employee Pictures.  However, we find that the size of the database is pretty large as images are stored as BMP format in Access. We would like to know which datatype should be used for ...
Score How to select from the result set of a stored procedure
Bill Oeftering - 3 May 2005 7:54 PM - 3 messages
Sorry for the newbie question. I want select the phyical_name field from the result set of sp_helpdevice I need to do something like this: Declare @myname as varchar(255) select myname=physical_name from sp_helpdevice where phyical_name='some value' How do I do this ? ...
Score deadlocks after dbcc checkdb
ChrisR - 3 May 2005 6:51 PM - 5 messages
sql2k sp3 Over the weekend I had severe corruption and needed to do DBCC with repair_allow_data_loss. Since then Ive had tons of deadlocks on lots of different tables. Any ideas as to why? I know I can trace them and figure ...
Score SQL Install
docsql - 3 May 2005 5:47 PM - 8 messages
Installed SQL server under local system account.  Later changed the account on which sql server & agent run to local user with regular priviledges. SQL agent does not work????? ...
Score view jobs and job history
Piku - 2 May 2005 6:31 PM - 5 messages
What is the MINIMUM User permission required to view the jobs and job history for a specific database user in the EM ( I know if he is a member of local admin in the box or if he is SA , the user should be able to see it but ...
Score Problems with restoring master from a backup - SQL Server 2000
Ragnar Midtskogen - 2 May 2005 4:42 PM - 9 messages
Hello, I am trying to restore the master DB and I am not getting anywhere. I stor the server, then restart it in single user mode (sqlservr.exe -c -m from command prompt) When I open Enterprise Manager I find that my user DB is in single user ...
Score Server 2003 SP1 breaking MDAC/Enterprise Manager?
William Sullivan - 2 May 2005 3:49 PM - 2 messages
We've had two customers who recently installed 2k3 SP1, both of which have had problems come up with SQL server.  The symptoms are that EM can no longer execute queries, returning an unspecified error.  Filemon does not detect any ...
Score SQL Server 2000 on Xeon x64 system
Jacob I - 2 May 2005 2:05 PM - 3 messages
Hi, Can I install SQL Server 2000 SP3a on a system based on Intel Xeon EM64T-system Thank you ...
Score Using locking hints
SQLCatz - 2 May 2005 9:50 AM - 2 messages
Can someone please help me in understanding this: Q1. ---- Simple SQL Statement: (a) select col1, col2 from table1 where col3 = 123 (b) select col1, col2 from table1 (nolock) where col3 = 123 (c) select col1, col2 from table1 (tablock) where col3 = 123 ...
Score Rollback Delete
Chandra - 2 May 2005 5:41 AM - 2 messages
Is it popssible to rollback deleted data in the following scenario ? -Opened SQL cleint, and excuted DELETE * FROM <table name>. -Closed the client session (Screen). Is it possible to rollback(retrieve) my data & How ? It would be  helpful if ...
Score SQL Agent Autostart
News - 1 May 2005 4:19 PM - 3 messages
We have the SQL Agent running in the background performing various alarming tasks.  Only problem is that everytime we reboot the server the Agent does not come up (auto start in checked.  If we try to start it from the system ...
Score Why the update process take so much time??
Sassan Komeili Zadeh - 1 May 2005 12:21 PM - 7 messages
Hi, I Created a table with the following structure ----------------------------------------- CREATE TABLE [offUserConfig] (             [UserCnfgId] [udIDGen] NOT NULL ,             [CrsPndRef] [udIDGen] NOT NULL , ...
Next »