|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Can one rename the underlying physical file name of a SQL 2000 database?
Spin -
1 Jul 2006 9:43 PM - 2 messages
Gurus, Can one rename the underlying physical file name of a SQL 2000 database? I.E., bring the database offline, rename the physical file MDF and LDF name, then safely bring the database back online again? ...
SQLExpress To New MDF
Stephen Lynch -
1 Jul 2006 3:30 PM - 3 messages
New to SQL. Is there a way to copy all the tables, views and data to a new mdf. In ms access all I had to do was import them into the new db. I am now three hours into searching the web and I cannot figure it out. ...
Sprocs get created with missing dependencies
Frank Rizzo -
1 Jul 2006 3:26 PM - 11 messages
I remember that back in the day (like in SQL Server 7) it was impossible to create a stored procedure unless all its dependencies were in place (e.g. tables, views, other stored procs, etc...). Now in SQL Server ...
Connecting to another SQL Server Instance
rmcompute -
1 Jul 2006 2:31 PM - 3 messages
I created another instance of SQL Server and am trying to access a table on it from the other server. I set up the code listed below and got the error, Line 1: Incorrect syntax near '\'. I tried removing the '\' and then it ...
Remote server
Raul Romero -
1 Jul 2006 2:07 PM - 4 messages
Good morning ... I need to add a remote server (in another country) to my enterprise manager. I tried to add it like a local server (inside my network) but doesn't work. Please, could anybody provide me the steps to do that. ...
Storing dbcc inputbuffer value
VSS -
1 Jul 2006 8:44 AM - 2 messages
Hi, I want to store DBCC inputbuffer value in a variable and then want to comapare the value. How ca i store the value in a variable or table inside a script? ...
Storing dbcc inputbuffer value
Vikram -
1 Jul 2006 8:39 AM - 3 messages
Hi, I want to store DBCC inputbuffer value in a variable and then want to comapare the value. How ca i store the value in a variable or table inside a script? ...
query to find service account user
Vassago -
30 Jun 2006 8:58 PM - 2 messages
Is there a way to query to find the user that the service account is running under? ...
SQL 2k Table schema compare
mecn -
30 Jun 2006 8:08 PM - 8 messages
Hi, There is any way that I could compare tables' schema between 2 databases(prod and develop). or any free tools? Thanks ...
copy database structure only
Neil -
30 Jun 2006 7:53 PM - 3 messages
Is there a way to copy a database without all the data? I want to end up with the same database but "empty". Thanks ...
How To: Get only one record from Joined table
Michael -
30 Jun 2006 5:56 PM - 8 messages
Hi Everyone, I have a query that needs to pull data out of 3 tables. Nothing to hard so far. Here the query: SELECT Patients.PatientId, TERMINATION.DOA, TERMINATION.DOT, PATIENTS.PatientID, PATIENTS.LastName, PATIENTS.FirstName, PATIENTS.COUNSELOR, PATIENTS.MEDICAID_ID, PATIENTS.DOB, COUNSELORS.C_LastName ...
64 bit linked server
billd101 -
30 Jun 2006 5:45 PM - 6 messages
I am trying to set up a linked server on a 64 bit Itanium SQL Server 2000 server to access a 32 bit SQL Server 2000 server. When I run a query in query analyzer accessing the linked server I get the error: ...
Log File Shrink
BigSam -
30 Jun 2006 5:28 PM - 5 messages
I'm unable to shrink my log file. The databse is about 2 GB & the log file has grown to 11.5 GB. I've run transaction backups every 3 hours, but the log won't shrink. I need to reduce the size, to free up space on the drive. I've ...
Syntax error
deltacarlos -
30 Jun 2006 5:03 PM - 2 messages
Hello, While trying to backup SQL2000 DB thru VBS, I'm getting the followin error: -"incorrect syntax near '2' ". The DB name is sql2kdb, however, script works fine if the DB name has no numeric digit. Any help will be greatly appreciated. ...
table to wide?
Sean -
30 Jun 2006 4:38 PM - 5 messages
what we got 31 columns most varchar(50) some even varchar(max). Data in those large columns are not huge however the datatype of max is desired for text search possibilities. 2 columns as the primary key 95,000 records total. ...
Where is my OSQL used?
ChrisR -
30 Jun 2006 4:23 PM - 4 messages
SQL2K SP4 Howdy all. I'm using OSQL through a .bat to run a bunch of Insert/ Update/ and Delete (IUD file) commands. I call the .bat from a Stored Proc (SP) on the Destination SQL Server. Here's the configuration: ...
Tlog file
Russ -
30 Jun 2006 4:05 PM - 7 messages
Quick question. DB in Full recovery mode. Last full database backup was at 1am, last TLog backup was at 2am. At 3.30am Drive containing .mdf fails, drive containing .ldf is OK. If I restore the 1am Full backup and the Tlog backup from 2am, is the .ldf ...
Why Do I Need To Update Statistics Every Day On SQL 2000
MikeR -
30 Jun 2006 2:42 PM - 2 messages
I have a simple database with two tables. Table "A" contains approximately 1.75 million records, increasing approximately 150K records per day. Table "B" contains approximately 260K records, increasing approximately 5K per day. I don't believe these numbers are ...
Access is Denied writing bak file to another disk
FRR -
30 Jun 2006 2:31 PM - 6 messages
We have been writing a nightly bak file to our backup server without a problem. We are now getting Error = 5 Access is denied. BACKUP DATABASE [ABCDE] TO DISK = N'F:\LNCENTER\C$\AURIOBAK Backup files\MP100BACK.BAK' WITH NOINIT , NOUNLOAD , NAME = N'MP100', SKIP , ...
Question about locks
Sean -
30 Jun 2006 2:19 PM - 2 messages
In short, we are sending several statements to the database from one source (my application). When this application is running nobody else will be accessing the database. If I do a table lock isn’t it still releasing that lock after each statement? ...
Assign permissions to multiple objects
rsbaier -
30 Jun 2006 1:37 PM - 2 messages
I know I should know the answer to this question, but unfortunately I do not. We have a SQL Server 7.0 production database (will be upgraded soon). I am attempting to restore this database in my development environment which is running SQL Server 2005 developer edition. The restore ...
kill inactive connections
Juliano.net -
30 Jun 2006 12:44 PM - 6 messages
My company has a software designed in Visual Studio 6 using DAO and ODBC, this software is opening too much connections to SQL Server and maintaining them openned during too much time. So, how can I kill the inactive connections using T-SQL? ...
retrieving user's permissions for each table
maxzsim via SQLMonster.com -
30 Jun 2006 11:11 AM - 4 messages
Hi , Is it possible to get the user's permissions to each table i.e user can select , delete , insert , update , execute , DRI what does DRI means and what is it used for ? and also it it possible to get the permissions up till the column-level ? ...
sql query problems with ASP
davidjohnlong -
30 Jun 2006 11:10 AM - 2 messages
I'm trying to run this query with an ASP script SET DATEFORMAT dmy declare @d datetime set @d = '30/06/2006' select * from orders where @d between start_date and end_date although get the following error. Operation is not allowed when the object is closed. ...
Shortest path to deploy an SQL Express solution
Earl -
30 Jun 2006 9:45 AM - 2 messages
I've been using SQL2k for awhile now and have a VS2005 project I want to deploy with SQL Express. Anyone have a link to the shortest, easiest method of deploying everything needed? ...
Service Manager equivalent for SQL Server 2005 Express?
pedestrian via SQLMonster.com -
30 Jun 2006 9:17 AM - 4 messages
I installed the SQL Server 2005 Express edition in my XP system. Is there a tool like Service Manager in SQL Server 2K that enable the manual control of starting and stopping the Express Server? ...
Unable to connect clustered SQl Server Instance through ENterprise Manager.
csajid -
30 Jun 2006 9:10 AM - 10 messages
Hi, I have Clustered SQL Serevr instance named BOLLEANSQL. when i try to connect it through EM it shows me an error. " Connection couldnot be established to BOOLEANSQL. Reason: Timeout Expired Please verify SQL Server is running and check your SQL Server ...
SQL shared resources failing status check
Simon -
30 Jun 2006 8:37 AM - 4 messages
Hello all, Running windows 2003, SQL 2000 on a 2-node cluster. Every 3 days or so we get the following error: ClusSvc 1055 Cluster File Share 'xxxx' has failed a status check. The error code is 1450. All share resources fail and we have to fail over to the other node ...
Looking for step by step guide/white paper to install MS SQL Clust
dondiego -
30 Jun 2006 7:46 AM - 5 messages
Hello, I need to install a MS SQL 2000 Cluster server which will include 2 nodes (setup as standard). Where can I find a step by step documentation about that and hardware/software requirements? Thanks, Don Diego ...
re-index
00KobeBrian -
30 Jun 2006 3:31 AM - 5 messages
How do you re-index in SQL 2000? Thanks. ...
SQL 2005 Question
ashvsaod -
30 Jun 2006 1:44 AM - 7 messages
Hi Folks.. We have a transaction based system on our main SQL Server. Currently we are finding that this server is having resource issues due to the reporting system also accessing this main server. We want to implement a second server that the reports will execute off. It ...
ActiveX from SQL?
Dean J Garrett -
29 Jun 2006 11:11 PM - 3 messages
Hello, I'm trying to use ActiveX from SQL to save an Excel file. I use the following code: Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Open("C:\Report.xls") ' make some changes here to the file ... xlWb.Save ...
2005 Certification Exams
Richard -
29 Jun 2006 10:26 PM - 2 messages
I'm a little uncertain of which SQL Server 2005 exams provide which certifications. I think this is the complete list of database related exams. 70-431 Implementation and Maintenance 70-441 Designing Database Solutions 70-443 Designing a Database Server Infrastructure ...
big update problem!
Sean -
29 Jun 2006 9:28 PM - 7 messages
I have a mini .net application that I have created to make some pretty complex transformationsdatabase. All the code, .net datatables and logic etc takes 3 minutes to run on the entire database. However, when I put in the update statements the same ...
SQL 2000 Device Activation Error
Goowa -
29 Jun 2006 9:16 PM - 2 messages
Hi all, I am running a DTS script on a SQL server installed in 2003 Enterprise edition environment. When I run the DTS package, I get this error: Step 'DTSStep_DTSExecuteSQLTask_4' failed Step Error Source: Microsoft OLE DB Provider for SQL Server ...
Performance Problems Restoring SQL 7 Win2000 DB To SQL 2000 Win2003 x64
Alexander J. Oss -
29 Jun 2006 8:37 PM - 4 messages
I have a new Windows 2003 64-bit server on which I'm running a 32-bit SQL Server 2000. I backed up the database on the old (Windows 2000 SQL Server 7) server, copied the backup file across the network, and restored it on the ...
ADSI Query works on SQL2000 gets error on SQL2005
Kyle Jedrusiak -
29 Jun 2006 8:25 PM - 5 messages
SELECT * FROM OPENQUERY(ADSI, 'select * from ''LDAP://DC=PI, DC=GLOBAL''') Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "select * from 'LDAP://DC=PI, DC=GLOBAL'" for execution against OLE DB provider "ADsDSOObject" for linked ...
SQL2K SP4 installation issue
John Smith -
29 Jun 2006 7:59 PM - 3 messages
Hi, Hopefully someone can point me in the right direction on this one. I'm running a Windows 2KSP4 server with SQL 2K. My problem is when I try to install SQL SP4 on this server I get the following error ...
SQL2k index
mecn -
29 Jun 2006 4:37 PM - 3 messages
Hi, I have a database. 200GB. I need to do reindex. --- there is any way that I could estimate the time that it need to complete the reindex? Thanks ...
Response issue - non-DBA seeking a possible explanation
Joe -
29 Jun 2006 4:22 PM - 3 messages
My company has no DBA, and we are running PeopleSoft on Windows Server and SQL Server 2000. I have worked with the PeopleSoft Customer Support and have not found a PeolleSoft answer for this issue. I am posting here to see if by ...
Stored Procedure accepts an array of strings?
Ryan -
29 Jun 2006 4:05 PM - 7 messages
I want to write a stored procedure that accepts any number of strings and returns a table that contains any record that contains any of those strings (in a certain field). How would I do this? For example, if the Procedure was passed "KS", "NY" it would return all ...
Restore DataBase to another server
bdickert -
29 Jun 2006 3:35 PM - 4 messages
Recently we lost our DBA. When trying to restore a database from one physical server to another, the master will get updated, correct? We are doing a restore audit on our databases / SQL 2000 SP3. The plan was to restore from tape to a server which worked BData_Bat.BAK was ...
Importing lots of rows :-)
Simon Harvey -
29 Jun 2006 2:50 PM - 5 messages
Hi All, I'm not sure how to approach this problem so if anyone could advise me how to do it I would be very grateful. I have an app that calls a web service. The webservice returns an array ...
RESTORE with RECOVERY and REPLACE?
mike -
29 Jun 2006 2:48 PM - 6 messages
Thanks to those who responded earlier. If someone would check my commands below, I would appreciate it. Again, what I tried to do is create a new database from an existing template database. To do this, I tried (in Enterprise Manager) to restore from the ...
Unable to launch Activity Monitor (2005 -> 2000)
Chris -
29 Jun 2006 2:28 PM - 2 messages
I tried to use the Activity Monitor in my SQL Server 2005 Managment Studio client to see if I could monitor activity on a SQL Server 2000 instance. I received the following error message: TITLE: Microsoft SQL Server Management Studio ...
domain password policy on 2005
james -
29 Jun 2006 2:01 PM - 2 messages
Hi! How do we enforce Sql authenticated logins, the domain password policy? It looks like by default (once you check the enforce policy box during new login creation) it uses password policy of local machine, not the domain policy. My server is in the domain and its running Windows 2003 sp1 and has ...
Please help - Transaction Log not shrinking!
sqlQuest -
29 Jun 2006 1:55 PM - 3 messages
Hi, My production DB transaction log has grown to 25 GBs. (It was <8 Gbs yesterday). DBCC Reindex was issued against all tables as part of monthly DB maintenance. Since then I have performed a full DB backup, ...
MSSQLSERVER service terminated unexpectedly
Martin Paterson -
29 Jun 2006 1:49 PM - 8 messages
I have a couple of sites that are running MS SQL 2000 Service pack 4 that are stopping (apperantly randomly) and restarting itself. This is causing great havoc on some of my applications that are attached to this database. The ...
How to log disconnects?
Will -
29 Jun 2006 1:33 PM - 4 messages
I need to log user disconnects for a specific DB. I do not know how to do this relabily. The application owner is under the impression that our SQL cluster is disconnecting their users. Which I am fairly ...
sql 2005 server can't start - wrong pipe name
radek -
29 Jun 2006 12:47 PM - 11 messages
I change pipe name in Configuration Manager and restart serwer. But mew = = name is wrong, and server can't start. I try go back to old values, but if i try start server, its faild and = parameters are restored to wrong wersion. ...
Question: database integrity problem
Wolfgang from Wolfsburg -
29 Jun 2006 12:41 PM - 5 messages
Hi! I've got a problem with several databases on my SQL 2000 Ent. Cluster. The integrity of the DB structure seems to be breaking away. A user called me because he was missing some data he just inserted into the ...
exposing Distributed Transaction Coordinator to net ? how + security
scott -
29 Jun 2006 11:47 AM - 4 messages
Hi, I have an application on my LAN that connects to a SQL web server. The web server allow limited IP to connect to it to run stored procedures. I have recently found out i may also need to expose the Distributed Transaction ...
Maintenance Plan tips
Fredrik Danielsson -
29 Jun 2006 11:43 AM - 9 messages
Hi! I'm trying to set up a new Maintenance Plan for a new MS SQL Server 2005. And would like some input on my backup plan. Background The server is a database development server where databases are added and ...
How to avoid Informational Messages
kuidokylm via SQLMonster.com -
29 Jun 2006 11:16 AM - 2 messages
Is there some database option in SQL2005 how to suppress Informational Messages ? I don't want that SQL SERVER 2005 sends informational messages ...
Why Sql server speed slows down?
Erus -
29 Jun 2006 10:40 AM - 3 messages
We are using 26 databases in our Sql server 2000 on a fast machine. When we try to access our sql server from intranet with Enterprise manager its so slow on opening databases list or getting list of tables etc. How can we speed this up? ...
Login mapping to DB user name?
MartyKatz2 -
29 Jun 2006 4:01 AM - 5 messages
Hi all... I'm having what I am pretty sure is a bit of a problem with SQL Server 2000. Using Enterprise Manager, I have mapped the dbadmin login to the dbadmin user in one of my databases. When I log in with that account ...
Error when checking if column exists before running query.
focus.nz -
29 Jun 2006 2:17 AM - 3 messages
I am getting this error when the below query is run "Invalid column name 'CellPhone'" if exists (select * from information_schema.columns where table_name ='Customers' AND COLUMN_NAME = 'CellPhone') UPDATE Customers SET PhoneNumber = CellPhone GO The Customers table exists but the column CellPhone doesn't. ...
How do I rename the name of the SQL Server 2000 Server?
mschultz -
29 Jun 2006 1:09 AM - 3 messages
My system administrator installed SQL Server 2000 and named the server SERVERNAME/PARTNER. Can I change the name that the server publishes to the network to be simply SERVERNAME? ...
64-bit SQL Server 2005 Cluster: slow remote desktop
InvalidLastName -
29 Jun 2006 12:10 AM - 4 messages
Hi, We are moving from SQL Server 2000 to SQL Server 2005. Wondering if you have the same problem or can share some of your experience to solve some issue. We have brand new clustered database servers which have Quad Duo CPUs ...
DB Stuck on (Loading) After Restore
mike -
28 Jun 2006 10:17 PM - 4 messages
We are using MS SQL Server 2000. I am not a proficient SQL user. I have created many databases based on a set of instructions from a former consultant. This involves doing a restore from a SQL backup (to disk) of an ...
Making the Log file small
Tina -
28 Jun 2006 9:33 PM - 4 messages
I'm using ss2005 and Management Studio... I have this huge log file and I want it to be small. I read that if I do a transaction backup that it will make it small. That did give it 90% free ...
question on how to form a query
shismith123 -
28 Jun 2006 9:29 PM - 2 messages
I have a question on a query I hope it is not a dim question. Table structure Table name: Subscriptioncustomer Fields: CustomerId - int , SubID - int, TypeId - smallint, date - datetime, userid - varchar Table Name: Customer Fields: CustomerID - int, LastName- varchar. FirstName - varchar, ...
Reporting Services $$$
Eleanor, MCSE/MCT -
28 Jun 2006 9:25 PM - 9 messages
Is there a cost associated with SQL 2000 Reporting Services, i.e., does one have to purchase it or does it come as a tool with SQL? Thanks! Eleanor ...
How come this dont work?
Deasun -
28 Jun 2006 7:52 PM - 4 messages
Ok I am new to this command, BULK INSERT, I cant seem to get this to work or error out for me. Heres what I have; BULK INSERT TBL_Master_DoNotCallList_Loader FROM 'E:\DE_210652006.txt' WITH ( FIELDTERMINATOR = '~' ) I am running this thru QA logged in as the Admin. ...
Sql Express 2005 administration question
pdx -
28 Jun 2006 7:29 PM - 3 messages
I have some remote employees who will be running SQL 2005 Express Edition on their local machines in order to house their version of a db replicated from a SQL 2005 db at the main office. Since the remote users will be db_owner of the db on the server and ...
help store procedure timeout
SergioT -
28 Jun 2006 6:49 PM - 2 messages
hi I have one store procedure (SP) on a Sqlservr2000 under win2003 that SP takes 7 minutes to run but if I get the query and tput it to the queryanalizer it takes 16 seconds!!! I don´t understand why, two days ago ...
SQL 2000 deadlock problem
goldberg.ari@gmail.com -
28 Jun 2006 6:45 PM - 2 messages
Hi, I am having a lot of problem with deadlocks. I am trying to retrieve a list of tasks from a table called tasks. Within this tasks table i have various joins to other tables. Heres the code i was originally using: ...
Newbie Questions
DataPro -
28 Jun 2006 6:18 PM - 4 messages
I'm new to SQL Server, from DB2 and IMS and have a few questions. In SQL Server, with the query analyzer apparently being a part of the Enterprise Manager, how do you give a developer access to the QA ...
request advice on judging memory usage/allocation
tlyczko -
28 Jun 2006 6:18 PM - 3 messages
Hello, I'm relatively new to SQL Server, and have 'inherited' a SQL Server box with the following specs: Windows 2003 SP1, SQL Server 2000 SP 3 (or 3a?), single-processor license 2.8 GHz Xeon, 2 GB RAM, about 2 years old ...
Upgrading SQL 2000 RTM version to service pack 4 - is SP4 cumulati
MattMJF -
28 Jun 2006 5:52 PM - 3 messages
Hello SQL experts, Question: we have a shared SQL server running SQL 2000 RTM on W2K3 SP1 server. The SQL server was never updated to SP1 or SP2 or SP3. We want to update the SQL 2000 server to service pack 4. Can we just install service ...
How to reduce tempdb use?
paulgyro -
28 Jun 2006 5:14 PM - 7 messages
I'm wondering if there are any general guidelines on how one can go about reducing SQL Server's use to the tempdb? Add RAM to the server? Index columns? I'm not sure how to go about reducing the tempdb use on DB as I think it is being used too often. ...
DTC Problem - Unable to begin a transaction
Arghknork -
28 Jun 2006 5:04 PM - 3 messages
I have a strange one. I have 2 Win2K3 servers, one running SQL 2K5 and the other 2K SP4. From the 2K5 SQL Server I issue the following query ... declare @tmpStr varchar(2000); declare @ib table (EventType nvarchar(30), Parameters int, EventInfo ...
Deadlock in single session
ameen.abdullah -
28 Jun 2006 4:45 PM - 3 messages
Hi guys, I need to stimulate a deadlock senerio in sql server.. i know i can do it by openning two sessions of query analyzer.. is there any way of creating a deadlock with a sigle session.. thanks to all in advance.. ...
Simple duplicate record query query
turnerpaul@gmail.com -
28 Jun 2006 4:25 PM - 4 messages
Hello all - I am new to SQL server so please forgive my blatent ignorance. I've got a table with 2 columns, col1 and col2. In col2 I suspect there are some duplicate entries and I would like an SQL query to find ...
identity column problem skipped a range of values
jj -
28 Jun 2006 4:17 PM - 2 messages
Hi, This is on SQL Server 2000 database. Inserts to a table with an identity column on it have suddenly jumped in value. It was going along, 301, 302, ... then all of sudden identity column values jumped to 64221, 64222.... ...
Developer 2005 Connection Limit
Jim Norton -
28 Jun 2006 4:15 PM - 6 messages
I have looked online but cannot find a clear answer to whether Microsoft SQL Server 2005 Developer Edition has a maximum connection limit? I see that SQL Express has 25 maximum connections. If anyone knows that answer it would be greatly appreciated. ...
Question Regarding Views and Indexes
GCeaser -
28 Jun 2006 4:14 PM - 3 messages
If I have a table defined as follows: TABLE Customer_Info Customer_ID Int NOT NULL, Country nvarchar(225) NOT NULL, State_Province nvarchar(225) NULL, Customer_Name nvarchar(225) NULL The tables primary key and unique index is on Customer_ID ...
Frustrating: Can't get to Provider Options in SQL 2005 Express??
Mike -
28 Jun 2006 4:01 PM - 7 messages
Hi, I'm trying to get to the provider options screen in SQL2K5 Management Studio, however I am unable to find it anywhere. This is really frustrating... Here is what I am trying to do: 1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go ...
sql 2k Database blocked
mecn -
28 Jun 2006 3:44 PM - 4 messages
Hi, We have prod db is always blocked by the same SPID. The auto notify system keep sending me email that says SPID 123 is blocked by SPID 123. Self-lock--- should I ignore the notification? Thanks ...
Strange blocks appearing in database diagram.
Mike Andrews -
28 Jun 2006 3:40 PM - 2 messages
Guys, I'm befuddled here. I'm trying to print a sql server 2005 diagram and I get strange blocks covering the tables. This only occurs when printing. The tables look fine on the diagram. I can send a sample if anyone is interested. ...
GETDATE in a function
Maury Markowitz -
28 Jun 2006 2:09 PM - 10 messages
I'm trying to make three functions, Today, Yesterday and Tomorrow. But I can't, because you can't put GETDATE in a function. 1) Why not? 2) What can I do to make this work? Maury ...
Optimizing a query
jeeji -
28 Jun 2006 1:17 PM - 5 messages
Hi I have a query which I would like to optimize and thought I had found a solution. The query is a join of several selects from several different tables. So we have in general the following: SELECT Col1 FROM ...
Truncate Log File
Vensia -
28 Jun 2006 12:05 PM - 9 messages
Dear all, How to truncate log file in SQLServer 2000 ? Thanks. Vensia ...
ODBC 3146
Sql_NeedHelp -
28 Jun 2006 10:43 AM - 2 messages
Excuse me for my poor english I have MS access Database linked with SQL SERVER 7. Only 2 pc not execute a big Query.This query is composed of lot subquery. i have ODBC ERROR 37000. and this message "Alias and column (MS3) is ...
Connection errors
Griff -
28 Jun 2006 10:11 AM - 7 messages
Hi - I originally posted this to windows.server.general, but no responses there. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I have database application that stops working and the event log shows two errors - I suspect that they are related but I don't know for certain and ...
LINK SERVER BAD PERFORMANTCE
Chedva -
28 Jun 2006 9:24 AM - 2 messages
A SP with join's between tables of 2 SQL 2000 linked server used to work relatively quick. Since a few weeks the same SP that runs on +/- the same amount of data takes much more time (43 sec). ...
Spesial_charachers_(=E6,=F8,=E5)_bulk_insert
Jorgen -
28 Jun 2006 9:08 AM - 3 messages
Hey I'm from Norway and I have a Unicode file with the characters æ, ø og å. (I can store the file in any formating I want, so if you see that I have another option with another filetype I would appreciated you ...
Retrieve length of image or BLOB
jehle -
28 Jun 2006 8:55 AM - 2 messages
I use the data type image to store BLOB's on the database. Now I would like to Query the length of the BLOB with T-SQL to calculate the used disk-space for this item. Has some one a good idea? ...
Job History hangs Enterprise Manager
Bri -
28 Jun 2006 6:45 AM - 3 messages
Hi I have Enterprise Manager on my local machine and administer a server from it. When I go to jobs and right click and choose view job history I get an hour glass and then EM Hangs and also pretty much kills my machine. ...
mssql2k: rebuilding vs reorganizing indexes?
planetthoughtful -
28 Jun 2006 6:22 AM - 11 messages
Hi All, Just wondering if anyone can give me some general advice on the practical differences between rebuilding and reorganizing indexes in sql server 2000? Basically, we have a database that occupies approx 28gb, of which approximately 4gb is indexes. In the 2 or so years that our app has ...
Transaction Log Backup Verfication failure
Shri.DBA -
28 Jun 2006 5:37 AM - 4 messages
Hi, In one of our SQL Server the transactin log backup verification has failed with error message "Msg 50004, Sev 19: user exception VERIFY DATABASE is terminating abnormally". I searched microsoft support site, but I couldn't find any article related ...
Can I change the SQL 2000 Cluster database from case-sensitive to case-insensitive in the production
M C -
28 Jun 2006 3:56 AM - 4 messages
Hi All, I'd like to know if I can change the SQL 2000 Cluster database configuration from case-sensitive to case-insensitive in the running box. If yes, how can I do that? TIA ...
Error creating login - Incorrect syntax near 'LOGIN'.
eshhyasi -
28 Jun 2006 3:33 AM - 5 messages
Hi, I am using Sql server 2005 and when I try to create a new login from the sql server mgmnt studio, I get this error. Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'LOGIN'. ...
Remote database Connection Error!
Sujata P -
28 Jun 2006 3:18 AM - 3 messages
Hi, My Application which is written in VB.Net uses database connection to my Local Instance of SQL Server Express version. My connection string is " Data Source=SM5\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MgmtSystem.mdf;Initial Catalog=MgmtSystem;Persist ...
2005 local server name help
Mike -
28 Jun 2006 2:24 AM - 4 messages
I have installed SQL Server 2005 and by mistake replace local server name with linked server. Ran sp_dropserver 'Localservername' and sp_addserver 'localservername'. After that I installed replication on same server and enable it as distributor and subscriber. It worked fime till server reboot :) ...
Databases can only be backed up locally?
kevinling1 -
28 Jun 2006 1:59 AM - 2 messages
Dear all, I have two windows 2003 servers, one is running arcserve 11.1 with sp2,
the other is running MSSQL 2000 with SP4 with SAP application. I have already installed the client agnet and sql agnet 11.1 sp2 to the
SQL ...
Can I install more then one copy of MSDE on a server?
Clayton -
27 Jun 2006 9:43 PM - 8 messages
We are running a Windows 2003 domain. I have a Windows 2003 member server running an app. and MSDE. I now have another app. that I would like to install on this same server. The new app. also needs MSDE. My question is can I install and run more ...
Sql Server Service Pack 4 upgrade
Kelly Beauchaine -
27 Jun 2006 9:16 PM - 3 messages
Generally speaking, has anyone had any problems after installing SP4 to Sql Server 2000? I am hesitant to install only because the instructions tell me in order to back off the service pack I have to completely uninstall Sql ...
Physical database file names --- programatically.
Lowry Smith -
27 Jun 2006 9:15 PM - 5 messages
How to get the list of physical file names for each databases in a given SQL server installation programmatically? SQL Server 2K. Thank you, Smith ...
killing a process shows 0% completion time
clemlau -
27 Jun 2006 9:15 PM - 13 messages
Hello, I'm running Sql server 2005 and I've noticed that when I kill a process, it always shows "Estimated rollback completion: 0%. Estimated time remaining: 0 seconds." Even though the process does kill successfully, these numbers never ...
|
|||||||||||||||||||||||