CASE Resource Info
May 2, 2001What are some good CASE programming to use in comjuction with SQL 7. What are some good resources for researching. Also, are there any good DB confrences coming up?
View 1 Replies
ADVERTISEMENT
Is There A System Table With Timestamp Info Or DTS Job Info?
May 7, 2007I want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn't work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.
ddave
Resource Limits ??
Apr 11, 2007In Oracle & Sybase you can set login resource limits to restrict, time of day, number of i-o's, cpu use etc for any login, at the login method. All actions done from a resource limit constrained login inherit the constraints.
Is there any way to implment this with any MS SQL Server version from 200-2005/SP2?
Before anyone answers, please do not suggest set rowcount etc.
thanks.
Resource DB Path
Apr 14, 2008How to find the physical path of resource db files from SSMS query?
------------------------
I think, therefore I am - Rene Descartes
Deadlock Resource ID
Mar 4, 2008I have a deadlock chain that shows 9 parallel insert jobs into the same table. The resource that is locked (with an exclusive lock) shows a HOBT_ID...which corresponds to a clustered index.
My question is how would INSERT statements cause a whole index to lock (there is no TABLOCK hint).
Resource Files In A Rdl???
Feb 25, 2008Hi,
I would like to know witch is the best practices to make a .rdl file multilenguaje, that is, that the same .rdl file shows the text €œAmount€? on a label when the user is English or the text €œCantidad€? when the user is Spanish.
There are not something like the resource files in the in a VS.NET web application????
Thanks,
SSIS Resource
Nov 9, 2006Hi Community:
I am new to SSIS, and have been struggling recently with SSIS development. I would like to find out if there are some good books out there on SSIS besides, the online resources, and BOL. Possibly a good book or tutorials. Thanks.
MA
Resource Files In A Rdl????
Feb 25, 2008Hi,
I would like to know witch is the best practices to make a .rdl file multilenguaje, that is, that the same .rdl file shows the text €œAmount€? on a label when the user is English or the text €œCantidad€? when the user is Spanish.
There are not something like the resource files in the in a VS.NET web application????
Thanks,
SQL Server 2008 :: Change Text Format From Case Sensitive To Case Insensitive?
Aug 31, 2015How can I change my T-SQL text editor from text sensitive to text insensitive?
View 2 Replies View RelatedCase Insensitivity Is On Server Wide: Tables Render Case Sensative...
Jan 6, 2005Hello:
I have created an SQL server table in the past on a server that was all case sensative. Over time I found out that switching to a server that is not case sensative still caused my data to become case sensative. I read an article that said you should rebuild your master database then re-create your tables. So after rebuilding the master database, a basic restore would not be sufficient? I would have to go and manually re-create every single table again?
Any suggestions?
I Need To Locate The MS SQL Server 7 Resource Kit
Dec 14, 1999How can I get my hands on the Microsoft SQL Server resource kit?
In particular, I need the "Load Simulator" application.
Any information would be greatly appreciated.
Jim
Cursor Resource Usage
Jun 16, 2000I use cursors inside stored procedures, they are generally 20 - 50 records. I have been told that cursors are very resource intensive. Am I setting myself up for scaling problems when we have hundreds of users all running these procedures? The cursors are only used within the context of the stored procedure. Any opinions/insight on this would be appreciated.
Mike
Resource Problem With Cursor --&> Help
Mar 26, 2003I'm attempting to update a table of around 100,000 records with a table of 20,000 records using a cursor since the update is based on a row by row criteria. When doing this I'm getting an error
--Resource is low some results are dropped--
I then cut down the table with 20,000 to a table of 5,000 and still get the same error. I've also tried to use a fast_forward cursor but still no luck
Can any-one help. I know there is a way to do this using a quick update statement but I need to know this for other insert statements anyway.
Help Help
Instance Will Not Come Up After Moving Resource Db
May 20, 2008after moving the resource database files with this command:
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=data, FILENAME= 'new_path_of_mastermssqlsystemresource.mdf');
GO
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=log, FILENAME= 'new_path_of_mastermssqlsystemresource.ldf');
GO
I am getting this error trying to do anything in the instance while I have it started in minimal mode (/f /t3608)
(the instance WILL NOT COME UP UNLESS I USE THE /F /T3608 from a command promt.. please .. any suggestions??????????????????????
Also.. I checked and the primary file is NOT READ-ONLY.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 945, Level 14, State 2, Line 1
Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Resource Accumulation On SQLServer
Jul 20, 2005We have a JDBC project that works with SQLServer, along with otherDBs. During development, we noticed that resource useage on SQLServerseemed to grow steadily - Processes, Process Locks and/or Object Locks,according to the "Current Activity" section of Enterprise Manager.Fairly quickly (a few hours), SQLServer would use so many resources itused up all available system memory and the system would crash.Without understanding much about why that was happening, mostly out oftrial and error, we started using transactions, which seemed to fix theproblem. Now, one of our customers seems to be seeing the problem again:511 Process Locks, 18 Object Locks, 526 Processesafter a few hours. The system runs out of memory and crashes. We havemultiple test configurations, including Linux, Win2K, XP, but we donot see the same behaviour - we typically see no more than 20 or 30processes, process locks or object locks, and our tests seem to runindefinitely. Since we can not reliably reproduce the symptoms that ourcustomer sees, it is very difficult for us to analyze, let alone, fixthe problem.Does anyone - especially SQLServer pros - have any insight as to what isgoing on here and/or how to fix it? Like how does a process, processlock or object lock relate to JDBC? process <-> connection,object <-> row, table... or what, locks?Thanks,Gary WhittenJoin Bytes!
View 2 Replies View RelatedPooled Resource Clustering
Mar 10, 2008Dear All,
Just downloaded a not too great white-paper (sponsored by HP) called SQL Server Infrastucture Optimaztion and it had a brief but eye catching section on something called 'Pooled Resource Clustering'. See below
Pooled-Resource Clustering
Pooled-resource clustering is a combination, of sorts, of Windows clustering and virtualization.
Essentially, it€™s a means of allowing SQL Server instances to become €œvirtual SQL Servers€? in
the sense of true VMs. They€™re encapsulated and can be easily and quickly moved between
physical computers. It borrows concepts from Windows clustering but does so with a crucial
difference that eliminates the resource management overhead that comes along with Windows
clustering. Another term for this technique is shared storage clustering.
Technology Overview
With pooled-resource clustering, a cluster of servers€”which can all have different hardware
specifications€”are connected to a single, shared storage system (typically a SAN). By
leveraging a Windows-based cluster file system, each of the nodes in the cluster can €œsee€? the
same storage area. That is, they all have (for example) an S drive,
I googled this and can't find any more about it. So my question is simple can anyone provide more info about this method. I tried tried the authors web site burt its all sales info address(
On the surface this seems a bit of a hack to me?
Thanks
Simon
System Resource Database
Jun 29, 2007I have a 2005 server that is upgraded to SP2 and the error log indicates it is version 9.00.3042.00. However, the system resource database for the same server is reporting as version 9.00.2047.00. From another post I have found out the some replication problems I am having are due to this discrepancy.
I have reapplied SP2 hoping it would change the resource db version, but it did not. Is there another way I can upgrade the resource db without re-installing SQL from scratch?
Thanks!
Great New Learning Resource
Mar 30, 2007 We've been working hard with our teams here to get better/more/good information out to our users. We€™ve created a new a customized Windows Live search, that limits results to Books Online. Check this out, and make sure you let your contacts know to visit it and provide feedback:
http://search.live.com/macros/sql_server_user_education/booksonline
We want to generate as much traffic as possible here so that we can see if this is useful to our users. We€™d love to hear back from everyone we can!
Data Mirror Resource
May 21, 2006Are there any good resources for data mirror in SQL 2005 SP1?
I tried to search on microsoft.com, there is an article, but it is outdated, it only described data mirror in SQL 2005 RTM.
appreciate any links or input.
Owen
Video Resource Not Found
May 17, 2007Hello All,
I was watching Bob Tabor's SQL Server 2005 Express for Beginners videos from the ASP.net 2.0 website http://www.asp.net/learn/videos/default.aspx?. In lesson 5 Manipulating the Database Data he refers to download the sample database SQLVideoResources.zip file from the above website.
I searched and did not find it. Can anyone please direct me?
Thanks,
Using Resource Files In SSIS
May 13, 2008Hi,
I am using SSIS for sending E-Mails based on certain transactions in SQL Server. I need to dynamically populate the E-Mail content as the content some times needs to be in Japanese text. I would like to use resource files for this. Could anyone please help me on using resource files in SSIS.
Thanks in advance.
Problem With Resource Database
May 20, 2008
after moving the resource database files with this command:
Code Snippet
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=data, FILENAME= 'new_path_of_mastermssqlsystemresource.mdf');
GO
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=log, FILENAME= 'new_path_of_mastermssqlsystemresource.ldf');
GO
I am getting this error trying to do anything in the instance while I have it started in minimal mode (/f /t3608)
(the instance WILL NOT COME UP UNLESS I USE THE /F /T3608 from a command promt.. please .. any suggestions??????????????????????
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 945, Level 14, State 2, Line 1
Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
DB Engine :: How To Get Resource Consumption
Sep 29, 2015I got a task to get resource consumption (CPU, storage etc.) for stored procedures in certain database. I found nice script ([dbo].[usp_Worst_TSQL]) but looks like script written for SQL 2005 and we use SQL 2012.how to get resource consumption details.
View 9 Replies View RelatedCase Insensitive Searching In Sql Server 2000 When It's Case Sensitive
May 4, 2007Can someone point me to a tutorial on how to search against a SQL Server 2000 using a case insensitive search when SQL Server 2000 is a case sensitive installation?
thanks in advance.
HELP! Case Insensitive Database On Case Sensitive Server
Aug 17, 2005We need to install CI database on CS server, and there are some issueswith stored procedures.Database works and have CI collation (Polish_CI_AS). Server hascoresponding CS collation (Polish_CS_AS). Most queries and proceduresworks but some does not :-(We have table Customer which contains field CustomerID.Query "SELECT CUSTOMERID FROM CUSTOMER" works OK regardless ofcharacter case (we have table Customer not CUSTOMER)Following TSQL generate error message that must declare variable @id(in lowercase)DECLARE @ID INT (here @ID in uppercase)SELECT @id=CustomerID FROM Customer WHERE .... (here @id in lowercase)I know @ID is not equal to @id in CS, but database is CI and tablenames Customer and CUSTOMER both works. This does not work forvariables.I suppose it is tempdb collation problem (CS like a server collationis). I tried a property "Identifier Case Sensitivity" for myconnection, but it is read only and have value 8 (Mixed) by default -this is OK I think.DO I MISS SOMETHING ????
View 4 Replies View RelatedDoing A Case-sensitive Query In A Case-insensitive Database
May 29, 2008I am working in a SQL server database that is configured to be case-insensetive but I would like to override that for a specific query. How can I make my query case-sensitive with respect to comparison operations?
Jacob
Transact SQL :: Upper Case To Lower Case Conversion
May 4, 2015I have column with value of all upper case, for example, FIELD SERVICE, is there anyway, I can convert into Field Service?
View 7 Replies View RelatedPerforming Backups Using Network Resource
Sep 16, 1998I`m having difficulty performing a SQL dump using a network drive. I have successfully created a backup device on a network drive but when I go to perform a backup using it I get the following error message: "Can`t open dump device `RSS4DATARSA3_Dump.Dat`, device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)" I can successfully perform a backup using a local drive but not this network drive. I have checked the permissions on the network drive and is seems ok. I use the following command to try to perform the backup: "DUMP DATABASE RSA3 TO DISK = `Rss4DataRSA3_Dump.Dat WITH STATS = 10, INIT". Any help would be most appreciated. Thanks in advance!
View 2 Replies View RelatedUnable To Load Bcp Resource DLL. BCP Cannot Continue
Nov 30, 2006I get the message when loading the bcp. I check the path variable and the sqlserver BINN directory is there, but twice. If I try opening the command window and write bcp, I get the error, if I enter the whole path c:...80 oolinncp there is no problem. I wonder what could it be?
I've manually reinstalled many times but still having trouble.
Thanx in advance
SQL SERVER 2000 or SQL SERVER 7 (I've tried with both)
WINDOWS XP
Instance Will Not Come Up After Moving Resource Db Files
May 20, 2008after moving the resource database files with this command:
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=data, FILENAME= 'new_path_of_mastermssqlsystemresource.mdf');
GO
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=log, FILENAME= 'new_path_of_mastermssqlsystemresource.ldf');
GO
I am getting this error trying to do anything in the instance while I have it started in minimal mode (/f /t3608)
(the instance WILL NOT COME UP UNLESS I USE THE /F /T3608 from a command promt.. please .. any suggestions??????????????????????
Also.. I checked and the primary file is NOT READ-ONLY.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource .ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource .ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 945, Level 14, State 2, Line 1
Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
SQL Server ODBC Driver Resource
Feb 5, 2004Unable to load SQL Server ODBC driver resource DLL. The application cannot continue.
Can you help me ? I already update my driver ...
regards
What Is The Use Of Resource And Distribution System Database
Dec 10, 2007Hi All,Can anyone explain me, why we have Resource and Distribution SystemDatabase in SQL Server 2005. Whether they were also available inprevious versions also.Thanks in Advance.Regards,Om
View 1 Replies View RelatedOPENROWSET System Resource Exceeded
Apr 12, 2008
Hi, I am using OPENROWSET command to read from a dbf file in Transact-SQL of SQL Server 2005. Query runs fine for a few tries after that i get the error:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Text Driver] System resource exceeded.]
If a restart the Server everything works fine, but then the problem starts again. I saw a related postinf with no
acceptable answer, unfortunately.
Thanks in advance,
--Dimitris Doukas