|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Help with using OUTPUT parameter
thegekkster -
3 Jun 2006 10:57 PM - 4 messages
Hi all, I have a procedure (sp1) that needs to execute another procedure (sp2); need to set a variable (@pass) in sp1 with a value generated within sp2. SP1 is called, executed from within ASP. As it is currently I get a value of 0 [zero] ...
Applying sp4 to ss2000
Tina -
3 Jun 2006 9:51 PM - 2 messages
When trying to upgrade to ss2005 the install program said that I needed to install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with my msdn disks. When I try to apply sp4 it says that "another operation has ...
sql 2005 partition alter table switch error
james -
3 Jun 2006 7:37 PM - 6 messages
Hi! I am testing switching non partition table to an empty partition in partition table in sql 2005 sp1 and I am stuck at the alter table switch statement where its giving following error. I have made sure that the check ...
SQL XML Support in SQL 2005
Amit Bansal (MCT, MCSD.NET) -
3 Jun 2006 6:49 PM - 5 messages
Hi, In SQL Sever 2000, we can configure SQL XML support in IIS in order to retrieve xml data in in a browser via http. How can we do something similar in SQL 2005? WHat about the tool SQL XML? ...
SQL Server 2005 / 2000...
Rob Meade -
3 Jun 2006 6:44 PM - 5 messages
Hi all, Just a quick question if I may... At work we're not quite ready to make the jump to SQL Server 2005, and, typically, what we do at work reflects on what I do at home on my little ...
return value of EXECUTE sp_executesql(SQLString)
JIM.H. -
3 Jun 2006 5:55 PM - 2 messages
Hi, How can I check return value from EXECUTE sp_executesql(SQLString) Thanks, ...
SQL2k5 system views
Tim Greenwood -
3 Jun 2006 2:09 PM - 3 messages
It is pretty easy to find most things in these new views.... sys.databases sys.columns sys.tables sys.procedures etc.... but where are the user functions ?? I can't seem to find them anywhere. ...
q; loop for insert into
JIM.H. -
3 Jun 2006 1:21 PM - 3 messages
Hello, I have 10 tables (T1Orj,T2Orj,…T10Orj) and I need to find modified rows from each table and insert them to T1Bak, T2Bak, …T10Bak. Although original and bak tables have the common fields , the original tables have more fields than ...
SQL Server Backup Appears to be "stuck" - can we abort backup?
Todd P -
3 Jun 2006 1:11 PM - 3 messages
We started a native SQL backup of two databases to an external hard drive as a test of the external drive as a backup device. The backup was running very long as the databases being backed up were over 200GB. We stopped the ...
SQL Server jobs taking time
Javed Iqbal -
3 Jun 2006 12:26 PM - 3 messages
Gurus, I regret for reposting this question again. My sql jobs are failing on high end server where as these jobs runs extremely fine on low end server. Following are the configs A- High End server H/W: 4 Processors, 2GB RAM ...
Why is my trans log filling up?
Simon Harris -
3 Jun 2006 12:14 PM - 5 messages
Hi All, I am trying to diagnose why my transaction log is filling up - We are filling 100mb in a matter of 24 hours on what I dont consider to be an overly busy application. The only two chunks of code that do a lot of inserts/updates. One is a ...
generate SQL Script
beachboy -
3 Jun 2006 5:52 AM - 4 messages
Hello, Is possible to generate SQL script which included all schemas and data as well... I use "Generate SQL Script" can only generate table schema, store proc,.. but no data inside.. but i believe that it should have a method bcoz some partner will send these ...
Will Multiple databases vs One Help Blocked Processes?
jenniferbland -
3 Jun 2006 5:40 AM - 2 messages
My company serves many clients. Each client has their own web application with a common code base and therefore all share one database. Each client is assigned a unique client id, which is how we separate the database logically. The web application is built using ...
Version of Sql Server 2005
Sandy -
3 Jun 2006 5:15 AM - 2 messages
hi Can anybody tell me which edition of Sql Server 2005, which i have to use in order to be a MCAD. Sandeep ...
Rename or purge my SQL Server 2000 transaction log file
Spin -
3 Jun 2006 3:51 AM - 2 messages
Gurus, How do I Rename or purge my SQL Server 2000 transaction log file? I have successfully renamed the database using the ALTER DATABASE. I have successfully renamed the physical MDF file by detaching the database, renaming the file, and bringing it back online. However the transaction log ...
installing 2005 over 2000
Tina -
3 Jun 2006 12:50 AM - 4 messages
I tried to install 2005 and chose the option to upgrade my existing default instance. Then it errored out saying, I think, that I need to apply service packs to my existing 2000 instance. Why would I need to upgrade something I'm installing over? ...
Closest in Column
tarry -
2 Jun 2006 11:42 PM - 8 messages
What SQL statement do I use to find what is the closest value in a data set to the value I have. For example I need to search in a column for the closest value that exists to what I have: ...
2000 2005 question
Tina -
2 Jun 2006 11:22 PM - 2 messages
I now have ss2000 on my two dev boxes and it is used by numerous asp.net applications on those two computers. I want to migrate to ss2005 and I don't see any reason to ever use ss2000 again as none of my apps will ever ...
SELECT INTO with a table variable?
Kevin Burton -
2 Jun 2006 9:11 PM - 7 messages
Is is possible to do something like this: SELECT A,B,C INTO @TableVariable FROM @AnotherTableVariable? I try it and I get syntax errors and I am not sure if it is just something I am doing wrong or if it is something that is not supported. I know when I use ...
Changing the columns of a SELECT statement.
Kevin Burton -
2 Jun 2006 8:01 PM - 5 messages
I have been "noramlizing" some of the tables that we have been using and I ran into a problem in one of our stored procedures. It used to be (with the old table) that you could do something like: SELECT A, B FROM OldTable ...
Sql2005tabase restore
mecn -
2 Jun 2006 7:42 PM - 4 messages
Hi, I am able to restore a database in sql2005 from running the following script. but I don't know how to specify the bak file path in sql2005 restore interface wizard. I could specify the path locally not from another server. ...
SSIS 'Product level is insufficent for component'
Chris Wood -
2 Jun 2006 7:00 PM - 3 messages
Hi, We are seeing this message when try to import a fixed width text file into a database table from a workstation running SQL2005 gold tools to an SQL2005 gold server. The messages we get are:- Error 0xc00470fe: Data Flow Task: The product level is insufficient for ...
Calculating leaf pages
cbrichards -
2 Jun 2006 6:43 PM - 2 messages
I am trying to understand an example of indexing I read about. Given the following SQL statement: select title from titles where price between $20.00 and $30.00 The size of the table in rows and pages, the number of rows per page, and the ...
Moving Replication Distributor/Publisher
Tony -
2 Jun 2006 6:11 PM - 3 messages
I have an SQL Server 2k box set as a publisher/distributor with several publications. Each publication has two subscriptions each to seperate sql 2k servers. I need to move the existings replicated databases from the current publisher/distributor to a new SQL 2k5 Server that will act ...
Date problem
DXC -
2 Jun 2006 6:10 PM - 5 messages
I have a table that has two datetime columns and the following stored procedure: create proc sp_BTInsertInitialValues @BankID nchar(3), @Librfacr nvarchar(3), @Modtrack nvarchar(3), @Fix_init_rate nvarchar(50), ...
xp_sendmail: failed with mail error 0x80070005
julian_cabreras -
2 Jun 2006 5:54 PM - 2 messages
Hi, nowadays I am using a SQL2K Server running with a Domain-Account, Outlook2k2, and Service Pack 4. Also I have created a Outlook profile for SQL Account. If I login and open Outlook session, i am abled to send/receive emails. ...
Log File Filling Up
Simon Harris -
2 Jun 2006 5:08 PM - 7 messages
Hi All, Recently we have experienced a problem with our transaction log file filling up. The application is a moderatley busy e-commerce site. The database is set to simple recovery mode. The transaction log space is 100mb. This is ...
SQL Statement COUNT() on a bit field
Darren.Ratcliffe -
2 Jun 2006 4:23 PM - 10 messages
Hi everyone I hope your week has been going well! I am tying to write a view on a table, something like this. T_People -------------- PersonID (int) PK DepartmentID (int) FK PersonName (varchar) IsBoy What I would like to do is return a recordset (in a view) of how many ...
detaching db and attaching to another server
Dan D. -
2 Jun 2006 3:53 PM - 3 messages
Using SS2000 SP4. I've detached a db from server A and been able to attach it without any problem to server B. However, if I try to attach it to server C, the database shows as read-only. The same thing happens with other databases ...
Allocation Error in Master DB
Dragon -
2 Jun 2006 3:45 PM - 4 messages
Hi, I wanted to find out if there is a way to fix Master DB. I ran DBCC and it shows some allocation errors. I understand I can run Repaid_Allow_Data_Loss with other databases but not with Master, Is this correct? Is there another ...
SQL Limited on concurrent queries
Bruno -
2 Jun 2006 2:46 PM - 2 messages
Hello Friends I have a client saying that has SQL Server 2000 Standard, and this client said that some times the database hangs up, and stop. On the event viewer this client found the following message: This SQL Server has been optimized for 8 concurent queries. ...
Eliminating (x row(s) affected) message
Kevin Burton -
2 Jun 2006 2:39 PM - 3 messages
I am sure this has been asked before. But, in searching for this message I get a number of returns. How do I eliminate the (x row(s) affected) message from queries in a stored procedure? Thank you. ...
database import question
mattdaddym -
2 Jun 2006 2:21 PM - 5 messages
Hi all, I have a database I maintain that has grown quite large. The part of it I am interested in, is one paticular table that logs the history of certain high volume "events". I have events back to 2002, and the ...
Transacation log truncate
Hitesh Joshi -
2 Jun 2006 2:15 PM - 3 messages
Hi, I have a MS SQL 2000 server database with gazzzzzillion rows. Last night I backed up lot of the data and deleted it from the database to clean it. After deleting data from the database, I did full backup and ...
parent child - get all children for a specific row
Saya -
2 Jun 2006 2:06 PM - 2 messages
Hi, I am trying to create a bulletinboard app. So I have a thread table with parent/child relation. How can I on a specific threadID get all its children ? Any help/hints will be greatly appreciated :-) Regards Saya ...
q: date to string
JIM.H. -
2 Jun 2006 1:20 PM - 2 messages
Hi, @MyDate is a datetime passed into a stored procedure. SET @mySQLStr = @ mySQLStr + 'WHERE myDate > ' + @MyDate This does not work since @MyDate is not a string, how should I handle this? ...
Need help on writing a stored proc to search the database - we are using SQL Server 2005
Learner -
2 Jun 2006 1:12 PM - 7 messages
Hi Friends, I am just wondering if some one could help me with a complex stored proc to search the database. I am building a ASP.NET 2.0 webform with around 8 fields to search the datbase. User is not restricted to enter only certain info. He/She can ...
Stored Procedures
gopal -
2 Jun 2006 10:53 AM - 3 messages
Hi, I have SQL database having storesd procedures nearly 2000, i am in process of documenting only the stores procedure name and its in & out parameters, Is there a way to copy only the SP Name and its parameters ? I tried ...
Detaching a database and CHECKPOINT
Hans Dingemans -
2 Jun 2006 8:45 AM - 3 messages
Hi, can someone confirm that SQL Server 2000 (SP3a) ALWAYS does a CHECKPOINT upon detaching a database, so that the MDF/NDF files are "self-supporting"? That would mean I can delete/rename the LDF file and have it recreated by ...
Swedish collation, 'V' = 'W' rule and different behaviour for VARCHAR and NVARCHAR
Alex Sadomov -
2 Jun 2006 8:43 AM - 2 messages
hi There is a problem with sorting in db with SQL_SwedishStd_Pref_CP1_CI_AS collation. As I'd known there is a specific rules in the swedish language, one of which is 'V' = 'W' (this rule was revoked by swedish academy since april 2006 - [link]). ...
SQL Server 2005 - database creation
12jumper -
2 Jun 2006 8:17 AM - 3 messages
Hi, I.m new to SQL Server, so my question can look ridiculous, but it's a serious problem for me :). Each time I create a new database, tables from all other databases are automatically created in this new one. I ...
deadlock issue in sql server 2000 enterprise edition version 8.00.
Rajeev Rivankar -
2 Jun 2006 7:55 AM - 5 messages
we have installed sql server 2000 enterprise edition on our erp server. We are facing frequent deadlock problem ie one process blocks the other process frequently. The compatibility of the databases has been set to 80. First of all whether the version is that of enterprise edition ? ...
SQL 2005 + SMS 2003 Server
OvTech -
2 Jun 2006 5:28 AM - 3 messages
We currently have one server a Dell PowerEdge 2.8 Ghz Xeon w/ 4 gigs of RAM which acts as domain controller, email server, file server, and print server. We are thinking about deploying SQL 05 (about 20-30 database users) ...
How to select record from database?
SSG -
2 Jun 2006 5:04 AM - 3 messages
Hai All! I am new to database ... I have One databse having 10 tables in sql server. I stored data in differnt table using city wise. If I Give the "Code Num " it should tell me the city name, I dont know ...
transaction log backup job fails
Cam -
2 Jun 2006 4:47 AM - 3 messages
I'm having difficulty setting up a basic db maintenance plan using SQL Server 2000. Using the db maintenance plan wizard I create a db backup routine that backs up the database and the transaction log (note that the database ...
SQL 2000 Database Log Space Left
Ivan -
2 Jun 2006 3:02 AM - 13 messages
Dear all, I have set the database to Simple Mode and the log size is limited to 800Mb. However, the log is still out of space. Is there any method to check the database log space left? Ivan ...
Sql Server 2005 for MCAD
Sandy -
2 Jun 2006 2:25 AM - 3 messages
Hi everybody, I am, a resident of India, brand new to the MCAD certification. After doing MCA, I have no job experience & working on VS.NET 2002 & .NET Framework 1.0 at home. My language, which I use for server-side ...
W2k3 SQL2K 4GB
msforums.microsoft.com -
2 Jun 2006 1:18 AM - 8 messages
What should i do? Every article tells big story without a conclution. /3GB ? /PAE ? AWE enable? Thank in advance! ...
Why is this SELECT query hitting the physical disk every time?
Jordan Russell -
1 Jun 2006 9:42 PM - 10 messages
Hi, Server: SQL Server 2000 SP4 (all default settings) Database size: 20 MB I'm no SQL Server guru, and I've run into a performance issue I can't make any sense of: I have a table with 20,000 rows and no indexes. When I run the following ...
Restricted Resources Can Used By SQL Server Account
Joe K. -
1 Jun 2006 9:29 PM - 2 messages
I have windows user account this set up on a Windows 2000 Advanced Server that is used by several SQL Server 2000 databases. This windows user account was set up with db_datareader access to several databases on this database server. ...
Number formatting
Joe -
1 Jun 2006 9:26 PM - 3 messages
Here's a quickie - I have a stored procedure which returns a list of numbers. I want the output formatted with commas so 95,000 instead of 95000 - how would I do that? ...
Can I shrink a table in SQL Server 2000?
Dave -
1 Jun 2006 8:36 PM - 2 messages
I have a table that has a ton of unused space in it (1.8 GB). Is there any way to shrink just a table or do I have to shrink the whole DB to recover that space? ...
Does Standard Edition 05 limit # of CPUs or not?
Terry -
1 Jun 2006 8:10 PM - 2 messages
I am hoping you can clear up a discrepancy involving processor restrictions with SQL 2005 Standard Edition. The latest BOL from April 06 shows no processor limit for standard edition. BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/cd308bc9-9468-40cc-ad6e-1a8a69aca6c8.htm ...
Query Question - Table Variable vs. Temp Table (2)
Amos Soma -
1 Jun 2006 6:22 PM - 2 messages
I have the query shown below. It works fine as written. However, if I substitute a Table variable for the temp table, I'll get an error when the statement is run saying something to the effect that 'scalar variable @T is ...
How do I write to SQL Server 2000 Error Log
tpp -
1 Jun 2006 6:11 PM - 2 messages
I want to use the sp_addmessage and add a message so that I'll be notified when the message is written to the error log but I dont know how to write to the SQL error LOG. Can someone tell me how I do that? Also, I need to get ...
Use row number to select?
supersonic_oasis -
1 Jun 2006 5:31 PM - 3 messages
Hello all, I am using SQL 2000 SP4. I have a table with a studentID column. Is there any way to select a single row of data from that column by referencing the row number? ex. select studentID from Table where row = 2 ...
Partitioning Questions
Andre -
1 Jun 2006 3:56 PM - 5 messages
I'm looking at using table partitioning in SQL 2005 and have a few questions. a.. Is partitioning really only available in Enterprise Edition? I have Std Edition and when I tried to create a partitioning function, it told me ...
ss2k5: List of funtions
sck10 -
1 Jun 2006 3:41 PM - 4 messages
Hello, In SS2K5, what [sys.] table do you call to get a list of all the functions? ...
SQL 2000 & SQL 2005, Can they coexist?
Jorge Luzarraga -
1 Jun 2006 3:35 PM - 2 messages
Hi, I wonder If I can have both SQL2K and SQL2005 installed on my windows XP box. TIA, Jorge Luzarraga C ...
SQL server 2005 - DENY permission issues
Chris Leroquais -
1 Jun 2006 3:05 PM - 2 messages
Hi, i'd like to deny permissions on system objects to the public role in a database. I have tried using the following commands without any success: DENY SELECT ON SCHEMA::sys TO public or DENY SELECT ON sys.sysobjects TO public ...
Fatal exception while executing detail dm view query: sys.dm_db_index_physical_stats(DB_ID(), NULL,
Vimas -
1 Jun 2006 2:44 PM - 4 messages
When I am executing query SELECT OBJECT_NAME(object_ID), * FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED') WHERE index_ID IN (0,1) I am getting error below. Anyone knows why I am getting this fatal exception (it terminates connection) Msg 0, Level 11, State 0, Line 0 ...
Sql Server Performance using Min/Max for Date fields
jdornan -
1 Jun 2006 2:38 PM - 3 messages
I have been experiencing performance issues when using multiple min/max functions within a query. The query is listed below. The min/max fields I am comparing are dates. If I run the query through query analyzer it takes about 10 seconds to ...
New bit vs. character column.
ChrisR -
1 Jun 2006 2:30 PM - 3 messages
SQL2K SP4 I asked this question yesterday but I didn't make clear what Im trying to find out and what my goal is. My goal is to keep things fast first, use less storage second. Im creating a DB that has several "yes" or "no" coulmns in it. The data is ...
assign sql result to a var?
supersonic_oasis -
1 Jun 2006 12:56 PM - 4 messages
Hello all, I am using SQL 2000 SP4. I was wondering if there was a way to assign a sql result to a variable. The sql result I want to assign only returns one number. Any help is appreciated, thanks. ...
restore database from another server
tony wong -
1 Jun 2006 12:29 PM - 5 messages
after restore database from another server to a new server, i cannot delete the past user attached to the database. some objects are attached to the user, the user cannot be dropped. how can i remove the user. i saw some solutions but cannot search them out. ...
Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after check results)100% passing gaurantee
do_exams@yahoo.com -
1 Jun 2006 12:17 PM - 4 messages
FRIENDS Here i m going to tell you the fastest way to get MICROSOFT,CISCO,COMPTIA,ORACLE,SOLAIS certified without efforts...... friends i have five vue and prometric testing sites here in INDIA.......so, i will do the exams on the behalf of the candidates, ...
DBCC SHOWCONTIG incorrect?
Shirley -
1 Jun 2006 11:48 AM - 6 messages
Hi. I have a table that has 58 million rows and is about 24 GB. I ran a DBCC DBREINDEX which appeared to run fine - new fillfactor showing etc. However, showcontig still shows the indexes as being badly fragmented. I've run an ...
Trigger on database
Jason Huang -
1 Jun 2006 8:57 AM - 5 messages
Hi, As far as I know, when we CREATE a Trigger, it's ON a Table. Is it possilbe that we create a trigger ON Database? What I want to do is like this: Create Trigger MyTrigger ON MyDataBase. Whenever we update a row on a table which name is like Customer%, ...
xp_smtp_sendmail: Error connecting to server
jouj -
1 Jun 2006 7:41 AM - 5 messages
Hi, I'm Using "xp_smtp_sendmail" from [link] It was working just fine when suddenly I encounter this error: Error: connecting to server [192.168.1.10] note:The SMTP port is always the default 25. ...
running DTS with oracle connection problem
Ken -
1 Jun 2006 5:19 AM - 3 messages
I have a DTS that grabs data from Oracle 9.2 into SQL 2000. If I run the DTS, everything works fabulous. The problem is running this DTS in a job in SQL Agent. The job just stop at the point of connecting to ...
What is Oracles max user connections/max worker threads ?
Hassan -
1 Jun 2006 3:28 AM - 3 messages
I know this is not a SQL question, but I use SQL and i know we have a max cap on 32000 user connections and 256 worker threads(ideal setup ) Does Oracle have such a limitation ? Thanks ...
detect replication erros
FJC -
1 Jun 2006 3:25 AM - 2 messages
Hi, I'm running SQL Sever 2000 SP4 and am replicating a database. This is the scenario: Server1 : holds the source database to be replicated (publisher) Server2: is the one that receives the replicated data (suscriptor) Some times it happens that the replication goes down and we do not realise ...
Windows user account cannot start MSSQL Server service
Alan -
1 Jun 2006 1:17 AM - 6 messages
Windows XP SQL Server 2000. My machine name is 'ATSE', profile is 'Alan Tse', password is 'alan'. I have created the login in EM of this ATSE\Alan Tse and right click the server instance, properties, Security tab. In Startup service account, I choose 'This account', type in 'ATSE\Alan Tse' ...
performance
Hoosbruin -
31 May 2006 10:56 PM - 2 messages
Are there any out of the BOX performance gains going from sql7 to sql2000 ? Thanks ...
List of stored procedures
sck10 -
31 May 2006 10:27 PM - 5 messages
Hello, What table can you use to get a list of all of the stored procedures in a database? I need to be able to delete the ones created by users. I am assuming that I will need to use a cursor to step through and delete them. ...
Delete Foriegn Keys
sck10 -
31 May 2006 10:22 PM - 2 messages
Hello, I am trying to delete all of the tables in a database. I wrote the following cursor to step through all of the tables so that I can drop all of the foreign keys if they exist. However, it generates all of the indexes ...
Bit or character data type?
ChrisR -
31 May 2006 10:08 PM - 3 messages
SQL2K SP4 Im creating a DB that has several Bit coulmns. The data is coming from a mainframe. When one stored proc is run, the result set needs to have a "y", an "n", or a " '' " (space) as thats the way current systems work. Another ...
restore from SQL Server 2005 to Express 2005 problems
Dabbler -
31 May 2006 8:46 PM - 4 messages
I'm getting the "Too many backup devices specified for backup or restore; only 64 are allowed" when I try and restore a database backed up on my hosting service SQL Server 2005 to my local SQL Server 2005 Express. ...
SQL 2k DB Maintenance - Integrity Chk Failures
msnews.microsoft.com -
31 May 2006 6:24 PM - 2 messages
Can some one please tell me what these errors mean? I have been looking for weeks to resolve this problem. Win2000 SP4 and SQL2000 SP3, Dual Processor, 4Gig Ram I used the Maintenance module of EM to setup and schedule Backups, ...
backup cannot make a copy of the database
Mike Ryan -
31 May 2006 5:01 PM - 4 messages
I have a client who would like to automate the backup. I have used nti backup for cd's and microsofts backup utility that came with windows 2000. They both state that the files cannot be backed up because the ...
Restore SQL database
Elvis -
31 May 2006 4:39 PM - 3 messages
Hi, There are two recovery models of SQL Server databases. The "SIMPLE" and "FULL" and also bulked but I am not interested in that. I need a full recovery model as I need to recover the most amount of data ...
Which is faster - comments appreciated...
almurph -
31 May 2006 4:14 PM - 2 messages
Hi everyone, Got a question for you. Which would be faster: a. Joining 2 separate tables each with a full text index on the applicable fields or b. Joining 2 separate tables - 1 of which has a FTI on the applicable ...
Bulk Insert (type mismatch) on datetime field containing NULL
rai_sk -
31 May 2006 3:18 PM - 2 messages
Can anyone help please, I am using bulk insert for the first time. The statement I am running is: BULK INSERT Titles FROM 'c:\Titles.txt' WITH (FIRSTROW = 3, FIELDTERMINATOR = '\t', ...
problem restoring master , model , msdb datbase
maxzsim -
31 May 2006 3:10 PM - 2 messages
Hi , I am having some issues restoring the following databases i tried to follow the steps in the articles --> [link] what i have done : - i am trying to restore all the databases back to the same location after ...
Cannot Register Any Instance of SQL Server 2000 to AD
Dominick D. -
31 May 2006 2:55 PM - 9 messages
Hello; I keep getting this message, 'SQL Enterprise Manager could not add server '(local)' to AD. Error: 14303: Stored procedure 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this mean? I am the SA of this instance; I am the dbo, if you will, also. So, I ...
correlated subquery syntax
Alex -
31 May 2006 2:48 PM - 3 messages
How do I write the following Ocacle SQl in MS SQL syntax? I call it an in-line query or correlated subquery Select 1.name name, 1.data table1Data, 2.data. table2Data, 3.data table3Data from (select name, data from table1) 1, ...
SQL Server 2000 - Access Violation Error message
James -
31 May 2006 2:46 PM - 2 messages
Hi, my SQL server crashed last week with the following error in the Application Event log. Event Type: Error Event Source: MSSQL$CARR Event Category: (2) Event ID: 17052 ...
Upgrade path to SQL 2005 from SQL 7
SA -
31 May 2006 2:29 PM - 2 messages
I wanted to know what would be the correct upgrade path from SQL 7 to SQL 2005. Thanks all, SA. ...
Purchasing Microsoft SQL Server for small company
Eddie -
31 May 2006 2:28 PM - 8 messages
I currently have a database through a company that has been upkeeping SQL and storing data. I am cancelling subscription and want to retrieve data. They are sending me a backup DVD with all the files. How easy is it to use ...
Backup status/timestamp
Rusty -
31 May 2006 2:27 PM - 3 messages
Hi, I was wondering if anyone had a sql script that can pull the last backup timestamp as displayed when you check database properties in Enterprise manager. Thanks Rusty ...
SQL Server SP3 / SQL Server SP4 Mixed Mode ???
Michael -
31 May 2006 12:56 PM - 3 messages
Hello together, is it possible to install different service of luggage (3 and 4) on a SQL server? On the SQL servers are 6 instances furnished. For a SQL server instance is furnished, here a Replikation is to service the luggage 4 to be installed. ...
How to sync users and logins in SQL2005 after restore
Gé Brander -
31 May 2006 12:43 PM - 4 messages
Does anyone have a script that synchronizes the users and logins in a database after a restore for SQL 2005? I used one for SQL 2000, but the domain groups are not synced, and the SQL users are. So if any one knows how to do this, please post the answer! ...
[Full Text Search] automatic document classification
Happy -
31 May 2006 12:40 PM - 3 messages
Hi every body, I want to use Full Text Search of SQL Server 2005 to automatically classify my documents; by classifying I mean to give each document a type considering the words it contains. To give a type to a document, I think that one solution is to store the ...
Connections
Toby -
31 May 2006 12:30 PM - 3 messages
Hello everyone, I am configuring the connection pooling for my web application. We are using Sql Server 2000 as backend. I need to specify initial connection poolsize and maximum connectionpoolsize. My question is how many connections can we make simultaneously to SQL server ...
Cannot start up SQL 2000
Man Utd -
31 May 2006 10:55 AM - 2 messages
I just installed the SQL Server 2000 with custom option: Druing the setup, in the screen of Service Account, I use my Windows machine login (this is the login I use when the pc is started up), ie 'Alan' instead ...
query take a very long time
JEFDEG -
31 May 2006 9:43 AM - 3 messages
Hi, we have 3 sql server 2000 on W2000 running the same databases on 2 of them a query take 2 or 3 seconds to execute. on 1 it take over 3 minutes to execute exactly the same query. we check all the indexes of the databases , they are ok. ...
SQL Server on Windows 2000 Server Standard Edition
delbobos -
31 May 2006 7:07 AM - 2 messages
Can i have both installed SQL server 7.0 and SQL server 2000 on a windows 2000 server standard edition ...
deadlocks not resolved by SQL Server
C.W. -
31 May 2006 6:56 AM - 2 messages
I am under the impression that SQL Server would automatically detect a deadlock and roll back a participating transaction. However, I have had a few cases where automatic resolution did not occur. Instead, I had to go in and manually kill the transaction that is causing a deadlock. ...
Need help on following SQL 2000 Error Code
Leo -
31 May 2006 3:49 AM - 2 messages
i am using SQL 2000 Server SP4. Error Code as follow Operating system error 123: The filename, directory name, or volume label syntax is incorrect.. Error: 17815, Severity: 18, State: 1 No longer waiting for client connections using Net-Library'SSNETLIB' ...
Startup service account
Alan -
31 May 2006 3:10 AM - 7 messages
SQLServer 2000. I created a login in EM. I want to change the Startup service to SQLServer and SQLServer Agent by this account. So I stopped the both services and use this new account in both services by SQLServer Service Manager. ...
|
|||||||||||||||||||||||