|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Can't Restore Database to New Server
mrrcomp -
29 Oct 2005 4:58 PM - 4 messages
Hi I am attempting to transfer a database from my server to my customers server. I took the backup file on CD however when I try to do a restore with it I get the following error Microsoft SQL-DMO (ODBC SQLState:42000) ...
Scripting automation....
Smith John -
29 Oct 2005 4:48 PM - 4 messages
Is there any stored procedure for scripting the database? SQL 2K. Thanks, John ...
special registry keys
SisterMaryElephant -
29 Oct 2005 4:01 PM - 5 messages
Hi, I am currently backin-up my complete environment to foresee a crash recovery. My ERP 5Baan IV) prompts me to "back-up the registry keys which are specific of MSQL" with no more details. Could someone enlighten me on the subject? Thx in advance. ...
Q: list of indexes and Keys
JIM.H. -
29 Oct 2005 2:43 PM - 3 messages
Hello, I am new in SQL Server, I have to deal with this big database with many tables, is there any way I can get a list of all primary keys , foreign keys and indexes and on all tables? Thanks, ...
Q: move database
JIM.H. -
29 Oct 2005 2:39 PM - 6 messages
Hello, What is the easiest way to move a database from one server to another with the all table structures, view and stored procedures? Thanks, ...
EM: Jobs: Runnable column
Gurba -
29 Oct 2005 8:21 AM - 2 messages
Hi, I havent been able to figure out when a job is marked as not runnable. I have several jobs, some enabled, some disabled, but they are all marked as runnable. Someone who can tell? ...
2 different versions!
Bob -
29 Oct 2005 6:27 AM - 7 messages
We have two database servers. Apparently they are running two different versions of SQL Server 2000. Can someone tell me what are the differences between the two versions? Server 1 Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ...
View Tables of Linked Server in SQL 2005
Alex -
29 Oct 2005 1:56 AM - 2 messages
Hi everyone, In SQL 2000 Enterprise Manager when you create a Linked Server you can see Tables and Views, is there a way to see the same in SQL 2005 Management Studio ? Regards, Alex ...
Turn off Reseed for IDENTITY
Esak -
29 Oct 2005 1:30 AM - 3 messages
Hi, I am using a SQL server table in my Java application. I want to prevent reseeding of the identity column. Here is my scenario: Table T1: C1 INT IDENTITY NOT FOR REPLICATION PRIMARY KEY, C2 VARCHAR(100) Say, I have the following data in T1: ...
adding a new column
Aramid -
28 Oct 2005 11:44 PM - 5 messages
Dear all, What would be the fastest way to add a new column (a timestamp column to be exact) to a table with about 15M records? We actually tried doing that earlier, but it was already running for 6 hours and the script has not yet finished executing. We had to kill ...
Sql Express vs Access in Shared Netowrk
ML -
28 Oct 2005 11:25 PM - 2 messages
Typically for small multi-user systems on a network with no true database server we have always used Access for the backend on a shared drive and accessed it via a front-end VB.NET app. With the release of SQL Express I ...
Sequel Security
Bahman -
28 Oct 2005 11:13 PM - 2 messages
Hello! I am trying to put an essay together about security in Sequel. Are there any good sites where I can collect information specific to this topic? Thank you! -Bahman ...
simple newbie question
abd08 -
28 Oct 2005 11:05 PM - 3 messages
Hi guys, Have been browsing through this newsgroup via deja.com, and unfortunately, most of the advice here seems to be for "larger" SQL installations (v.jealous!!!) =) We're a small family business (15 client pcs), and are using an ERP system (SAP B1) w/SQL as the back ...
writing table to remote
tony-icwgroup -
28 Oct 2005 10:19 PM - 3 messages
I have 3 servers: A,B and C. On server A I will be executing a procedure that get data from server B I will then write the result table to server C. All the servers are linked and I have all security necessary. Can I do that and how? ...
user Associated with a pid
nsajus -
28 Oct 2005 9:44 PM - 4 messages
Hi, I need some information regarding obtaining the user associated with a pid/process in the Sql Sever. I am trying to create a trigger on Delete on one of the tables in a database.. Is it possible to get the user ...
Dual Log Shipping Restore Jobs
Frank N via SQLMonster.com -
28 Oct 2005 8:53 PM - 2 messages
I have 2 SQL server 2000 servers, Server A, and Server B. Server A is production. It has a log shipping restore job that updates the database every half hour throughout the day automatically. Server B is a reporting/test server, that has its log shipped restored ...
File Group backup and restores
ssummo -
28 Oct 2005 8:38 PM - 4 messages
I have a database that has multiple data files (.mdf, .ndf), the complete backup of this database has now exceeded the size of the physical drive that I used to store the backup file. We have tried taking FileGroup Backups, placing files of the backup on ...
sqlagent jobs seem to hang
CDB -
28 Oct 2005 8:38 PM - 2 messages
Hi Everyone, I am experiencing an issue running maintenance plans on one particular database. When the individual jobs from the plan run, it will say "executing step one", but the job seems to hang. The job will run days on end without ...
table design
Johnfli -
28 Oct 2005 8:37 PM - 3 messages
I am a novice with SQL, so please don't hold it against me. I have a text file that I import into SQL. (easy enough) There are not many fields (maybe 20) THere are is One field named PO which can be in multiple times. Another ...
How do I Remove old backups from a file?
Todd Chittenden -
28 Oct 2005 6:20 PM - 6 messages
I have read that it is better to use T-SQL scripts in Job to run backups instead of creating a Maintenance Plan becuase you get better control. However, I can't seem to get the correct results. I am trying to setup a Job that backs up a Db to a backup file and have it ...
xp_sendmail
T. -
28 Oct 2005 6:19 PM - 2 messages
I have a TSQL query I have created which looks at MS Great Plains sales tables, selects records with today's date, captures several local variables and then launches xp_startmail and xp_sendmail, configures an email replay and sends it to the customer, then calls xp_stopmail. A WHILE loop keeps the ...
MS Access and SQL Server
Dean J Garrett -
28 Oct 2005 6:15 PM - 2 messages
We're developing a new MS Access 2003 application using a SQL Server 2000 back-end. The workstation running Access is Windows 2000 Workstation, and the server running SQL Server is Windows 2003 Server Std. We've been developing in this environment for weeks, but suddenly we're ...
find any character in a string that is a lower case
Min -
28 Oct 2005 6:04 PM - 3 messages
in SQL Server 7, How can I find out if a database field has any lower case character in the string. Thanks! ...
Wrong Record Count
eAW -
28 Oct 2005 5:23 PM - 5 messages
The number of rows shown in SELECT COUNT(*) statement is different from the number displayed on table property. I know the number returned by select statement is correct. How do I correct it? I have tried DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS option. ...
trigger failed to fire when import from EM
Jen -
28 Oct 2005 5:14 PM - 4 messages
Hi, I hava an insert trigger on one of my table A so that another table B is populated too based on some condition. It runs very well normally. But sometime I need to import data into this table A, in this situation, the ...
restore database.
Paul -
28 Oct 2005 4:45 PM - 2 messages
I was attempting to restore a database and it hung up. Now when I try to restore I get the message, re-issue restore statement using WITH REPLACE, but not sure how to do this, is it a restore dbase option through the GUI, thanks. ...
max degree of parallelism Option
Kay -
28 Oct 2005 4:12 PM - 2 messages
Dear all, What is the ideal value for "max degree of parallelism" if we have very long running queries which eat up lots of resources in peak hours. We have 4 processors Dell machine. Our last DBA recommended it to 4 but new ...
max degree of parallelism Option
Kay -
28 Oct 2005 4:12 PM - 3 messages
Dear all, What is the ideal value for "max degree of parallelism" if we have very long running queries which eat up lots of resources in peak hours. We have 4 processors Dell machine. Our last DBA recommended it to 4 but new ...
sp_indexoption
Sohail -
28 Oct 2005 3:50 PM - 2 messages
Hi: I understand that by default sql server using row level locking, however, you can change this using sp_indexoption for a table. How do I find out the type of locking is being used on a table, i.e., row and/or page lavel? I ...
updating records
Johnfli -
28 Oct 2005 3:47 PM - 3 messages
I have a table that gets it's information from a txt file that it imports. When it imports another txt file, I need it to UPDATE the records that have a certain field (the primary field) that are the same. ...
Slow SQL 7 stored procs when DB is read-only
george.semple -
28 Oct 2005 3:46 PM - 4 messages
We have several queries that run very slow on read-only db's but very fast on non-read only db's. Very slow as in 20-30 minutes vs 15-20 seconds so the difference is very noticable. ...
tempdb question for OLTP server
quackhandle1975 -
28 Oct 2005 3:14 PM - 2 messages
Hi, I have an OLTP server that is currently going through UAT before going live in a month or so. Everything has been configured/tuned, etc howevert I was wondering about the tempdb database. It resides on a drive different to all the OLTP databases and currently ...
Stored Procedure vs. Query Analyzer
Steve -
28 Oct 2005 2:59 PM - 3 messages
I need to create a Stored Procedure that will run a query to fill a temporary table. I have run the query successfully from within Query Analyzer to prove that it works, however when I try to use the query from within a Stored ...
SQL 2005 Versions
<<JP>> -
28 Oct 2005 2:36 PM - 7 messages
On MSDN I see SQL 2005 Developer Edition only, but in SQL 2000 I see Standard, Enterprise , etc. Will the SQL 2005 Section have this options also? ...
Urgent -- Access QRY to SQL Server QRY
Joe -
28 Oct 2005 2:12 PM - 2 messages
I have to following Access2003 Code that needs to run in SQL 2000 SELECT extend, Source, Count(PersonalID) AS RecordCount, Count(IIf([Literature1Quantity]>0,([Literature1Quantity]),Null)) AS Item01, Count(IIf([Literature2Quantity]>0,([Literature2Quantity]),Null)) AS Item02, Count(IIf([Literature3Quantity]>0,([Literature3Quantity]),Null)) AS ...
Cross-database Ownership Chaining in SQL 2005
Bill Wang -
28 Oct 2005 1:49 PM - 2 messages
Hi, Sorry to post in this group. It seems only few people in SQL 2005 newsgroup now. I met a problem in SQL SERVER 2005 SEPTEMBER CTP. The option "Cross Database Ownership Chaining" won't work in SQL 2005 Step CTP. But there is ...
Problems with DB 70 GB
Batzal via SQLMonster.com -
28 Oct 2005 12:59 PM - 4 messages
hello, Im trying to update millions of records , to a table , and the SQL SERVER , go too slow ? how can I do ? I have only one datafile , can i split ? It will increase the speed ? ...
any point in putting more than 2Gb ram in machine for standard edition ?
scott -
28 Oct 2005 11:40 AM - 4 messages
if a member server runs 2000 or 2003 with SQL server standard edition is there any point putting more than 2Gb of ram in the machine ? i.e i base this on 2Gb being the max for Sql server 200. ...
Script for reindexing
Kay -
28 Oct 2005 10:11 AM - 4 messages
Dear all, Is there any script available to reindex/ re-create index in a given database. Important is that script should first create clustered indexes and then non clustered indexes as recommended by Microsoft. Regards, Kay ...
SQL2005 ALLOW_SNAPSHOT_ISOLATION & DB Performance
mtcc -
28 Oct 2005 9:33 AM - 3 messages
Snashot isolation is most feature that i waiting for. but i not find Article about how is cast in performance and Size of DB files? I'm sure that turn on the ALLOW_SNAPSHOT_ISOLATION for DB is nee more space and more CPU? ...
Versions
Keld -
28 Oct 2005 8:39 AM - 3 messages
We are about to purchase a SQL 2000 Version to our system which shall run on the internet eg. unlimited users. What are the difference between the following versions and which should we buy Enterprice Version, Standard Version and WorkGroup Version. ...
Start a trace from T-sql
Stijn Verrept -
28 Oct 2005 8:30 AM - 4 messages
I've already searched google groups for this and found xp_trace_addnewqueue to do it. However that procedure doesn't seem to exist in my master database. How is this possible? I checked on multiple servers? How can I start a trace to a trace file and have endtime included? ...
Re: Performance - SQLServer:Buffer Manager Free pages
doller -
28 Oct 2005 6:36 AM - 2 messages
Hi To use the Buffer Cache Hit Ratio. I use that along with SQLServer:MemoryManager\Total Server Memory(KB) and SQLServer:MemoryManager\Target Server Memory(KB). Total and Target values should be equal. Target should never be higher than Total. Target is how much SQL ...
Problem Creating Job and Running The JOb
Faisal Mirza -
28 Oct 2005 5:15 AM - 5 messages
Hello All, I am having problem with my SQL Server 2000. I don't know this is best place to put this question but i don't have any other way. I have sql ...
Developer Edition of SQL 2005
MM -
28 Oct 2005 3:48 AM - 5 messages
Can someone clarify what is the Developer Edition of SQL 2005 (MSDN) - I went to MS SQL site and I do not see a Developer Edition - [link] ...
SBS 2003 running SQL 2005
The Guy -
28 Oct 2005 3:32 AM - 2 messages
Hello I have 2 networks network A and B both networks are running SBS 2003. On Network A I have installed SQL 2005 On Network B I have Yardi SQL Both the networks are being controlled by SBS 2003. What I would like to do ...
SQL 2K 64-bit: Itanium and/or Xeon?
Scagnetti -
27 Oct 2005 10:23 PM - 5 messages
Configuration: SQL Server 2000 64-bit on Windows 2003 Question: Will SQL Server 2000 64-bit run and ONLY run on servers with Itanium 2 processors? This is what I read in the System Requirements for SQL Server 2000 64-bit. So it will NOT run on Xeon. Correct? ...
Table size - how to check?
Marcin Pêksa -
27 Oct 2005 9:16 PM - 2 messages
Hi, probabely this topic has already been brought up so pls excuse me this question. Is there an easy way to check the size of a table with/without the indexes? I'll be grateful for help. Thanks, Marcin ...
Blocking a specific host
Andy -
27 Oct 2005 8:56 PM - 2 messages
here's one... we have a rogue system on our network. Every 8months or so, someone flips the "on" switch to the computer and brings it up. Aparently, it has an application that uses a generic login (used by other applications) to ...
mssqlserver service doesn't start
Gianluca Danielli -
27 Oct 2005 8:43 PM - 6 messages
after installing report services and sp2 , the service mssqlserver does not start in automatic mode and remain in starting. Only in manual mode. Version Sql server 2000 with sp3 Thank you ...
Performance metrics
John T -
27 Oct 2005 8:37 PM - 5 messages
Hello all, I am trying to address some troublesome performance metrics. Specifically, I would like to know where/how I can further investigate and troubleshoot the following items: - the ratio of Buffer Manager: [Total Pages]/[Target Pages]. - the ratio of Memory Manager: [Total Server Memory]/[Target Server Memory]. ...
Lock Query
CLM -
27 Oct 2005 8:17 PM - 5 messages
How do you find what user is locking what row in what table in what database? ...
Shortcut to "Return all rows"?
Doug -
27 Oct 2005 7:42 PM - 3 messages
Only way to get that is to right-click a table name, click "Open Table", and select "Return all rows"? Seems like a thing that should have a button, doesn't it? ...
ANSI Questions
Newbie -
27 Oct 2005 7:21 PM - 2 messages
I have a 6.5 and 2000 db that allows over flow of data to be entered into the fields, but I have another 2000 db that does not allow over flow of data to be entered. How can I check the ansi_defaults in the db's? I went through ...
Editing Data
Preacher Man -
27 Oct 2005 7:09 PM - 8 messages
I am new to SQL so please be patient. I have a database in SQL 2000. When I expand the Database, Tables window, I right click on a table and select return all rows. When I try to edit data in some of the fields it tells me, ...
Error 823, Severity 24, State 2
msnews.microsoft.com -
27 Oct 2005 6:53 PM - 2 messages
Here is my problem: About a month ago or so, I had some hardware problems with a dell server running sharepoint portal server and SQL 2000 on the same server where the server just died a couple of times requiring restart. We got the hardware ...
How to Install 2nd of MSDE
Ken -
27 Oct 2005 6:43 PM - 2 messages
I am trying to install WSUS on a Windows 2000 server that already has MSDE 2000 SP3a installed for Backup Exec. Unfortunately the WSUS installation returns the following error: "- a database server could not be detected" I believe WSUS is looking for an instance called "WSUS". ...
Get sa password
Frank Moskopp -
27 Oct 2005 6:34 PM - 12 messages
Hey, I admin an company with MS SQL-Server. They forget the sa-password. Is there any way to get the password from an running sql-server? I need it for SQL-Backup! Thanks for answere Frank ...
Starting and Stopping SQL Agent with a Command?
TJT -
27 Oct 2005 5:46 PM - 5 messages
Is it possible to start or stop SQL Agent through a command or is this something that has to be done through SQL EM? I tried to run a profiler while starting and stopping SQL Agent but I never saw anything in the trace. ...
Sql Server 2000 slow performance
Helen Stein -
27 Oct 2005 5:36 PM - 2 messages
Hi, Thank you for reponses. We still have an issue with the server performance. I do not have any experience with reading trace files. Can someone help? Thank you, Helen The file is attached. [attached file: trace 10272005.zip] ...
Calling an .EXE from a SQL Job?
Dave -
27 Oct 2005 5:17 PM - 4 messages
I'm trying to call a .exe as a Job Step that pulls some data and sends out custom emails that will execute after a DTS package runs. I tested the EXE from the command line and it works but I don't know how to call it from with ...
How to Increase the number of Seats and Processors after Installation.
sasiraj -
27 Oct 2005 5:02 PM - 2 messages
Hi, While installing SQL Server(2000) we will be asked to give the info regarding the Number of Seats(per seat) and Processors(per processor). If there are more licenses bought after the installation how to increase these values or ...
blank spaces....
Larry Smith -
27 Oct 2005 4:26 PM - 2 messages
select * from Customer where customerId ='123 ' select * from Customer where customerId ='123' Both the above queries return the same result. What is the property which ignores the white space character? SQL 2K. Thank you, Larry ...
Sql Server 2000 diagnostics
Helen Stein -
27 Oct 2005 4:05 PM - 2 messages
What items in a trace file should we capture that would show most information for diagnostics of the slow server response? Thanks ...
Sql server 2000 performance
Helen Stein -
27 Oct 2005 3:36 PM - 4 messages
Hello, What are the most common reasons for slowing down of the SQL server 2000? Thank you ...
Performance issue (I'm stumped)
Stijn Verrept -
27 Oct 2005 3:05 PM - 5 messages
We had a SQL server instance running fine for a server which also acted as terminal server for about 25 users. This ran fine and recently we decided to split the SQL server to a dedicated server to get better ...
Estimated cost shows 300% in query plan
Rudi Bruchez -
27 Oct 2005 3:05 PM - 6 messages
Hello all, On a SQL Server 2000 sp4, on a 4 Xeon cpus (with hyperthreading) machine (Windows Server 2003), most of the query plans I see are showing, on the estimated cost of each step of the plan, more than 100% (e.g. 300% for a ...
Starting SQL server in Single User Mode via Scheduled Task
Jeffrey S via SQLMonster.com -
27 Oct 2005 3:05 PM - 3 messages
I have a Windows Scheduled task that points to a .bat file with this content sqlservr.exe -c -m The script runs but then stops at this line: Recovery complete. SQL global counter collection task is created. The command bat file does not close...any thoughts? ...
update table 1 with data from table 2
Christian Risager -
27 Oct 2005 2:26 PM - 3 messages
Hi there I would like to imeplement a stored procedure that updates table A with selected data from table B - but don't know much about stored procedures yet. Can anyone provide some kind of sample that loops through a table and make ...
SQL Server Time out error
harkit -
27 Oct 2005 1:25 PM - 3 messages
Hi I have a stored procedure that retireves a record from the SQLServer 2000 database based on an ID field. I am calling that stored proc from a COM object method. This COM object is being created and its method is ...
Backing up .mdf and .ldf files
Skc -
27 Oct 2005 11:51 AM - 3 messages
I want to copy and paste .mdf and .ldf from our SQL server. Am I correct in saying that the mdf and ldf files are locked into th SQL databases and require the files to be detached via Enterprise Manager (for ...
Find the Data Bases which can not be Backed up are some resons
duraisridhar -
27 Oct 2005 10:29 AM - 3 messages
hi all., How can I find the Data Base which can't backed up for reasons like Data Base is in the middle of the Restore before i start Backup Process . Regards., Sri ...
whitespace trimming in DTS or SQL
Patrick -
27 Oct 2005 10:22 AM - 3 messages
I have a SQL Server 2000 DTS Package, where within a Data Transformation task, with source being a text file delimited with ~¬ and destination being a SQL Server table, I tried to use the "Trim String" transformation to transfer ...
Events 311, 312, 318.
The Vogon -
27 Oct 2005 7:33 AM - 3 messages
Each time I clear the event log on two of our SQL servers, I get the following errors a few seconds later (see below). Config is as follows: Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web servers). Any help in clearing up these annoying error messages would be appreciated. ...
Repository of databases
Frank Rizzo -
27 Oct 2005 6:53 AM - 4 messages
Hello, I've written a tool that analyzes databases. However, to test it out really well, I need to feed it a lot of different databases. Is there a place where I can download either .mdf/.ldf set of files or sql scripts ...
0x7D006C07A007D006C07B00
Jason Huang -
27 Oct 2005 4:28 AM - 2 messages
Hi, When I do the SELECT command in the SQL Query Analyzer for a particular table column, the output is 0x7D006C07A007D006C07B00. But what's the real value in a READABLE text format? Thanks for help. Jason ...
How to view store procedure source code under console environment
Fox newbiew -
27 Oct 2005 4:20 AM - 2 messages
Dear folks, I would like to find out how to use sql statment for displaying source code of store procedure under console environment. thx in advance ! Best Regards, Fox NewBiew ...
How to do the sorting sequence in numbering order
Fox newbiew -
27 Oct 2005 2:21 AM - 2 messages
dear folks, I would like to know that how to do the number sorting in numbering sequence ? ...
SQL 2005 CTP
>>JZ<< -
27 Oct 2005 12:44 AM - 3 messages
Will the September SQL 2005 CTP be upgradeable and supported by Microsoft? ...
Indexed View Issue
Ron West -
26 Oct 2005 11:02 PM - 2 messages
What I am attempting to do is to denormalize some of our data into a view and then publish this data as a table via replication. Heres a similar script: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO Create View vwBlah with Schemabinding ...
low cpu usage
Wisconsinace -
26 Oct 2005 9:58 PM - 2 messages
Ever night I run a very intensive DTS package between on database on the server to another database located on the same server. Even though no else in connected to the server it only run at 25% of CPU usage across all 4 CPUs ...
low cpu usage
Wisconsinace -
26 Oct 2005 9:56 PM - 2 messages
Ever night I run a very intensive DTS package between on database on the server to another database located on the same server. Even though no else in connected to the server it only run at 25% of CPU usage across all 4 CPUs ...
ANSI_DEFAULTS
Newbie -
26 Oct 2005 7:45 PM - 2 messages
I have a 6.5 and 2000 db that allows over flow of data to be entered into the fields, but I have another 2000 db that does not allow over flow of data to be entered. How can I check the ansi_defaults in the db's? I went through ...
Much bigger result from Count(*) than Max(table identity number)
ktf -
26 Oct 2005 7:43 PM - 11 messages
The problem I have is the count(*) or count(table identity column) show a much bigger number than the actual number of rows. When I run select count(*) from tablename I get ~87,000,000 in return. But the MAX number of table identity is in 10 M range also rowcnt from ...
Is QUICKSHIFT Real?
SB99379 -
26 Oct 2005 7:36 PM - 2 messages
QuickShift is advertising a software product to radically improve SQL performance. They claim to be Microsoft certed. Does anyone know if this product is real? If it is it would lead one to ask why Microsoft has not ...
MSSQLserver
RonP -
26 Oct 2005 7:05 PM - 3 messages
I have lost my password to my SQL server can someone help me retrieve it or should I delete this server and download a new one? ...
Great plains + instances
Cesar -
26 Oct 2005 6:13 PM - 2 messages
Hello there, Is it possible to install MS Great Plains on a SQL Server 2000 instance, which is no the default one, and still the product (dynamics) to work properly? If it's possible, is there any special consideration that I must be aware of ? ...
BCP
docsql -
26 Oct 2005 5:24 PM - 3 messages
1. When using BCP to copy data into a table, which of the following statements apply? Choose 2. A) Database users will not be able to access the table because BCP ...
Problem Moving and Restoring a Large database
Nancy Lytle -
26 Oct 2005 5:03 PM - 8 messages
We have a 48 gb production database (SQL 2000 sp4 and Windows 2003) and I have requested the Net Admin to take the last full backup of this database, move it to another server and restore it on that server. ...
T-SQL Question
Mike Collins -
26 Oct 2005 4:51 PM - 3 messages
The following sql statement does not return the correct number of rows (too few). There is either many rows or no rows in documentation for each row in sites. How can I write the sql statement to only return the one documenation ...
Non-Cluster Index PK
Joe K. -
26 Oct 2005 4:21 PM - 3 messages
I have a client that has created Primary Keys with Non-Cluster indexes. These Primary Keys are usually monotically increasing. Who much will this slow down table joins using Primary Keys that Non-Cluster Indexes. Please help me with this topic. ...
1 SP -> Multiple result sets -> multiple text files....How?
Corey Bunch -
26 Oct 2005 3:59 PM - 3 messages
I want to write one SP which returns multiple result sets, but route each result set to a different text file output. Currently the only way I can think of to do this is to build each query as a string in the ...
Entering maintenance mode through Enterprise Manager?
Neil W. -
26 Oct 2005 3:53 PM - 2 messages
Is there a way of entering maintenance mode ("-m") through Enterprise Manager (2000), rather than running sqlservr.exe directly? Thanks! ...
Script to Set User Permissions to Insert and Update Only
O.B. -
26 Oct 2005 3:42 PM - 2 messages
Is there a script built into SQL Server that given a specific user and database will change the user's permission to only insert and update tables? (I'd like to avoid the task to manually having to do this using ...
move a single table
Rich -
26 Oct 2005 3:36 PM - 6 messages
Hello Group, how can I move a single table from one server to another? I have to preserve the record id numbers (identity) and the table to receive the data is slightly different than the table sending the data. ...
Default Instance Named MSSQLSERVER
Scott -
26 Oct 2005 3:10 PM - 4 messages
Does anyone know why, when I install SQL Server 2005 Developer (September CTP) and select Default Instance during setup that I see the following in the SQL Server 2005 Services area of SQL Server Configuration Manager. SQL Server Agent (MSSQLSERVER) ...
Windows Server configuration to support 300 GB database
Prashant Bharti -
26 Oct 2005 2:18 PM - 2 messages
Hi, What should be ideal windows server configuration to support 300 GB database in SQL Server 2000 & 2005? I mean number of processors, RAM, etc. Thanks Prashant ...
Q: SP4
JIM.H. -
26 Oct 2005 1:08 PM - 6 messages
Hello, I just installed SQL Server 2000, I noticed that there is SP4, do I need to install SP3 and then SP4 or I just directly jump to SP4 without installing SP3. Thanks, ...
T-SQL Newbie : String Manipulation
Andi -
26 Oct 2005 12:53 PM - 2 messages
Hi, I am new in T-SQL and I am trying to transform a personal number to a special format. I am using DTS to import two tables into SQL Server. One table has the personal number format, that the number is every time ...
Stored Procedure with variable parameters
Pieter -
26 Oct 2005 12:23 PM - 4 messages
Hi, I have a View which contains (of course) several columns. Now I want to make a Stored Procedure that does a Select based on the parameters. For exemple: One time I want to select all the reocrds with ColumnA = 'Value ...
|
|||||||||||||||||||||||