|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
SQL Server Enterprise Manager Error
rdlrp -
21 Jan 2006 8:33 PM - 8 messages
Recently everytime I attempt to open a table returning all rows in any database SQL Server Enterprise Manager returns the following error An unexpected error happened during this operation [MS Visual Database Tools] Not enough storage is available to complete this ...
how to simplify what i'm doing (AS the solution?)
rsphere -
21 Jan 2006 3:19 PM - 2 messages
i need to do create reports that perform queries where the results are percentages of total count divided by counts based on different subquery where values. a la ... select 100 * (totalCount/ (select count where columnA value is x) as partialCount1) as perc1, ...
Snapshot Replication-2000
belle -
21 Jan 2006 11:40 AM - 2 messages
Hi, I have a server that is the distributor and publisher. This server keeps crashing because of hardware. We have another server and i want to move this replicated database to this new server. What are the steps I need to do? ...
database restore error
Gopi -
21 Jan 2006 8:53 AM - 2 messages
Hello when i try to restore the wss database in sql, i am getting following error. any idea? Warning: The join order has been enforced because a local join hint is used Using STSADM regards Gopi ...
Move MS SQL 2005 Express Edition Data Path
M P -
21 Jan 2006 1:53 AM - 3 messages
Hi! I just installed Web Developer express edition on my Windows 2000 server machine. I just wanted to know how may I change the default data path of MS SQL Server 2005 express edition. Me ...
Distributed Transactions with SQL Express, Server 2003, and XP SP2
Young, Corey -
21 Jan 2006 12:51 AM - 3 messages
I have SQL Express installed on a Windows XP SP2 machine and on a Windows Server 2003 machine. I added the Windows Server 2003 machine as a linked server on the Windows XP SP2 machine. I have checked and double checked that the DTC settings are correct on both ...
MSDTC Error
Ben -
20 Jan 2006 10:31 PM - 4 messages
Setup: Win2K Server, SQL server 2000 sp4 "Microsoft OLE DB Provider for SQL Server error '8004d00a' New transaction cannot enlist in the specified transaction coordinator. " I've seen the KB atricles if you have this problem on server 2003 but the ...
SQL2K Function Print
Mica Cooper -
20 Jan 2006 10:27 PM - 7 messages
I am trying to print a debug statement in a function and SQL Server will not allow it. Here is the top of the function: CREATE FUNCTION [dbo].[fnCorrectingEntryByLocation] (@intLoc int = 0) RETURNS TABLE AS RETURN SELECT TOP 100 PERCENT dbo.tblProducts.intComponentID, ...
SQL Server Licience
Rustom -
20 Jan 2006 9:54 PM - 2 messages
I have a SQL Server 2000 server...How do I verify what type of licience is being utilized. Thanks Rustom ...
Trying to create a maintenance plan
Mike -
20 Jan 2006 9:51 PM - 3 messages
Hello, when I try to create a maintenance plan I am getting the error TITLE: Microsoft SQL Server Management Studio ------------------------------ Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ ADDITIONAL INFORMATION: An OLE DB error 0x80004005 (Client unable to establish connection) occurred ...
SQL 2000 SP4 Install and MDAC 2.8
Paul Bergson -
20 Jan 2006 9:22 PM - 3 messages
I'm a bit confused. The readme file states that "Computers that run Windows 2000 are upgraded to MDAC 2.8 SP1. Computers that run XP or 2003 are not upgraded..." Is this saying once I upgraded the SQL Server to 2000 SP4 every 2000 client ...
CLR integration & clustering....question
Corey Bunch -
20 Jan 2006 9:14 PM - 6 messages
If I've got a small CLR procedure that I'm now using thanks to 2005, and I'm running on a failover cluster.....do I need to have the DLL available on both nodes of the cluster at the same path? So when I ...
Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server
Charles Wilt -
20 Jan 2006 8:22 PM - 3 messages
I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access via a linked server from SQL Server 2000. The following select works fine: select * from prod400db.test.meldbf.InventoryHistory However, this insert statement fails: ...
cpu up with SQL2005 - higher FullScans/sec, lwr IndexSearches/sec
George Koulis -
20 Jan 2006 7:42 PM - 7 messages
We are seeing a 29% increase in the cpu of the sql process in SQL2005 over a 5 hour perfmorance test. The application code is the same and the actions performed during the test are the same. The increase is compared to SQL2000. ...
Generate SCRIPT
Ganesh Muthuvelu -
20 Jan 2006 7:13 PM - 5 messages
Hello, Using the new "SQL Server Management Studio" for SQL Server 2005, how would I generate scripts for more than one object at a time. Let us say I want to generate scripts for all tables, how would I do that?. ...
Server: Msg 7399, Level 16, State 1, Line 3
tapmrp1 -
20 Jan 2006 6:57 PM - 4 messages
I am using SQL 2000 with SP3a and MDAC 2.8 RTM on two sql servers with Windows 2000 SP4. I linked a third sql server from both using same parametres for the link server settings and runt the a qurey. But it runs ok on one sql ...
Backing Up Muliple Databases in Same Instance
Ogemdi -
20 Jan 2006 6:30 PM - 4 messages
I've 6 databases in the same instance which I wish to se a backup routine for. How can I select all the databases at a go and create a backup procedure just once in enerprise manager. I tried highlighting all he databases, but ...
SQL2005 in a Pentium 2
Kirsten -
20 Jan 2006 6:07 PM - 4 messages
SQLServer 2005 requirements show that SQLServer 2005 required a Pentium III (or higher) CPU. Had anyone installed it in a Pentium 2? Is it possible? Thanks! ...
query to identify all fields in a table
Cindy B -
20 Jan 2006 5:54 PM - 3 messages
Newby question. We have a new vendor who will be needing to do data convertion from our current SQL app into his new application, as part of the implimentation. I need to identify the complete file structure in order to ...
Newbie: PIVOT
acb -
20 Jan 2006 5:38 PM - 3 messages
Hi, SELECT * FROM SalesOrderTotalsYearly PIVOT (SUM(SubTotal) FOR CustomerID IN ([1], [2], [4], [6])) as a GO The above is taken from the SQL Server 2005 T-SQL Enhancments document used in the Microsoft Hands-On LAB. My question is whether the IN ([1]...[6]) is always necessary? ...
BLOBS in a sql server database - yes or no?
Benjamin Janecke -
20 Jan 2006 5:04 PM - 3 messages
Hi, we have a sql server 2000 database running that manages amout 10 million invoices (growing at 10000/day). in addition, we have a file server that holds all invoices as pdf files. the problem is that it is extremely ...
Connection between two domains
VM -
20 Jan 2006 3:40 PM - 6 messages
Hi All, We have two different domains in our environment, say ABC and XYZ, and they are not trusted. I login into my PC using ABC domain . I have windows authenticated login in SQLServer that is in XYZ domain. ...
application name in profiler, could it be modifed
t2581 -
20 Jan 2006 3:21 PM - 2 messages
Hi, We have 500+ dts running 24 X 7 ,started from dts run In profiler every enty in application name column show as Dts designer. 1. Is possible to modify dts property or anything and add customer ...
How to encrypt sql backup¿?
jordi -
20 Jan 2006 3:13 PM - 3 messages
Hi, I need encrypt media containing a sql backup, this media travel around any factorys, is very important the security of content in this media and garantize don't read for anyware sql server, only read in the original server, is possible¿? ...
Class does not support aggregation
Rich -
20 Jan 2006 2:20 PM - 3 messages
In Microsoft SQL Server Management Studio 2005 whenever I open a table I get the error ------------------------------ Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration) I previously had SQL Server 2000 installed, but the upgrade worked ...
Question to linked server, wrong result
ln54 -
20 Jan 2006 1:15 PM - 3 messages
First the question and correct result in Oracle SQL> select distinct anv_uppg, profilkod from ekop2.bav001 where anv_uppg like 'san%' ; ANV_UPPG PRO --------------- --- sanderss SAN ...
problem with xp_smtp_sendmail
pabloov -
20 Jan 2006 11:05 AM - 4 messages
Hi friends, i have trying to make a procedure to send an email tom my e-mail account using xp_smtp_sendmail, but y have a problem and i don't know why i dont receive any message. I make ping to the server and it works but when i run this: ...
DEFAULT values for Procedure parameters
Martijn Tonies -
20 Jan 2006 9:41 AM - 2 messages
Hi there, I was wondering if there's a way to get the default values for stored procedure parameters. I've tried both MS SQL 2000 and SQL 2005, but I cannot figure out a way to do it except for parsing ...
Restore of MDF- and LDF-Files
Jens Mertens -
20 Jan 2006 8:51 AM - 3 messages
Hi NG, I have made copies of the MDF- and LDF-files of several databases. for some reason I couldn't restore the databases in the usual way, because MSSQL Enterprise Manager told me, that the database was "currently in use". well, ...
How can I get the message return?
luyan -
20 Jan 2006 8:28 AM - 6 messages
For some reasons I want to get the massage of return when I carry out a query. I only know use @@error: select * from teste; --teste does't exist select description from master.dbo.sysmessages where error = @@error Invalid object name '%.*ls'. ...
AWE and set working set size
RDBSAdmin -
20 Jan 2006 7:29 AM - 7 messages
Hello everybody! System description: OS: Windows Server 2003 Enterprise Edition SP1 RAM: 16 Gb SQL: SQL Server 2000 Enterprise Edition SP3 SQL Server has "awe enabled"=1 and "set working set size"=1 at the same time. "Max server memory" is limited by 12 Gb. SQLServer:MemoryManager:Total ...
SQL Server Agent Jobs that are running
David -
20 Jan 2006 3:38 AM - 3 messages
All Is there a TSQL command that I can use to check if a SQL Server Agent Job is currently running. Thanks ...
Collation Conflicts SQL 2005
Codey -
20 Jan 2006 1:52 AM - 3 messages
Hi there, We have recently upgraded to SQL 2005 standard from SQL 2000. I have begun a new web project in Visual Studio 2005. I have added a SQL data source to my project which contains a VIEW. I am passing a single parameter to the DS to populate a gridview. ...
Can't connect from ASP.Net 2.0 to SQL2000 after installing SQL2005
Christoph Wienands -
20 Jan 2006 1:39 AM - 2 messages
Hey guys, I have a web application in ASP.Net 2.0 that needs to connect to a local SQL2000 DB. After I installed SQL2005 this web app stopped working. I get the following inner exception: {"An error has occurred while establishing a connection to the server. When ...
Attaching SQL Server 2000 database on SQL Serve 2005
imarchenko -
20 Jan 2006 1:13 AM - 6 messages
Hello! We are planning to migrate our multi terabyte SQL Server 2000 database by detaching data/log files on 2000 box and reattaching them on 2005. Has anyone experienced any issues with this process in general and databases of ...
user accounts after restore in SQL 2000
Vasya -
19 Jan 2006 11:38 PM - 4 messages
We have 2 SQL servers: PROD and TEST. Obviously, the TEST is a test environment for PROD. Both of them identical and have same user accounts with same permissions. When there is a need to backup PROD and restore it to TEST ...
query performance with large tables
Ken Abe -
19 Jan 2006 10:57 PM - 2 messages
Hi, I am currently facing two problems: one general and one more specific. My general issue is improving the performance of queries involving a very large table. I know that the most efficient optimization is to create indexes that match the type of queries I run. Are there any other solutions? Can I ...
Troubleshooting lost connection from client
Moh -
19 Jan 2006 9:40 PM - 2 messages
Hello - We have an application which time to time complains un able to connect to the databases. What we should monitor on the DB side to validate if this is true? We have SQL 2000 Ent edition ...
sql2k log backup
mecn -
19 Jan 2006 9:22 PM - 4 messages
Hi, I ran log backup couple of times. but the log file size did not shrink. Anyone knows why? Thanks ...
SQL Server 2005 Scripted DB SQL 2000
Joe K. -
19 Jan 2006 9:10 PM - 2 messages
I have a SQL Server 2000 scripted database. I would like to check this scripted database with all it's stored procedures and triggers to see if there would be a problem upgrading this database to SQL Server 2005. ...
Difference between 2000 and 2005. Maybe a bug?
Wayne -
19 Jan 2006 9:09 PM - 3 messages
I’m having a problem with a piece of sql and the way it is interpreted in SQL Server 2000 and SQL Server 2005. Here is a table definition: if not exists (select 1 from sysobjects where uid = user_id() and type = 'U' and name ...
linked server to Excel
Vince -
19 Jan 2006 8:16 PM - 3 messages
We've created a linked server to access an Excel spreadsheet that resides on the same server as SQL Server 2000. If we log on to the database server (Windows 2000), then launch Enterprise Manager, the linked server works ...
server feedback
klara -
19 Jan 2006 8:01 PM - 2 messages
I haven't touched MSSS in a looong time When a SELECT returns say 3 rows what does the feedback say ? (eg Oracle/sqlplus says "3 rows selected") What if "no data found", what is the feedback ? thanks ...
Moving the SQL 2005 System Tables
Kevin Antel -
19 Jan 2006 7:31 PM - 2 messages
2 Questions Actually! 1. I know how to move all the system DB's in 2000, but I am a bit confused as to how to accomplish this in 2005. I need to move: Master Model MSDB I've already moved Temp. ...
Sql Server 2005 - SMS "Modify Table option" times out when trying to 'alter' very large table
frostbb -
19 Jan 2006 7:30 PM - 4 messages
We've found that Sql Server 2005 SMS "Modify Table option" 'croaks' when trying to insert a startcard_nbr INT column into the following table just above the last_updt_date column. It throws an error window with the following ... ----------------------------------------- Post-Save Notifications ...
How do you change SQL Server 2005 services login account informati
Mike -
19 Jan 2006 7:29 PM - 2 messages
How do you change SQL Server 2005 services login account information? I will be using a new domain account for the SQL Server 2005 services. Thank you. ...
SQLExpress
Arne -
19 Jan 2006 6:43 PM - 4 messages
I can open SQL Server Manangement studio and connnect to computer\sqlexpress. My databases are listed. I can also do sseutil -l which list a different set of databases on the same machine. How can that be? ...
Not enough storage...
FireStarter -
19 Jan 2006 6:25 PM - 2 messages
Starting a few days ago, I started getting an error "Not enough storage space" whenever I try to import a text (comma-delimited) file through DTS. This started happening when I restarted the server after appliyng some Windows updates. It's not happening if I first import the file into ...
Rename Cluster Instance - New Hardware - Keep Name
Simon -
19 Jan 2006 6:18 PM - 3 messages
Hello all, We are moving a sql cluster to new hardware but would like to keep the same server/virtual instance name. Could anyone offer some advice on how to go about this or point us in the direction of some Microsoft how to articles? ...
SQL Server CPU Spikes
Amos Soma -
19 Jan 2006 6:04 PM - 2 messages
We have a server running both SQL Server 2000 and SQL Server 2005. Shortly after installing SQL Server 2005, we started seeing spikes in CPU usage (75% to 99%). This appears to be random. It sometimes lasts for many minutes. I ...
Querying connection options
Tom -
19 Jan 2006 6:00 PM - 2 messages
I know you can use @@OPTIONS to see your connection options, but Is there a way to see the connection options of other active spids? ...
Object search query???
Enric -
19 Jan 2006 5:58 PM - 2 messages
Dear folks, I am looking for a script which be able to replicate the same functionality that 'Object Search' from QA (F4 key). I am looking for a specified column in a database and the problem is that from the results panel of 'Object Search' ...
Database refresh
David -
19 Jan 2006 4:51 PM - 2 messages
Hi, I want to refresh one of the database from production server to QA server every first day of the month. How can I do it through scheduling a job? Any one has scripts handy? Also, will it transfer all the logins when I refresh the database. If not, ...
Microsoft doesnt really support anything over 32 Databases(??)
Jens Mertens -
19 Jan 2006 4:27 PM - 4 messages
Hi NG, I've read the following statement on [link] "Microsoft doesnt really support anything over 32 Databases". (This statement was uttered concerning the creation of a large amount (ca. 200) ...
SQL Server 2005 Express on SQL Server 2000
Mark Ware -
19 Jan 2006 4:24 PM - 2 messages
Can databases created on SQL Server 2005 Express be ran on SQL Server 2000? In this day of cost-cutting, the company wants to hold off on upgrading our production boxes from 2000, however, we have users that want to do ...
Slow performance
SQLScott -
19 Jan 2006 3:42 PM - 2 messages
I heard somewhere that hyper-threading should be turned off for SQL Server 2005 for performance reasons. I cannot find any documentation anywhere to support this but I'm seeing some really poor performance when I am hitting SQL 2005 pretty hard. ...
Can I use SQL Express database inside full blown SQL 2005?
GS -
19 Jan 2006 3:06 PM - 4 messages
Hi, I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work? ...
Linked server in sql 2005, Oracle and DB2
Bjorn -
19 Jan 2006 2:11 PM - 3 messages
We are moving from a SQL 2000 32-bit Standard Edition to a SQL 2005 64-bit standard Edition and are using linked server to Oracle 10 and DB2 on AS/400. Current system: Windows 2000 32-bit SQL 2000 sp3 ...
Error when restoring master database
jouj -
19 Jan 2006 1:21 PM - 3 messages
Dear all, I'm working on MS SQL 2000. I stopped the SQL Server and the SQL Agent services. and from the prompt: sqlservr.exe -s MyInstanceName -c -m then from QA, I've entered my MyInstanceName, user: sa and pwd. ...
Cannot connect to remote SQL 2k5 server in local network
Jason Chan -
19 Jan 2006 12:58 PM - 6 messages
My SQL 2005 Dev Edition hosted on WinXP. However my another WinXP in the same network cannot connect to the SQL 2k5 using ODBC Got this error: Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). ...
Connecting to another SQL SErver
Juliano H via SQLMonster.com -
19 Jan 2006 12:43 PM - 6 messages
Hello, All! I am trying to connect to another instance using Transact SQL, but I didn't get it yet. Could we help me with it? I tryed to use, CONNECT TO, but I always receive the same error message. ...
Encrypting Credit Card details
Dooza -
19 Jan 2006 12:27 PM - 4 messages
Hi there, I need some advice. We have been told that if I want to store credit card details in an SQL database that it must be stored as enrypted data. Can anyone recommend how I do this please. Cheers, ...
optimizing load performance using partitioned tables in 2005
Vivek -
19 Jan 2006 11:32 AM - 3 messages
Hi, Iam curious to know if i can increase my load performance using partitioned tables. If i create a 4-way partitioned table, can i load directly into a specific partition, so effectively having 4 parallel loads into the 4 partitions. (Something i can do in Sybase). ...
Error 2571 - not permission to run DBCC TRACEON
Soren -
19 Jan 2006 9:29 AM - 6 messages
Hi, I am trying to connect to SQL Server 2005 via Excel/ODBC. (ODBC Test IS successfull) and get the following error after entering Login ID and Password: Connection failed: SQLState: '37000' SQL Server Error: 2571 ......does not have permission to run DBCC TRACEON ...
SQL 2005 Tlog SIze
rupart -
19 Jan 2006 9:09 AM - 2 messages
Hello, I have a database with multiple filegroups. Is there any limitation in log file size? I encountered the db gone dead when the tlog reaches 2G.But i dont see that default value set anywhere or neither we set it. ...
Expected LSN of a standby DB
Peter Reid -
19 Jan 2006 8:35 AM - 3 messages
thanks john, but RESTORE HEADERONLY will give me the LSN range in the backup file. I'm after the LSN a standby database is expecting next... ...
Transaction Log nearest 3G
beachboy -
19 Jan 2006 8:16 AM - 3 messages
I found the Transaction Log of DB in my SQL server nearest 3G how can i keep the transaction logs around 1G only?? Currently, I set "automatically grow file by percent" and "Unrestricted file growth" Now, I have 3G Transaction Log, if I set to "restricted file growth to 1G", ...
Renaming MDF & LDF files.
Adam Knight -
19 Jan 2006 6:56 AM - 2 messages
Hi all, Is there a safe way to rename the mdf & ldf files for a particular db and reattach the db to Sql Server?? Cheers, Adam ...
Event Viewer
Jiteshk -
19 Jan 2006 5:16 AM - 2 messages
Hi All, All My SQL SERVER whether it is successfull or Fail it is written in Windows Event Viewer is there any way it can stop that .I mean this information is written into sql server log so i don't want this to be written in Event ...
SQL Express - Cut features
Joseph Hanna -
19 Jan 2006 2:57 AM - 3 messages
The SQL Server 2005 range looks absolutely fantastic. I can't wait to leverage some of the new features... but I'll have to. Many of my clients are using MSDE 2000. It has served them well and it is ...
Database Mirroring and Backup
Chris B -
19 Jan 2006 2:16 AM - 3 messages
I am looking for help in setting up our mirroring / backup / snapshot strategy We are definately going to use Database Mirroring I also want to get my databases onto tape for archive. Do I only backup the Primary SQL server? If so, do I just use the standard MS backup tools? If ...
Sql Server 2005 Management Console Connect to Sql Server 2000?
Selden -
19 Jan 2006 1:51 AM - 5 messages
I recently installed Sql Server 2005 on one of my computers. I'm trying to copy a database to Sql Server 2000. I can click Connect, Database Engine, and find my sql server 2000 on the network, but the connection always fails. Is it possible to connect to Sql ...
sp_sendmail
Hoosbruin -
19 Jan 2006 12:59 AM - 2 messages
How do I check that the sp_sendmail went thru. I looking for away to verify that the mail went out thru Exchange and didn't get a non-deliverable for some reason. The subject has the same format when we use sp_sendmail. ...
Can not connect to SQL Server
Snoopstah -
19 Jan 2006 12:47 AM - 3 messages
A user who has been connected to our server for several years can not longer connect. The error through ODBC shows the following : Connection failed: SQLState: '01000' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()). Connection failed: ...
Alerts
docsql -
18 Jan 2006 11:51 PM - 3 messages
I have a Windows 2003 server running SQL 2000 SP4. I want to start setting up email alerts and reporting on the SQL server. The network admin team is not ok with installing any mail client. Is there any other way to have ...
dts scheduling
pardhi a via SQLMonster.com -
18 Jan 2006 11:41 PM - 2 messages
Hi i am trying to schedule a dts package in sqlserver 2005 but i really didn't find any options like(schedule) can anyone tell me how to schedule a dts pakage in sqlserver 2005 ur help is really appreciated ...
Script to list Users with SA Role on the server
shub -
18 Jan 2006 11:01 PM - 2 messages
I am wanting to get a list of all the users on a SERVER who has the System Administrator role assigned to their login. I was wondering if there is a script or table(s) that I could refer to instead of looking ...
Transactional logs
Kanwar -
18 Jan 2006 10:20 PM - 2 messages
Hi, I am running sql server 2000. I am unable to backup transactional logs manually as the Radio button is greyed out. Any inputs why this is happening? Thanks, Kanwar ...
profiler
Andre Gibson -
18 Jan 2006 10:18 PM - 3 messages
I stsrted a trace on one of my bds and it is creating mulitple 5 mb files. I thought it would stop once I closed the profiler. WRONG!!! How can I stop this? ...
Shrink Database Transaction Log
Joe K. -
18 Jan 2006 8:57 PM - 2 messages
My SQL Server 2000 database transaction log file grew yesterday from 1 GB to 30 GB. I would like to shrink this transaction log. What is the best to shrink this transaction log file. Thank You, ...
purge all history from msdb
MunchingBill -
18 Jan 2006 8:32 PM - 2 messages
I am looking for a way to setup a periodic delete from all history tables in msdb, to prevent excessive growth. I am wondering if the following procedures includes all necessary deletes. 1) In the maintenance plan wizard reporting tab, setting the number of ...
Log shipping and Manual backups
Parks -
18 Jan 2006 8:19 PM - 2 messages
I have set up a log shipping on my master and backup database, where a full backup of the master database is done each day at midnight and restored to the backup database. The master databases transaction logs are then backed ...
SQL Server 2000 Enterprise Edition - how to create named instance?
Rich -
18 Jan 2006 7:35 PM - 4 messages
Starting Environment - Development Workstation Windows XP SP2 Visual Studio 2005 (it installed the default instance of SQL Server 2005 Express Edition as a "side effect") I downloaded the (2) CD set for SQL Server 2000 Enterprise Edition. I ran the installer - ...
CPU maximums & multicore CPUs
Debbie -
18 Jan 2006 7:29 PM - 6 messages
I have been reading the licensing information for SQL 2005 as it relates to logical CPUs (hyperthreading or multicores) but all of the white papers I am reading cover the Per Processor model when addressing this. Does anyone know, when not using the Per Processor model (i.e. Per Server ...
Can not Create a DSN
Johnfli -
18 Jan 2006 6:10 PM - 2 messages
I am trying to create a new System DSN but when I get to the part where it reads" How should SQL Server verify the authenticity of the login ID?" I select the second option: "With SQL Server authentication....." Then on the ...
SQL Backups
DeAnn -
18 Jan 2006 5:26 PM - 3 messages
We are currently using CA Enterprise backup and have had issues with differential restores. They are saying we must use them throughout because when you run MS backup it puts checkpoint and their product cannot restore. We had been running MS backups and are dealling with ...
Cannot defragment .mdf file
Adrian -
18 Jan 2006 5:19 PM - 3 messages
I am trying to defragment a .mdf file. The .mdf size is 20GB, and there is 43GB free space on the drive. When I run the Windows Server (2003) Disk Defragmenter it reports that this file cannot be defragmented. Other smaller ...
Sql server self locking
mecn -
18 Jan 2006 5:08 PM - 5 messages
Hi all, I see the spid = 123 be locked by spid123. why? Thanks, ...
Sql 2005 server memery
mecn -
18 Jan 2006 5:06 PM - 3 messages
Hi, all What is the max mem for sql server2005 ? Unlimited? What's mem for sql 2k server? Thanks, ...
25 seconds for query on empty table (SS 2005)
Pat -
18 Jan 2006 4:29 PM - 3 messages
And this is on a dual Xeon with 4 Gig of memory. Here is the script that's taking so long. Would someone be so nice and try it on their SQL Server 2005 and tell me if they have the same issue? Thx. ...
SP2 SP3a SP4
CLM -
18 Jan 2006 4:29 PM - 3 messages
I've got a 2000 SP2 server and we went to SP4 on it. (The o/s is Win 2000 SP4.) But I've been reading about quite a few issues associated with SP4 and so I'd like to go to SP3a instead. But when I go onto the box, I don't see ...
saving SSIS package
JJP -
18 Jan 2006 4:26 PM - 2 messages
Hi, Let me know if this is possible... We have a SQL 2000 SP3a cluster on Windows 2003 Server that is inside our network. We have a SQL 2005 server, that is also our web server, out in the DMZ. ...
Trigger Performance
__Stephen -
18 Jan 2006 3:48 PM - 3 messages
I'm not well versed in Triggers, so this should be a straight forward request. On a change in a status column, Deactive bit, I want to place the getdate() in the column DeactiveDate smalldatetime CREATE TRIGGER deactiveUpDate ON [dbo].[SALES_REP] ...
Registering Servers
Gary L -
18 Jan 2006 3:43 PM - 2 messages
In Enterprise Manager 2000 I was able to register multiple servers and next time I opened it those servers would automatically connect. With SQL Server Management Studio 2005 I can register multiple servers, but next time I open it only the last one I had connected shows. Is there a way to maintain ...
BULK INSERT to a Temporary Table
Paulo Andre Ortega Ribeiro -
18 Jan 2006 3:41 PM - 2 messages
I wanto to execute a BULK INSERT command into a Temporary Table: CREATE TABLE #textfile (line varchar(8000)) -- Read the text file into the temp table BULK INSERT #textfile FROM 'c\Projects.txt' But when I execute this command a recieve the following error message: ...
multiple instances on one virtual server
Robert Kinesta -
18 Jan 2006 3:21 PM - 3 messages
In a failover cluster is there any way at all that more than one named SQL Server instance can exist on a virtual server? Thanks! ...
Performance- Buffer Manager:Page Lookups/Sec
MAS -
18 Jan 2006 2:52 PM - 2 messages
We have a BI app that were testing, running many different reports. Under some conditions the Buffer Manager:Page Lookups/Sec counter spikes very high. I was wondering if this normal behaviour, and if not, what can be ...
how can i monitor full text queries?
ch -
18 Jan 2006 2:34 PM - 5 messages
i've got a sharepoint database configured by a sys admin. how can i use profiler to see if there are any full text queries happening? just look for the "contains" clause or something else? ...
Bad Page error
Andy -
18 Jan 2006 2:25 PM - 6 messages
I am getting an error in my DTS logs about a bad page. Here is the exact message. Step Error Description:I/O error (bad page ID) detected during read at offset 0x0000022a040000 in file 'E:\SQLData\ALS_Stage_Data.MDF'. ...
Opening up SQL 2005 Management studio generates Winmgmt error
Steven -
18 Jan 2006 2:09 PM - 2 messages
I have been getting the following winmgmt error in my application event log when I connect to a clustered SQL 2005 server using SQL Management Studio. Has anyone ever encountered this and does anyone know how to stop this? Event filter with query "select * from __InstanceModificationEvent within 10 ...
|
|||||||||||||||||||||||