|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Imposed Logon to SQL even in MMC
Simon Koh -
11 Mar 2006 7:17 PM - 2 messages
Hi, How do I impose logon requirement when trying to connect to MSDE2000 via SQL Enterprise Manager? I would like to lockdown to avoid someone changing dB table design. Thanks, Wul ...
SQL Support
Stephanie -
11 Mar 2006 5:43 PM - 4 messages
Does SQL Server 2000 support Windows XP Home? I can get SQL Server from my Office XP but it doesn't seem to be working right. The ReadMe file says it supports everything, but doesn't mention XP. ...
Database and log file size
Judy -
11 Mar 2006 4:25 PM - 5 messages
I've been reading SQL Server High Availability and went thru some recent webcasts by Kimberly Tripp and from what I've found out, I think we need to do some adjustments to our database. It is SQL Server 2000 back end for an ...
upgrade from Express to SQL Server
Jassim Rahma -
11 Mar 2006 8:17 AM - 2 messages
I just wanna to ask how easy is to upgrade from SQL Express 2005 version to the SQL Server full version? I am here talking about the data only not the software itself.. ...
backup files to local PC
Jassim Rahma -
11 Mar 2006 8:15 AM - 2 messages
howcan i backup my database from SQL Express 2005 to my local PC? ...
fill factor problem
pizza -
11 Mar 2006 2:19 AM - 2 messages
Hi ! I have a problem with my current database. All the fill factor of primary key and index in the table are set to 90% and it slow down the performance of store procedure. I had manually change the fill factor to 0 ( this process take quite ...
SQL Server Manager won't connect
fdisk -
11 Mar 2006 12:25 AM - 3 messages
Hi, I'm a SQL newbie - hoping someone here can help. I installed MSDE SQL on a Windows 2000 Server SP4 in preparation to install WSUS. Unfortunately I didn't include the instancename=WSUS switch the first time around so I had to uninstall everything and start again. However when I ...
Running Views on SP2 Slower than SP3
sqlclubber via SQLMonster.com -
11 Mar 2006 12:22 AM - 2 messages
Hi has anybody experienced views running slower on SQL 8 SP2 is slower than running it on SP3? I have 1 log shipping report server on SP3 that runs those views with out problems. I have another server with Replication running SP2, I find that views running ...
differnce between 2 aggregate columns
aj70000 -
10 Mar 2006 11:51 PM - 8 messages
Hi, -I have 2 views 1)revenue, 2)expenses -Columns are Client,Year,sum(Amount),Business unit. on both of them Need some help on writing the query. I would like sum(a.amount)-sum(b.amount) group by year,bu,client. ...
Select all columns except certain types
neilsanner -
10 Mar 2006 10:42 PM - 7 messages
Hi, Hi have a table with over 90 columns. I would like to create a query that would select all columns except those with the date data type. Any ideas? neilsanner ...
Dynamic Column header in CASE statement
sck10 -
10 Mar 2006 9:56 PM - 3 messages
Hello, Can you dynamically change the header name in a CASE statement? In the following, I would like to be able to change the column header depending on what the value of @Actual is. Thanks in advance, Steven ...
Back up the transaction log for the database to free up some log s
jdn -
10 Mar 2006 9:31 PM - 3 messages
I have a server with 80 GB free space. Logfile for the database is set to autogrow (10%), unrestricted. The log file itself is right now about 25 MB. This message can't be accurate, so I'm wondering what could cause this. ...
SQL Server 2000 SP4 not deleting old logs
javatopia -
10 Mar 2006 8:52 PM - 6 messages
HI, I have a SQL Server 2000 with SP4 Windows 2003 Standard. Using the maintenance plan wizard, I setup the full db backup and tx log backups to delete logs older than 1 day. I found that it is not deleting these logs, though. The sql log does not ...
Multiple instances in SQL Cluster
VM -
10 Mar 2006 8:43 PM - 4 messages
Hi All, I have joined a company recently. They are having mutiple servers of SQL Server 2000. And one of them is a two node SQL server cluster. It is having a Active/Active configuration. That means on one node we have one instance ...
Message: Cannot use Large Page Extensions
imarchenko -
10 Mar 2006 8:40 PM - 4 messages
Hello! I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server cluster with 28GB or RAM. ...
SELECT does not return duplicate rows as it's supposed to?
bing -
10 Mar 2006 8:39 PM - 5 messages
Hi, I thought the following SELECT should only return the duplicate rows. use db; select col_name_group from tbl_group group by col_name_group having count(*)>1 But the result is: A E: Agricultural Engineering A E: Agricultural Engineering (B, M, D) ...
Programmatically exporting and importing data SQL Server 2000 and
NoFear -
10 Mar 2006 8:26 PM - 2 messages
What should I use to import and export data from, to, and accross SQL Server 2000 and 2005. Need to export to a file and then import from a file. Currently my program uses SQLDMO, which is very easy to use, powerfull, and ...
Dynamic SQL & Column Name
PunkrawkStudios -
10 Mar 2006 7:57 PM - 2 messages
[Table=Customers] Picture of what the table looks like <a href="[link]" target="_blank"><img src="[link]" border="0" alt="Image hosting by Photobucket"></a> ...
missing SP when I query for it's text
_Stephen -
10 Mar 2006 7:48 PM - 2 messages
I have code below to extract a table name and a verb. I receive 4 rows back. I think fine. Unfortunatly my programmer says that the SP in question is not part of the return set. Select routine_name from INFORMATION_SCHEMA.ROUTINES where ...
Reduce File Size
Dragon -
10 Mar 2006 7:19 PM - 4 messages
Everyone, Here is what I am looking for. I have production databases (around 20GB each). I need to have copies of these available for my developers. They don't need the whole 20GB so what I do is delete all the records from the DB ...
How to script Sprocs permissions in Management Studio?
John Dalberg -
10 Mar 2006 7:05 PM - 4 messages
I am dissapointed that script options are missing in Management Studio. I never understand why a good feature goes away in a newer version. Is there any way to script the permissions for stored procedures? John Dalberg ...
Bulk insert every other row?
Nieves -
10 Mar 2006 6:32 PM - 3 messages
Is it possible to do a bulk insert of every other row? I have a file that is double space - meaning a data row then a blank row, etc. . I thought I could just use a row delimiter of CRLF twice, but that didn't work. Any ...
master table
Martin -
10 Mar 2006 4:28 PM - 2 messages
Recently, I noticed that our SQL Server has two system tables that I don't think I have seen them there before. They are master$4IDR and model$4IDR. They seem to run together with the master and model table with the same ...
DTS Across Network Errors
michael.esposito -
10 Mar 2006 4:21 PM - 5 messages
I have a database and web server (physically different boxes) and I am trying to get DTS to read in a file from the web server and insert the data into the database. I get permissions errors when I try to execute ...
Newbie question on physical file last mod date vs. virtual DB/Log
Don Anthony -
10 Mar 2006 3:55 PM - 5 messages
I think I understand the basic features of log files and how to backup/truncate them to avoid oversized files. Where I need help is understanding why the O/S rarely puts a new datetime on the physical files. It appears to only update the log file ...
Different times on different instances
Pedja -
10 Mar 2006 3:51 PM - 2 messages
Hi, we have sql server 2000, sp4 and we need to add new instance to this server. Is it possible to setup time (zone) different than server local time for this new instance? I am asking this because application which should rely on new instance uses ...
Database Mail stops working on SQL 2005
CoreyB -
10 Mar 2006 3:45 PM - 7 messages
We've encountered a problem on several SQL 2005 installations where database mail completely stops working for no reason. Has anyone else encountered this? This only affects calls to sp_send_dbmail and job alerts, etc. When I right-click DBMail in SSMS and choose Send Test ...
Per Processor Licensing
Tim Miller -
10 Mar 2006 2:57 PM - 2 messages
I've had a SQL 2000 Server with one processor and Per Processor licensing for some time. I recently purchased an additional processor for that server, and purchased another independent 'Per Processor' license. I put the extra processor in and now in Enterprise Manager it shows 4 ...
BCP into image columns
ian_jacobsen -
10 Mar 2006 2:56 PM - 6 messages
I'm trying to use the bcp executable to insert rows into a table containing two guids and two image columns. I'm using an explicit character string for the field delimiter, and another for the row delimiter (not the usual "\t" and "\r\n"). When I do the following bcp ...
sysxlogins
George Schneider -
10 Mar 2006 2:17 PM - 2 messages
When I was moving some databses over to a new server I used the copy databse wizard which created the neccessary logins in the sysxlogins table on the master databse. Some of the databases I decided I no longer needed so I ...
Can not drop a member from a role
avni.cengel -
10 Mar 2006 9:50 AM - 2 messages
I've just changed server from SQL2000 to SQL2005 (by backup/restore). But I can not drop a user from a role. I did it from Management Studio. It didn't give any error message but even I refresh the db, I can still ...
Logfile wish
Marius Horak -
10 Mar 2006 9:44 AM - 6 messages
Dear M$, Can you get rid off Logfile in your next release of SQL Server, please. It's pain in neck and 30 year old technology. MH ...
Link for 'Compare the Editions'
Ian Samuels -
10 Mar 2006 8:22 AM - 6 messages
Hi, Does anyone have a link for the 'Compare the Editions' Page for SQL 2000? It appears Microsoft are now only showing the 2005 version page. Thanks - Ian. ...
Does not allow remote connections
larzeb -
10 Mar 2006 7:47 AM - 2 messages
I have installed SQL Server 2005 Std on an XP system for development using VS 2005. When I try to connect to the DB via Server Management Studio, I get the message that "... does not allow remote connections". When I launch Surface Area Configuration and select the Surface Area Configuration for Services and ...
SQL Server Query Execution Plan
Praveen -
10 Mar 2006 6:50 AM - 2 messages
How the SQL Server optimizer choose determines which Execution plan is best plan?. ...
SQL Server statistics
Praveen -
10 Mar 2006 6:25 AM - 6 messages
How do i find out sql server statistics are out of date for particular table or index?. (Except Graphical excution plan and profiler). is there any system procedure avilible?. ...
can we increment the column --autimatically---is there any possiblity with tiggers
satish -
10 Mar 2006 6:12 AM - 2 messages
hi, i am a beginner to ms sql server2000 i have a table create table ddd (a int, b int) by table structure is a b now when i enter a value in b column suppose '2' in column b ...
SQL2000 - DB maintenance and transaction logging
Dilan A -
10 Mar 2006 12:41 AM - 2 messages
Hi, Noticed that we have a 15gig log backup on our SQL server after the log backups were started after a 5 hour pause. Usually the log is backed up every 15 minutes but we pause this job between 12 AM and 5 am ...
DTC Service Account
Jeff Ericson -
9 Mar 2006 9:48 PM - 2 messages
For those that use it, what service account do you run your DTC on? Is it the same as your MSSQLServer service account? ...
Help with query to fill in missing records
Gary Rynearson -
9 Mar 2006 9:33 PM - 2 messages
The sql statement: select TransactionYear TYear, InstallationYear IYear, sum(SumAmount) Amount from AgedCostDataRecords where TransactionYear = '1970' ...
truncate table error
Hong Wang -
9 Mar 2006 9:15 PM - 2 messages
Hi, I have two tables, these two tables has a foreign key constaint, and I want to truncate both of them. I first truncate the child table with no problem ( the table has 0 rows now). But when I try to truncate the parent table, I got ...
corrupted db with error when restore from transactionlog
Yifei -
9 Mar 2006 8:33 PM - 4 messages
Dear All, A dabase index corrupted yesterday, and then we restore the database from yesterday early morning with norecovery option, when I try to restore log, get error message: sql server is stand edit with sp4 Processed 374033 pages for database 'database', file 'log_file' on file 1. ...
insert trigger
Shane Faullin -
9 Mar 2006 8:00 PM - 5 messages
I need to add a trigger to a table to fire when an insert event happens. Basically I need to update 2 columns (employee last name and first) from another table. Something along these lines: UPDATE dbo.test ...
Nonclustered Indexes
g3000 -
9 Mar 2006 7:52 PM - 15 messages
Is this true or false based on reading this: [link] If a table has a nonclustered index AND a clustered index the NONCLUSTERED index will use the clustered index key as a row locater? ...
ASP.net 2.0 Users (aspnet_Users table) create constraint problem
ibiza -
9 Mar 2006 7:41 PM - 2 messages
Hi all, I am using ASP.NET 2.0 Membership system, which is driving me nuts. I have my users, which I create correctly. Then I have a table "Models" which contains models, created by different users. So I obviously need ...
Transaction Logs : strange activity
Matt -
9 Mar 2006 7:28 PM - 2 messages
Hi there, I have a database that processes lots of small transactions (something like 3 million transactions on a daily basis, about a thousand every 6 seconds). If I backed up both log and database every day, the tran log ...
Connection broken
tshad -
9 Mar 2006 7:03 PM - 3 messages
We have added a new firewall to our network and now I keep getting my connection dropped when running from home. Port 1433 is open. I am connecting via a VPN and it was working fine. Nothing has changed in ...
xp_sqlagent_enum_jobs returns an error
casadyc -
9 Mar 2006 6:39 PM - 2 messages
When I execute the following command from QA, I received the error below: exec master..xp_sqlagent_enum_jobs 1, 'sa' Returns: Server: Msg 22023, Level 16, State 1, Line 0 Unable to enumerate Jobs due to failure to obtain serialization object. ...
SqlDumpExceptionHandler - Error
danielTI -
9 Mar 2006 5:39 PM - 9 messages
Hi, I am getting this error all the time. Error: 0, Severity: 19, State: 0 Using 'sqlimage.dll' version '4.0.5' Stack Dump being sent to C:\Arquivos de programas\Microsoft SQL Server\MSSQL\log\SQL01095.dmp SqlDumpExceptionHandler: Process 76 generated fatal exception c0000005 ...
Standby Mode
Kevin Antel -
9 Mar 2006 5:35 PM - 3 messages
Is there a Transact SQL Statement you can use to put a database in Standby/Read-Only mode? Thanks. ...
Cost of Automatically Grow File
Marcos -
9 Mar 2006 5:29 PM - 2 messages
I have an issue about the Automatically Grow File property in the SQL Server 2000. We have a database with 1.3 GB, the option Automatically Grow File is selected growing in 50 Mb. This database keeps the application data about 3 ...
Installing full text index on SQL Server
thoades -
9 Mar 2006 5:16 PM - 4 messages
A couple of years ago our ISP installed SQL Server 2000 single processor licence on our server in their data centre. They omitted to turn on indexing, or install full text indexing. This was fine, but now we need to use it. ...
System Account for SQL
Kane -
9 Mar 2006 5:10 PM - 7 messages
Hi; I have two SQL 2000 servers, Server A and Server B. Currently, the MSSQL service on Server A is set to start up with domain user account not System Account. In this configuration, if we reboot Server A, we have to manually ...
Creating Linked Server into Oracle
Liam Mac -
9 Mar 2006 4:39 PM - 2 messages
Hi Folks, Pretty new to linked servers, however I need to create a linked server from MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already have successfull DTS application which takes info from the Oracle database ...
Log Shipping
Kevin Antel -
9 Mar 2006 4:25 PM - 2 messages
I have setup 2 SQL Servers, 1 is the primary production server and the other is for reporting services. I have the primary server doing log shipping to the reporting server and leaving it in standby mode. Everything seems to be ...
Concurrent Backup/Restores
Rob Diamant -
9 Mar 2006 4:20 PM - 2 messages
Can I have multiple instances of Enterprise Manager running while each one is processing a backup or restore. How will this affect performance. I am trying to restore several large databases and do not want to have to do this ...
How to assign more Operators to a Job failure alert ?
Sameer via SQLMonster.com -
9 Mar 2006 3:40 PM - 7 messages
Hello, I'm using SQL Server 2000 and have defined 3 Operators that need to receive alerts from shecduled jobs. We have chosen to go with 'Net Send' type of alert. Inside each scheduled job, under Notifications Tab, it doesn't give me a ...
Urgent help requested. Query does not return values but they are in table
Bob -
9 Mar 2006 3:15 PM - 5 messages
I have a simple table named Postes the sql statement that my program executes is select * from postes where IdPosteTelephonie = '12345678900' This has worked flawlesly for ages. Now suddenly the statement returns an empty redordset although when I go through the table I can find the record ...
Applying criteria at the start of a series of views
DevalilaJohn -
9 Mar 2006 2:41 PM - 2 messages
I have a series of views that provide a final result set e.g view 5 is select .... from view4; View 4 is select ... from view3 etc. That all works fine, but what this does is include all of the data from ...
SQL 2000 64 bit
Thom -
9 Mar 2006 2:06 PM - 7 messages
Hi We have a proliant DL 585 AMD 64 bit server we installed Windows Server 2003 Ent. and now are trying to install SQL 2000 Ent 64 bit . We contuie to get this error message "setup.exe is valid but is for a machine type other than ...
Profiler Question
John GI -
9 Mar 2006 1:57 PM - 2 messages
I have a query recently converted to a "prepared" statement using ADO property known as Prepared = True. Since I have done that, I cannot see the execution of the SQL statement/prepared SP in the SQL Profiler. This query ...
Rights on sproc with dynamic sql
job -
9 Mar 2006 12:52 PM - 7 messages
I have a sproc z on on which user x has execute rights. The sproc z dynamically builds a sql statement based on input param. The sql quey table y on which user x does not have execute rights. When the sql is executed at the end of the sproc I get an error saying ...
SQL 2005 Express
Wagner -
9 Mar 2006 12:28 PM - 2 messages
Hi all, We are planning to build client/server solution and make it accessible to registered users on Internet. Server side will be built in a form of Windows service that will communicate with clients through custom TCP sockets. Behind windows service there would be SQL Express database for keeping ...
xp_cmdshell in MSSQL2005 return error 1314
stephanie -
9 Mar 2006 9:28 AM - 4 messages
I have followed the step to run - exec xp_cmdshell_proxy_account 'xxxx','yyyy' - enable surface area configuration - grant exec to xp_cmdshell to the sqllogin But still got the error, Msg 15121, Level 16, State 10, Procedure xp_cmdshell, Line 1 An error occurred during the execution of xp_cmdshell. A call to ...
Generate SQL Script
Billy Leung -
9 Mar 2006 8:38 AM - 2 messages
Hi, To generate SQL script, we can right click the database in SQL Server Enterprise Manager. But is there any way that I can schedule to generate this script automatically? Thank you for your help, and any feedback will highly appreciated. ...
SQL Server Msg 3132 on BUCKUP (NOT RESTORE)
yotam -
9 Mar 2006 8:14 AM - 2 messages
I get 3132 error message when I try to backup a database. The explanations for this error message refers to a RESTORE command. I get it on BACKUP. Any idea ? Thanks, Yotam. ...
truncate vs drop and create
ranjitjain via SQLMonster.com -
9 Mar 2006 7:27 AM - 5 messages
In my DW i have few staging tables. Every day i truncate the whole table and loads data into it. Another option is to drop and create the table everyday. 1>What performance gain/impact my sql server will face?----priority question ...
Help, please, corrupted db with error when recovering
Yifei -
9 Mar 2006 5:08 AM - 5 messages
Dear All, A dabase index corrupted yesterday, and then we restore the database from yesterday early morning with norecovery option, when I try to restore log, get error message: sql server is stand edit with sp4 Processed 374033 pages for database 'database', file 'log_file' on file 1. ...
Problem with instalation of PS2003 on SBS2003
Filip - beginner -
9 Mar 2006 4:30 AM - 2 messages
I'm trying to install Project Server 2003 under SBS 2003. I'm doing it as in this document: [link] and something's wrong. After I finish when I click on PWA link it's showing me ...
SQL hash tables
Roger -
9 Mar 2006 1:43 AM - 3 messages
I am currently using VB6 & MySQL for an application, but I have been trying out the Express editions of VB.NET 2005 and the Express SQL server. In my applications I make extensive use of MySQL hash tables, fast memory ...
Touching UDF Fixes Performance Problem
David Sullivan -
9 Mar 2006 1:12 AM - 3 messages
Hi all, I would like to relate a strange performance problem we have had lately. I would be very interested to know whether anyone has encountered a similar situation. I work in the technology area of a large enterprise. We host a public-facing ...
Oracle linked server tables
Randall Arnold -
8 Mar 2006 11:28 PM - 13 messages
I've successfully linked 2 Oracle 9.2 databases to my SQL Server 2005 Standard edition installation. I can construct and run queries as long as I know the table names and schemas. However, tables for the linked servers are not readily visible. Is there ...
Instead Of trigger not firing After trigger
JayCallas -
8 Mar 2006 11:07 PM - 4 messages
According to the documentation I read, an INSTEAD OF trigger basically rolls back the original transaction and performs whatever is coded in it. Normally, an INSTEAD OF trigger will not cause any AFTER triggers UNLESS the INSTEAD OF trigger executes any DML statements on the ...
Find Views with NOEXPAND
Daniel Jameson -
8 Mar 2006 11:03 PM - 2 messages
Hi, Anyone out there know how to tell whether a view uses the WITH (NOEXPAND) hint (other than searching the syscomments table for 'NOEXPAND')? ...
xp_test_mapi_profile failed with mail error 0x80040106
Sabian -
8 Mar 2006 10:55 PM - 2 messages
After a while, SQL Mail "loses" the mapi profile and I have to reboot the server in order for things to start working again. I receive the error listed in the subject line and can't find any information regarding this at all on ...
Backup
George Schneider -
8 Mar 2006 9:52 PM - 4 messages
I'm not sure if I'm doing this correctly to ensure recovery in case of a disaster. I have a SQL 2000 Sp4 server, this server has not tape drive attached to it. What I'm doing is during the night I run a backup through a ...
scheduling a query
Simone -
8 Mar 2006 9:22 PM - 4 messages
I need to scheduling a query to update some records. I have to use a script in windows task manager or there is another way? Many Thanks ...
How to add the lost keys
ad -
8 Mar 2006 9:13 PM - 2 messages
There are four areas in my compay: E, W, S, N. When I use aggregate function to count to order number of each area, there maybe some area disappear in the result, like select Area, Count(*) from orders Area OrderCount ...
xp_fixeddrives across a linked server
Jeffrey K. Ericson -
8 Mar 2006 9:01 PM - 3 messages
I am trying to populate a table with the results of xp_fixeddrives. I have a cursor that pulls a list of servernames from a table and generates dynamic SQL to run servername.master.dbo.xp_fixeddrives. It works dandy by itself but ...
Change temporary tables location
Ravi Ambros Wallau -
8 Mar 2006 9:00 PM - 3 messages
Hi: I was wondering if it is possible, in SQL Server, change the database where temp tables are generated by default. I know that temp tables are generated on tempdb, but this is very bad ...
index included column help other indexes lookup?
tin -
8 Mar 2006 8:59 PM - 3 messages
example: table: employee (name, age and gender) indexes: age and gender query: select name from employee where age = 30 and gender = 'm' question: when i create the index on the age column, would including the gender column makes the query faster? or including the age column in the ...
where is the temporary table created by sp_helprotect?
bing -
8 Mar 2006 8:31 PM - 4 messages
Hi, Looking at the source code of sp_helprotect, I noticed it has CREATE Table #t1_Prots If sp_helprotect does not do 'DROP Table #t1_Prots', where is table #t1_Prots saved? I cannot find it in any database. Thanks, Bing ...
Can't create a Maint Plan in 2005
UJ -
8 Mar 2006 8:21 PM - 2 messages
I am trying to create a maint plan in 2005 and no matter what types of things I tell it to do, when it goes to create the plan I get the following error message: Create maint plan failed. Additional information: ...
Unable to change Table
Calvin Willman -
8 Mar 2006 7:42 PM - 3 messages
I'm unable to set the identity specification to true, for an nvarchar column in a table, using either VS2005 or the Management Studio. I want it to hold unique values, and don't know why this is happening. There ...
Temp DB use and query Evaluvation Question
bluefish -
8 Mar 2006 7:41 PM - 2 messages
Dear All, Does SQL server store the intermediate results set in the tempdb? One of the team members has dropped the indexes for our one large table. I was running a query that has multiple joins (including this table) , and this caused tempdb ...
Cycles or multiple cascade paths
Leila -
8 Mar 2006 7:26 PM - 2 messages
Hi, How does Child table cause cycles or multiple cascade paths? Why it cannot be handled by SQL Server? USE TempDB GO CREATE TABLE Parent( Col1 INT PRIMARY KEY ) GO CREATE TABLE Child( Col1 INT REFERENCES Parent(Col1) ...
DDL Trigger to update Instead Of Insert trigger
Peter Gloor -
8 Mar 2006 6:48 PM - 2 messages
Hello NG, In order to prohibit users from updating a CreationDate I have a database with an Instead Of Insert trigger on several tables. To make life easier I created a stored procedure called UPDATE_IOI_TRIGGER which recreates the Instead Of Insert trigger for a given table and adds/removes new/deleted ...
Random SQL Server 2000 Reboots, Slow performance
dhruv.gaur -
8 Mar 2006 5:08 PM - 3 messages
We recently upgraded our SQL Server from 7.0 to 2000. We did not upgrade or make changes to the server hardware. Lately the server decides to reboot itself at random. The number of users or workload has not changed since or before the upgrade. Before each reboot the ...
grant the privilege of create user to other users
hongo32 -
8 Mar 2006 4:30 PM - 2 messages
Hi, in sql server 2000 for create a login I use the command sp_addlogin but if i connect to sql server with a user that not is 'sa' or trusted connection and execute addlogin the server shows that i don't have ...
SELECT @@SERVERNAME
Whispering Leaf -
8 Mar 2006 3:54 PM - 3 messages
Why does this query return NULL? It only happens on one of our SQL servers. Thanks. ...
Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?
Spin -
8 Mar 2006 3:53 PM - 2 messages
Hi, I can't seem to find the download link for SQL Server 2000 Reporting Services from my SQL 2000. Where is it? I feel like an idiot. ...
Monitoring Query Performance
Simon -
8 Mar 2006 3:25 PM - 2 messages
Is there any table in SQL Server 2000 which lists the queries currently cached in memory and statistics on those queries e.g. execution time, number of executions cost, etc. I would like to be able to determine the queries ...
SQL Server and Dual Core
maltistefan -
8 Mar 2006 2:22 PM - 2 messages
Hello, My BizTalk 2004 client is considering the option of using 2 servers of one processor dual core instead of 2 servers of 2 bi-processors. This option is also considered for the SQL Server that is used in the ...
Maintenance Plan DB Integrity Job Failed
Joe K. -
8 Mar 2006 2:07 PM - 5 messages
I created a SQL Server 2000 database maintenance plan with the wizard. I selected integrity checks and complete backups for my database and completed the requiremenents. I received the following error listed below. Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] ...
Articles on performance comparisons of sql2k5 on x32 and x64
Kevin Jackson -
8 Mar 2006 1:59 PM - 2 messages
We are looking for performance comparisons between SQL Server 2005 x32 and x64. Any out there? ...
Set default SQL Server-instance
Thor W Hammer -
8 Mar 2006 1:07 PM - 7 messages
We had SQL Server 2000 as the default sql server instance on a machine. Now we have installed a SQL Server 2005 under the instance name sql2005. We are able to connect to the new sql server instance by postfixing the host ...
MS SQL Developer Edition vs MS SQL Production Edition
Björn Pettersson -
8 Mar 2006 12:59 PM - 3 messages
Hi, I am not very knowledgable of the MS SQL Server 2000 product range, but according to a developing team we are in contact with, they have an application experiencing long query times when several users are performing queries against their MS SQL Server, which is a Developer Edition version of ...
HELP! Linked Server Problem
Howard Carr -
8 Mar 2006 12:17 PM - 5 messages
I have a SQL 2000 instance on a 32 bit Win2000 server and a SQL 2005 instance on a 64bit Win 2003 Server. Both systems are using the same user id & password. Both instances use windows authentication mode. In the SQL Server Enterprise Manager on the SQL 2005 instance I created a ...
Failed to reserve contiguous memory
St.John -
8 Mar 2006 12:15 PM - 3 messages
we have a cluster of 2 nodes running Windows 2000 SP4 with SQL Server Enterprise Edition SP3. There are 4 instances installed with 2 instances on each node. We have started to have a problem over the last 2 weeks where jobs are ...
|
|||||||||||||||||||||||