|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Operations Spec Document
Hassan -
20 May 2006 6:35 PM - 4 messages
I am looking for some of the obvious questions one needs to ask from the devs,etc. to help Operations be ready to be in a position to understand some of the new requirements coming in and be prepared from a datbase ...
Revert dropped Table. Have nay way? How?
retf -
20 May 2006 3:45 PM - 3 messages
Hi all, Revert dropped Table. Have nay way? How? Thanks, thanks.... ...
Management Studio
JIM.H. -
20 May 2006 3:44 PM - 2 messages
Hello, I installed Sql Server 2005 developer edition on a Windows 2000 Pro machine I di0 not see Management Studio in the menu? Any idea? ...
how to: Change port
retf -
20 May 2006 3:32 PM - 4 messages
Hi all, I did see that I have 72.000 attempt to invade my SQL by default port, i would like how change sql default port, and what more I can do to eliminate this. Have way to I specific the IP that I want alow connection. ...
adding query results to email body using CDOSYSmail
Steve -
20 May 2006 2:08 PM - 4 messages
Thanks in advance - Steve. I'm running SQL 7.0 with Exchange 2003 SP2 (SP.?) which uses SSL to preclude using SQL Mail (as far as I know). So I've been working on using CDOSYSmail to send email, and attachment, and the results from a stored procedure (a ...
KB913580 & SQL Server 2000 Problem
Don Miller -
20 May 2006 2:02 PM - 7 messages
I applied the Microsoft patch MS06-018 (KB913580) Vulnerability in Microsoft Distributed Transaction Coordinator Could Allow Denial of Service on the 13th (4 days after it was issued) to my dedicated server (at a hosting site) running SQL2K SP4. Since then, on two occasions, I needed to reboot my ...
rowcount help
D.B. -
20 May 2006 12:42 PM - 5 messages
i'm trying to get total rows found by query that uses top clause... for example: select top 10 myTable.* from myTable where myTable.number > 200 let's say there are 13 rows matching that condition, and by using ...
HW Requirement for SQL Server 2005
perhiyar -
20 May 2006 7:09 AM - 2 messages
We are running four servers at different sites say A,B,C and D and want it to connect main Server at head office what would be the configuration of main server for running SQL Server 2005.There are two ...
SQL 6.5 Error Log
Ivan -
20 May 2006 3:10 AM - 6 messages
Dear all, One of our client is using Windows 2000 Server + SP4 + SQL 6.5 + SP5a. Recently, they found the sql server suddenly hold and all connections seems waiting. In the SQL error log, we found the following error: 2006/05/19 10:43:40.26 spid-1 Error : 3307, Severity: 21, State: 1 ...
How know when one Table was droped? HELP-ME
retf -
19 May 2006 11:53 PM - 3 messages
Hi all, I have one Data Base, Today one strange thing occur, one table of my data base disappear , I didnt drop it, then i would like know if have way to determine when this occur; The last week same thing occur whit one store procedure. ...
AARGH! Syscacheobjects showing my cache keeps clearing out!
Tim Greenwood -
19 May 2006 10:50 PM - 15 messages
What could cause this? Normally it looks quite good but just this afternoon I've watched it completely clear and everything start over like 3 times now!! I can't seem to figure out what is causing it....I've never seen this ...
xp_cmdshell Copy Access is denied
Joe K. -
19 May 2006 10:27 PM - 3 messages
I am able to copy the file with Windows Explorer without a problem. When I use the xp_cmdshell copy command I received Access is denied error. I would like to use the xp_cmdshell to copy the file, I will need to ...
SQL2005 Database mirror (SP1)
Howard -
19 May 2006 10:13 PM - 2 messages
I am following the database mirroring example in BOL and am running into a problem on the principal db setting the partner. ALTER DATABASE mirrored_db SET PARTNER = 'TCP://PARTNERHOST5.Mydomain.CORP.MYCOMPANY.COM:5022' GO For 'PARTNERHOST5.Mydomain.CORP.MYCOMPANY.COM' I am using the network name ...
How know when one Table was droped? HELP-ME
retf -
19 May 2006 10:11 PM - 5 messages
Hi all, I have one Data Base, Today one strange thing occur, one table of my data base disappear , I didnt drop it, then i would like know if have way to determine when this occur; The last week same thing occur whit one store procedure. ...
can't set backup retention
renhai -
19 May 2006 9:58 PM - 3 messages
We have a SQL 2000 MSDE when I use maintenance plan to set up backups, Remove files older than window, when I click on the screw down lit for the options (minutes, hours, days, weeks, months), there is nothing to ...
Performance Problems - HELP, PLEASE
msnews.microsoft.com -
19 May 2006 9:20 PM - 4 messages
One of my SQL2000 sp3 servers has seems to be responding slower. Server is Win2000 SP4 running on IBM eServer xSeries 360, dual processors. There are 58 DBs on the E Drive, and 2 DBs on the C drive, 1 of those ...
Want 2005 training but only will get 2000 - what should I focus on?
Gummy -
19 May 2006 8:58 PM - 5 messages
Hello, I have a background in Access VBA and .NET programming. I have been playing with my personal copy of SQL Server 2005 and have been thrilled with all the features, but there is so much to learn. They are starting to implement 2005 around my office, but leadership will ...
DTRUN command
ITDUDE27 -
19 May 2006 8:33 PM - 3 messages
Hi. I have a sql job that is failing, while looking why the job failed, In the preperty Step- tab /command windows: has DTSRun /~ this long address following . I just started this gig and I'm not sure what is being called. how can I ...
Creating multiple temporary databases.
Art Decker -
19 May 2006 7:54 PM - 2 messages
Hello, I noticed that when we installed SQL 2000 Reporting services that two databases are created one being ReportServerTempDB. This got me to thinking about Oracle databases where I can create multiple temporary 'tablespaces' and then I can assign specific users to specific tablespaces. ...
What is this error?
Retf -
19 May 2006 7:39 PM - 3 messages
What is this error? TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'VEGAS-W-DV-01'. (Microsoft.SqlServer.Smo) For help, click: [link] ...
Not associated with a trusted SQL Server connection
bmkiss -
19 May 2006 6:47 PM - 2 messages
Hello everyone, I have just recently encountered this problem. We have a server running Windows 2K server with SQL server 2K. There are three of us that connect to that machine for development. Authentication is set to Windows only. We ...
SQL Backup Plan
Dave -
19 May 2006 6:34 PM - 4 messages
We have a SQL database which used by an Imaging (Scanning) application. The database itself is not that large about 600MB. The scanned files are stored on the server and that directory and its subdirectories are about 108 GB. Up ...
objects
Victor Rodriguez -
19 May 2006 6:30 PM - 3 messages
How can I get a list of all view, procedures, tables that has been change/edit in the last month? Thanks, Victor ...
Worktables created/sec
Shiva -
19 May 2006 6:17 PM - 4 messages
Hi, I am averaging 18 worktables created/sec. Is this is a very high number? Does worktables mean tables created in memory or tables in the tempDB? I know that in SQL Server 2000, inserted and deleted tables were stored in the ...
Missing xp_sqlagent_notify
SteveIrwin -
19 May 2006 6:04 PM - 3 messages
I'm trying to have an alert fire when it receives an error via the RAISERROR call. I have it working in SQL 2000, but can't get it to work for SQL 2005. When I look at the history of the alert, it says that it has not been raised ...
SQL 2000 SP4 System Log Files?
David -
19 May 2006 5:04 PM - 6 messages
I’m setting up a new SQL 2000 SP4 server. Operating system is Win2003 Server Std. SP1. With this new server I plan to migrate next month 2 user databases. When I purchased this new server I planned to do it right this time. ...
Is this index redundant?
pshroads -
19 May 2006 4:37 PM - 12 messages
Let's say I have a table: create table example ( id int, createtime datetime, name varchar(20)) go create index ix_createtime on example(createtime) go create index ix_createtime_name on example(createtime, name) ...
Very Large Table Defrag?
alex sadykov -
19 May 2006 4:27 PM - 6 messages
Hi all I ran DBCC SHOWCONTIG on 2 tables that have 71 million rows each. Database size is 63 gigs and it only has 2 tables. Here is the result: TABLE level scan performed. - Pages Scanned................................: 74 - Extents Scanned..............................: 23 ...
Which of these is considered the most 'accepted'
Tim Greenwood -
19 May 2006 2:49 PM - 2 messages
I've got a sproc that accesses data in another db. The other db already has a user function that takes the parms and returns what I need. Should I use that user function or copy it to the local db and reference it from here ...
Memory pressure while running Perfmon?
smithabreddy -
19 May 2006 2:48 PM - 2 messages
I ran a perfmon trace with Memory counters (part of periodic monitoring effort). I noticed that the SQL Server:Buffer Manager, Free pages counter had dipped to 317, 203, etc (nromal values> 10000). The first time this happened today coincided with the time I started the Perfmon ...
SQL2K Logs
mecn -
19 May 2006 2:02 PM - 6 messages
Hi, I want open the sql server logs -- Too big 315GB. It takes forever to open it. The server has not been rebooted for >6month. Is there a way to open the log? How do i have a clean new log file without ...
SQL Server Express
Ken -
19 May 2006 1:48 PM - 4 messages
I'm developing a database application card caching system that runs on client store sites. I've set the min max memory for the server to 100meg 200meg respectively. However, when I'm loading numerous card balances, I see the memory jump to 360meg. I've also restarted server ...
SQl Server 2000 and 2005
JIM.H. -
19 May 2006 1:09 PM - 3 messages
Hello, Can I install both SQL Server 2000 and SQL Server 2005 in the same machine get them up and running? ...
ANN: 25% discount on Upscene products during our spring sale!
Martijn Tonies -
19 May 2006 12:40 PM - 2 messages
Upscene Productions announces a Spring Sale with 25% discount on all database developer tools! Currently available from Upscene Productions: Database Workbench A multi-database engine development IDE, currently supporting Microsoft SQL Server, Oracle, InterBase, Firebird, MySQL and NexusDB. IB LogManager Suite ...
Recover structure from corrupt .MDF?
James -
19 May 2006 10:56 AM - 3 messages
Hi, I have a corrupt .mdf file and all I want to do is get the stored procedures & table structure out of the file. Is this possible? (I do not have a backup ). cheers James ...
to connect SQL Server2005 Express?
giacomo -
19 May 2006 10:38 AM - 2 messages
Hi at all, I’m trying to access to test.mdf (SQLServer2005 Express edition database) that I have created but I have always the same error… Unable to open the phisical file “C:\…\test.mdfâ€. Operating system error 32: ...
Will log file size affect connection time ?
jcvoon -
19 May 2006 10:13 AM - 8 messages
Hi: I notice that when i try to connect to the database with large log file, it will cause connection time out in my VB6 aplication, and in enterprise manager it take very long time to open the database. Once i ...
Join two views using server aliases
StF -
19 May 2006 10:04 AM - 3 messages
Hello everybody, I'm working for a hospital and for this job, I created two views using the server aliases (linked servers). Both these views are working correctly. The design of the first view is: SELECT TOP 100 PERCENT UNID AS ID, SPECIALTY_CODE AS CODE, ...
restore problem - help
ina -
19 May 2006 9:29 AM - 8 messages
Hello, I have a problem with restoring, so I am doing several test in order to properly to backup my database. So I have first of all, restore all data(from database 1) into a new database (database 2) and and it is ...
Calling Stored Procedure from COM+
aaron -
19 May 2006 9:18 AM - 4 messages
Dear All, We're trying to resolve a rather odd performance issue on one of our servers. We have a COM+ component calling a stored sprocedure in a SQL Server database. The COM+ component is on a different machine, so the call is ...
Replacement for xp_cmdshell in SQL2k
aizaz -
19 May 2006 8:59 AM - 8 messages
ISSUE (in SQL Server 2000): Some Client applications’ stored procedures are using “xp_cmdshellâ€. xp_cmdshell is an extended stored procedure in Master database. This command takes a string of dos commands and executes them in the DOS command shell. ...
Index Error - Re-Post
Julie -
19 May 2006 7:22 AM - 5 messages
Apologies for the re-post... Hello, We are running SQL 2000 Service Pack 3a. We are getting the following error when we perform a load.. Error: 8646, Severity: 21, State: 1 The index entry for row ID was not found in index ID 5, of table 933578364, ...
SQL 2000 to 2005 and new hardware
Kolgrim -
19 May 2006 6:53 AM - 2 messages
Hi, I have a SQL server 2000 standard witch I want to upgrade to 2005 and move to new hardware with the same server name. It is installed on an windows 2003 server. How should I do? ...
Restore database question
ina -
19 May 2006 6:08 AM - 14 messages
Hello, I would like to restore my database what come first, I first restore the transaction log and after the data backup Ina ...
monitor sql backups
Scott -
19 May 2006 5:33 AM - 4 messages
I currently receive a notification if my sql backup fails through sql agent. However, there is always an outside chance that the sql agent is not working either in which case I have no notification if my backups fail. Perhaps one can easily write a command prompt code to monitor the dates on a ...
Design DBs with HA in mind
Hassan -
19 May 2006 4:58 AM - 2 messages
Is there any article,white paper etc that tells me how to design my databases with High Availability in mind.. Im not talking about clustering,log shipping,etc. that can help prevent hardware failures but to minimize downtime by designing the databases such ...
2000 DB in 2005
Darin -
19 May 2006 1:54 AM - 4 messages
My plan this weekend is to detach all of my databases on SQL 2000, load a new HD with SQL 2005 and attach all of those databases. Will I have any problems with that? Darin *** Sent via Developersdex [link] *** ...
xp_cmdshell PSCP in SQL Server 2000 problem
ausgoodman -
19 May 2006 1:40 AM - 3 messages
Hi, In the same machine, I can run the following PSCP command to fetch a file from remote server from a command window: C:\Download\Putty\pscp.exe -p -pw xxxx@xxxx name@serverIP:/export//detail-20060518.csv C:\Temp\Test\detail-20060518.csv ...
Contents of FileGroups
theredmiata -
18 May 2006 10:47 PM - 5 messages
All, Is it possible for a table to exist in more than 1 filegroup? Is it possible to move all existing instances of that table to just 1 filegroup? . Using the script below: SELECT DISTINCT (SELECT groupname FROM sysfilegroups ...
"Planning" a database enviroment - a bit off topic
Kim -
18 May 2006 9:54 PM - 3 messages
Hi Hi I'm about to plan a upgrade to our database enviroment. We have 7 database servers running different kinds of SQL server (7.0, 2000, 2005) in an unmanaged enviroment, The environment services wide range of business applikations and the demand ...
"Name" Data Type?
Dan Costello -
18 May 2006 9:49 PM - 3 messages
Standard apologies for the extreme "newbie" nature of this question... I've just seen a batch of sample code with the following declaration: DECLARE @MyVar Name "@MyVar", in this case, is there to receive some string data from an OPENXML ...
Statistics and Maintenance
Ed Mays -
18 May 2006 9:30 PM - 6 messages
I am trying to determine the best approach to creating and maintaining statistics in a large data warehouse environment on SQL Server 2000. The current environment has auto create statistics on and auto update statistics off. There are scheduled jobs that manually update statistics. Those jobs ...
Could install two Instance in a SQL Server
ad -
18 May 2006 9:16 PM - 2 messages
I have install Sql2005 in my Server, and it use the default instance. Could we install another Instance in the some Sqlserver. For instance, I add Instance2 to the SqlServer? ...
Problems with my database creation script
javier.ignacio.villegas -
18 May 2006 8:02 PM - 8 messages
Hi, I have a strange situation. I must run the same script in SQL 2000 and SQL 2005. Basically the script does it: IF THE SQL SERVER IS SQL 2005, IT CREATES A NEW DATABASE AND USE IT, ...
stored proc took abnormally long time to run last night
Matt Williamson -
18 May 2006 7:13 PM - 2 messages
I have a DTS package that calls a stored proc that took close to 4 hours to run last night. Normally, it takes about an hour. I'm trying to figure out how to troubleshoot why it took so long but I don't have any clue where to ...
sql 2000 MSDB database restore in sql 2005 box
mecn -
18 May 2006 7:11 PM - 3 messages
Hi, I couldn't not restore sql2k msdb dump to a sql 2005 box. I don't want to re-create all sql jobs. What is the best way to solve it? sql 2005 transfer job? Thanks ...
Migrating to a new database server
Blasting Cap -
18 May 2006 6:59 PM - 2 messages
I need to migrate the DTS, the jobs, users and everything from a database on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to another (Windows Server 2003, SQL 2000). The databases that do not already exist on the new server I can restore those from a backup just fine. ...
IA64 bit Performance vs X64 - Update statistics
John L -
18 May 2006 6:33 PM - 8 messages
Prod server is a 4-way IA64 running SQL EE(64-bit), 32 GB RAM. Dev server is 4-way SQL EE x64, 9 GB RAM. At the end of the day (just prior to midnight) I backup the prod database, ...
JDBC connection
Luigi Fonti -
18 May 2006 6:31 PM - 4 messages
In a Windows XP Pro machine (named CLIENT) in installed Sql Server 2005. I created a database (work) and some tables. I can work with them using Visual Studio and C#: no problems. I can access the database with this simple ConnectionString: ...
MSDE in registry ?
Alexander -
18 May 2006 5:39 PM - 2 messages
Hello. I have the question. Now i am writing the tool that clear my instance registry values if install of msde failed. How to determine is any msde instance installed ? Is it enough to know that in HKLM\software\microsoft\microsoft sql server\component set ...
sort question
Paul -
18 May 2006 5:10 PM - 2 messages
Hi just wondering if anyone knows if there is a way in a sort to put all special characters at the end? I am using 1 sort. For example when I sort I get - testone 1 testname abe butch cathy ...
open rowset query using windows authentication
shelleybobelly -
18 May 2006 5:04 PM - 3 messages
Hi I need to do an "open rowset" query from one SQL server to another (because I don't want to set up a linked server). I want to use windows authentication, rather than a SQL logon. My windows account has read to ...
License question
MGeles -
18 May 2006 4:27 PM - 4 messages
Are licenses bound to servernames or IPs? What if I decide to change the hardware or rename a server? Would a new license be required? Thanks ...
Validate a backup structure:
ina -
18 May 2006 4:25 PM - 3 messages
Good Morning guys, I am newbie in SQL server and backup could someone tell me the if my backup plan is good; any suggestion is appreciated Database1 backup -- everyday at 07:36 Database1 Log -- every 4 hours between 08:00 and 22:30 ...
Transfer Object using SSIS
sck10 -
18 May 2006 4:21 PM - 2 messages
Hello, I have SS2K5 Developer on my machine. I am trying to transfer a table (tblCategory) from one database to another database using SSIS: "Transfer SQL Server Object". The destination database does not have the table. Also, I noticed in the error statement: "Cannot find the object ...
T-SQL
MS User -
18 May 2006 3:53 PM - 10 messages
SLQ Server 2000 I have a table 'Route' with schema CREATE TABLE [dbo].[ROUTE] ( Carid integer not null, seq_num integer not null, State char(30), City Char(30) ) Sample Data (This table can have any number of records for a given Carid) ...
Index Error
Julie -
18 May 2006 3:36 PM - 2 messages
Hello, We are running SQL 2000 Service Pack 3a. We are getting the following error when we perform a load.. Error: 8646, Severity: 21, State: 1 The index entry for row ID was not found in index ID 5, of table 933578364, ...
Format number in stored procedure
lemes_m -
18 May 2006 2:28 PM - 6 messages
I have one question about stored procedure. I will write expression which I used and result what I want: Cast(InvNumber as varchar)+'/'+cast(year(InvDate) as varchar) results as 75/2006. I want it to result as 00075/2006. How can I do it? ...
Problem creating a secondary datafile on drive E:\
Dominick D. -
18 May 2006 2:25 PM - 6 messages
Hi. I am a student, taking a class on MS SQL SERVER 2000 system admin and programming. I created a database, tsqldb, on C:\, where the ms sql server files reside. Now, I used the alter database command to add a secondary ...
HELP!! Is this a potential locking nightmare???
Tim Greenwood -
18 May 2006 2:17 PM - 4 messages
The following table is used to store the points earned each month by salesmen. Items purchased by customers on-line all have points assigned to them that are used for this purpose. We used to add to this table as each customers application was ...
Error Msg 547
Chelims -
18 May 2006 2:15 PM - 2 messages
Hi, I'm not an expert in SQL, I just need it to run a Blackberry server. I need to run this follwing command to clear the database : delete from mdsagconfig But it does not work and I receive the following message : ...
Bulk insert
Franck Fouache -
18 May 2006 12:36 PM - 3 messages
Hi, i'm trying to store some bitmap or jpeg files located on my harddrive into a table of my datable which have an image type field. while looking at different help files, it seems to be possible with bulk ...
Different @@version
Darin -
18 May 2006 12:25 PM - 2 messages
I have 2 machines, both that I _thought_ were loaded with the same version, but when I do select @@version on the two I get different results: 1. Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 ...
deadlock between select (shared) and update (intent exclusive)
mhuhn.de -
18 May 2006 11:53 AM - 6 messages
I regularly have deadlocks on my sql-server 2000. Using the 1204 trace I got the following info about the problem: Wait-for graph Node:1 PAG: 7:1:251381 CleanCnt:2 Mode: S Flags: 0x2 ...
Can we do Transaction log backup and log shipping on same server.
csajid -
18 May 2006 11:43 AM - 5 messages
Hi, I know that Log Shipping and Transaction log backup cannot be done on same primary server side by side because i tried it, but i want possible reason for that. Next i want to know is that can we Detach and re Atach Log ...
Error starting SQLserver on windows 2000
olivier.lammens@gmail.com -
18 May 2006 11:14 AM - 2 messages
When starting the SQLserver service on a windows 2000 server, we get following error: 17050 : initerrlog: Could not open error log file 's:\MSSQL8\MSSQL\log\ERRORLOG'. Operating system error = 3(error not found). We're running SQL 2000 std ed.. This is no cluster, access rights on ...
SQL 2000 refuses to go beyond memory
pinkjacket -
18 May 2006 9:41 AM - 2 messages
I have two servers which are almost the same spec. One for production and the other for UAT. However, the UAT server just stopped working fine yesterday and went real slow. 3 secs queries now take upward of 2 minutes. ...
How can i configure SQL Server for clustring servers?
Batur KILIÇ -
18 May 2006 9:23 AM - 3 messages
Hi We are developing bussiness software for tourism company. Our application is using SQL DB on MSSQL Server. We have a new customer and they have 500 or more users.Around 300 users will be work on local network and 200 users will ...
Excel 2003 doesn't work with SQL 2005 AS
Igor A. Chechet -
18 May 2006 9:07 AM - 2 messages
Greetings! We have a connectivity problem between Excel 2003 and SQL Server 2005 AS. We created cubes and it works OK on server. Then we installed Excel 2003 on AS server to check connectivity. It works OK. But on any other workstation with ...
disconnect users
Jason -
18 May 2006 7:16 AM - 2 messages
Hi, I was wondering if there is a stored procedure that could disconnect users. I have job which does some integrity checks, but for one database it always fails. There is always a connection open. That particular useraccount is for the oracle applicationserver which should remain active. ...
Cache Hit Ratio VS Page Life Expectancy
Shiva -
18 May 2006 6:31 AM - 8 messages
Could someone explain this behavior? Server ------- DELL PowerEdge 6850 - x64 bit Windows 2003 Enterprise Edition - x64 SQL Server 2005 Standard Edition When you check for the perfmon counters, I see about 300 as the Page Life Expectancy and about 98% for the Cache Hit Ratio. According to Kalen ...
Move data from one table to another
jp -
18 May 2006 3:48 AM - 3 messages
Trying to copy data from table one (name) to table two (n_system). Field name.co_id to n_system.ultimate_id where name.id = n_system.id. insert n_system (id, ultimate_id) SELECT id, co_id FROM name where name.id = n_system.id Error message ...
New to SQL Server 2005 Express
Dave -
17 May 2006 10:38 PM - 5 messages
Hello, I just installed SQL Server 2005 Express and have no prior SQL experience. As a beginner, what should I expect? Already I am stumped by the apparent lack of a user interface. Where do I get work done, i.e. I'm ...
sql transact sort question
Paul -
17 May 2006 10:13 PM - 3 messages
Hi I have a simple table that looks like name_id name 1 paul epstien 2 sally helms ...
SQL Server Domain Migration
Jerry Spivey -
17 May 2006 8:41 PM - 2 messages
Hi, We're going to be moving all of our North American SQL Server systems into a single global International domain. The domain name will change however the server names will not change, end-user names will not change and group names ...
Inconsistent Query Performance
Steve H -
17 May 2006 8:01 PM - 9 messages
Hello! We are having a problem with one of the queries that an application runs. This query uses some temp tables (subbed as table variables with no performance change) and heavily uses some user defined functions. When run ...
Problem with DBO after restore
Wayne -
17 May 2006 7:53 PM - 4 messages
Hi, I support an application and part of it has an archive function. It takes backups of a main database (using the SQL backup command) and saves them to be restored at a later date to an archive database on the same SQL Server ...
execute sql statements in text file
fullertee via SQLMonster.com -
17 May 2006 7:21 PM - 5 messages
I am new to batch files. I have a text file that has several INSERT/UPDATE sql statements. I would like to create a batch file to execute the sql statements in the text file on my server. I am not having any success with ...
Moving a DB from 1 Server 2 another
Saga -
17 May 2006 7:12 PM - 4 messages
Hi all, I have a databse on an SQL Server 2000 that I need to move to another one. If I can get a network connection between both servers, I can do this easily within Enterprise Manager, but what if I need to physically take the DB ...
Query optimization
cbrichards via SQLMonster.com -
17 May 2006 7:00 PM - 2 messages
I have a view comprised of the following select statement. SELECT x.Key FROM dbo.Table_X AS x INNER JOIN dbo.Table_Z AS z ON z.FKID = x.PVUID AND z.Key = x.Key ...
Some SQL 2005 upgrade questions
sqlboy2000 -
17 May 2006 6:55 PM - 4 messages
Hello all, We're in the early stages of planning our SQL 2005 upgrade from SQL 2000 Enterprise Edition. I'll go into specifics if anyone asks, but I have a few general questions that hopefully some people that have upgraded already can ...
memory hog and spid lock
Mo -
17 May 2006 6:25 PM - 2 messages
Hi, I have a proc that takes about an half an hour to run and when it finishes I noticed that the ISQLW,EXE is using 123,108 K and the SQLSERVR.EXE is using 108,766K. When I looked at the process info, I ...
cant load DB files from SQL2005 Beta2
TechMasters -
17 May 2006 5:55 PM - 5 messages
I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded to the RTM release of SQL Server 2005, however it wont let me load the DB files from databases I created on the Beta version....I am in bad ...
record locking-is this all automatic?
Paul -
17 May 2006 5:25 PM - 3 messages
Hi I am using SQL 2000 and will be working on a database that will have a lot of users. I was wondering there may be a case were I need to lock a record, like when one user will be modifying its' data. I was wondering how to do ...
how to tell which sp am i running on?
joeydj -
17 May 2006 4:13 PM - 5 messages
hi all, how can i know what SPs (service packS) is my SQL server box currently running on ...
Error Importing Access Database
soniic2003 -
17 May 2006 3:54 PM - 2 messages
Hello, I'm trying to import a 420MB access database into sql server 2005. To do this, I create a new blank database and right-click and go to Import Data. I choose the necessary options and start the process. ...
Unattended install of SQL 2k service pack 4
Allison -
17 May 2006 3:53 PM - 2 messages
Anyone know where i can get info/guide on upgrading SQL 2000 with SP3a to SQL 2000 service pack 4 by doing an unattended install? thanks ...
Deadlock Issue
Shyam -
17 May 2006 3:41 PM - 2 messages
Hi , I always face the Deadlock issue in our production DB.We are not running any Profiler nor any the Error Flag is set ON.The job fails and we trace the LOG file to check the error. We are not supposed to run any of these.Is there any ...
Login Issue
Brandon Owensby -
17 May 2006 3:30 PM - 2 messages
I have a computer with SQL Server on it that every computer in our office can connect to except one. The one that cannot connect gets the following error message. Server: Msg 18456, Level 16, State1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ...
query in QA - can someone explain this?
Dan D. -
17 May 2006 3:17 PM - 8 messages
Using SS2000 SP4. I was working on tuning a query. I opened a window in QA yesterday afternoon and ran the query a few times. It took 23 to 24 seconds each time. I left for the day shortly after that but left the query window ...
|
|||||||||||||||||||||||