Need Help : SQL Server And Clear Case
Aug 25, 2005
Environment
1)We are using VBA,MS Access 2000/2003 and SQL Server 2000 in our
project.
2)We need to use Rational clear case as the SCM tool.
Our Work
Our work primarily falls in developing SQL Server stored procedures,
functions and few VisualBasicForAccess(VBA) code.
Technical Help sought
1) Does SQL Server 2000 provide any inbuilt capabilities of Software
Configuration Management(SCM)?Not that I am aware of other than
extending it with other DM management tools like BMC,A&G,VERITAS etc.
2)If not, Is there any plug-in available in SQL Server environment that
can be installed on SQL Server so that any code developed [Stored
procedures/functions etc] can be managed in Clearcase.[I am looking for
Eclipse plugin's kind of plugins which would enable you to check in and
check out from Eclipse after the initial configuration is done on
Eclipse]?
3)If plugins are not available then the option we have is, manual and
external check in and check out the code bits in to Clearcase.Can some
one point me to concise and relevant user manual on this.
View 2 Replies
ADVERTISEMENT
Apr 8, 2008
Hi is there a way of clearing the server names from the management studio?
i found the below on the net but i do not have this file to delete?
“All you have to do is delete C:Documents and Settings<user>Application DataMicrosoftMicrosoft SQL
Server90ToolsShellmru.dat.�
View 5 Replies
View Related
Apr 5, 2004
I have an application that allows users to "reserve" a certain time and location for practice sessions. I want them to look at a web form that shows which times are available and then allows them to select an open slot and then submit this form with some personal information. My problem is that as soon as they select an open slot, other users should see that this slot is no longer available. On the other hand, if someone selects an open slot and then takes too long to type in their personal information, I want it somehow to kick them out and re-open this slot back up.
I know that I can create a field called 'status' in my database that gets turn to something like 'pending' as soon as the first user clicks on an open slot, but how would I turn this field back to the 'open' state if the user took too long to enter their data?
Any help would be surely appreciated.
Cheers,
AzF
View 1 Replies
View Related
Nov 3, 2004
how i can clear sql server logs by run xp_cmdshell stored procedure.
(my user in sql server is a admin).
i don't want use enterprise manager . i want write a query and use at xp_cmdshell .
befor thx.
View 1 Replies
View Related
Dec 25, 2007
Dear Supports,
I have database written in SQL SERVER 2005 since last two year .Now the Database size become 33MB, and the log file become 450 MB . The log file is too large for me . Do you any know how clear the log file in SQL SERVER 2005 EXPRESS SP2 ?.Thanks
Best Regards,
Channarith Hun
View 3 Replies
View Related
Dec 27, 2007
Dear Friends,
Now i am using Sql Server 2005 Express Editon SP2 to store data . Now the log file of this database is too big that use alot of disk space around 500MB . Now i want to clear this log file .do any one know how to clear this log file in the sql server 2005 express edition SP2 .
I hope you all friends will help me to solve this problem .Thanks
Best Regards,
Channarith Hun .
View 9 Replies
View Related
Aug 31, 2015
How can I change my T-SQL text editor from text sensitive to text insensitive?
View 2 Replies
View Related
Jan 6, 2005
Hello:
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?
View 4 Replies
View Related
May 4, 2007
Can 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.
View 3 Replies
View Related
Aug 17, 2005
We 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 Related
Jul 20, 2005
Yesterday I received a response to my CI/CS Collation problem and therecommendation was to try and restore a CI Collation database to a CSCollation database. After creating a blank CS database a full restore(Force restore over existing database) does change the Collation toCI. I'm unsure as to how I can restore without changing theCollation. Any suggestions?
View 2 Replies
View Related
Jul 23, 2005
hi thank you for this solution Hugo (dutch?) and it's very handy, thankyou but my issue is that we created dozens of views with my function.This functions returns an integer of a date. This function has to give alowerlimit and higherlimit back when dates are out of Calendar range.But i want to read this from the Calendartable ONCE and store it in aglobal variable somewhere in SQL Server. I DON'T want to referencetables in my function. SO read once the lower- and upperlimit and usethis variable/property for referencing in my function!!GreetzHennie*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 11 Replies
View Related
Jul 10, 2006
Is there a way to clear all the records in a table in Microsoft SQL
Server Management Studio instead of selecting all the rows and delete?
View 12 Replies
View Related
Sep 20, 2002
I'm trying to clear a database transaction log that has gotten much too large. I backed it up hoping that this would clear the "active" log, but now I just have two copies of a huge transaction log. How do I clear the active log?
Thanks in advance.
View 4 Replies
View Related
Sep 25, 2003
Hi....Does anyone know if there is a similar command to SQL2K's DBCC ERRORLOG.
I'm currently writing a preventative maintenance script and want to force archiving of errorlogs. Any help greatly appreciated.
View 3 Replies
View Related
Feb 10, 2006
It's been some time since I've written any SQL so I apologize if the answer to my question is obvious.
In pseudo-code here's what I want to do:
delete from table-1 all rows where the table-1.id = table-2.id and table-1.text = ""
Thanks in advance.
View 4 Replies
View Related
Dec 14, 2006
How do u clear Cache in SQL
if i run a query once it takes 10 seconds and if i run the same query again it takes 1 second because it is cached. So i want to know how i can clear it because i want do some benchmarking on a query that is in cache
View 5 Replies
View Related
Apr 8, 2008
does anyone know how to clear the sql "connect to server" popup server name list
View 13 Replies
View Related
Jan 15, 2006
Hello guys!
I would like to clear the logfile. Could anybody tell me how to do this?
What I would like most would be to run SQL-Server without any log-file (while development). But I suppose that this is not possible.
Regards,
Fabian
my favorit hoster is ASPnix : www.aspnix.com !
View 3 Replies
View Related
Apr 7, 2007
Hi, my database i am working on is full of crab, who do I clear all the tables info?
View 3 Replies
View Related
Mar 3, 2008
what is the command using to clear the content of log file
View 2 Replies
View Related
Jul 20, 2005
select *From titles(18 row(s) affected)Totally 18 records are there in Titles table.When I queryselect title,title_id From titles where title like 'T%' and title_idlike 'M%'It is returning 2 records.So,now if I introduce a not in 2 places also it should return 16records.Whereas it is returning 14 records. What is the bestway to understandthis.select title,title_id From titles where title not like 'T%' andtitle_id not like 'M%'ThanksGanesh
View 2 Replies
View Related
Apr 14, 2004
I have a dataBase named pricesDB. I would like to clear all the prices column everyday at midnight.
How should i do that???
View 1 Replies
View Related
Oct 25, 2000
When I backup a my transaction log and then run DBCC SQLPERF(logspace) the log shows 12% space used. The backup was run at night long after any transactions had been executed so there should be no active transactions. In SQL 6.5 you could run DBCC CHECKTABLE(syslogs) to clear up the usage inaccuracy is there a similar command in 7.0 to fix the space usage inaccuracy?
--Buddy
View 4 Replies
View Related
May 18, 2008
I practiced log shipping in my home PC. It works fine. But there are 3 error dialog box populated for every 15 minutes. I enclosed screen shot.
1. DW20.Exe Application Error
2. Visual Studio just-in-Time Debugger
3. Sqllogship.exe Application Error
I got this error every 15 minutes. I delete everything such as maintenance plan jobs, replication, log shipping, mirroring in my SSMS. I can't find out the solution for this error. I didn't know, how to resolve this problem.
Please advice. :eek:
Thanks
Jayasri
View 5 Replies
View Related
Feb 28, 2006
What is the best way to empty out a table to reset its identity field back to 1?
I was going to do "Generate SQL Script" for all the tables I wanted to reset and then drop and re-create each table. Is there a better way to empty out all of your tables?
View 20 Replies
View Related
Apr 5, 2006
hi
I would like to clear all data in a table called ... How do I do that - and before I do it I'd like the data copied to a another table as a backup .... Please guide me .....
Thanks in advance .....
View 3 Replies
View Related
Feb 13, 2007
Hi
How to clear the Transaction Log of Tempdb?(Other than Restarting the SQL server)
Thanks in Advance
Regards
Magesh
View 2 Replies
View Related
Oct 16, 2007
Hi,
I had deleted the login and user in my SQL 2005 database. However, each time when i connect to my database using the SQL enterprise manager, I can still see the deleted username under the login. It seems that the username is stored or cache somewhere after the first time that I have login. Does anyone know how to clear it? I am using SQL 2005 authenication method on 2003 Server machine. Thanks.
Regards,
View 14 Replies
View Related
Oct 5, 2006
Is there a simple method to clear all the tables in a db or to make a copy of the mdf file without the datas ?
I tried to use TRUNCATE TABLE but it doesn't work with foreign keys ?
Thanks.
View 1 Replies
View Related
Dec 5, 2007
We want to back up our test db (new application) and then put it back on the box. The transaction log is pretty full (600mb), can I clear this file or delete the data in it -- we do not need it since this is all testing data.
Thanks,
anke
View 1 Replies
View Related
Sep 30, 2006
I'm writing a web application that saves data to a Microsoft SQL database. As I build my application, I continually dirty my database with test data and refine my data schema. Is there a tool that can quickly remove all of the data from 4 of my 5 tables? Right now I'm using MS SQL Server Management Studio Express to open each table and manually deleting the rows of data and it's a pain in the ass. Playing around with the Management Express, I was able to generate a create SQL script (I'm afraid to test it though) that looks like it will rebuild my table. The problem is, one of my tables is a list (index?) of types...and I'd need that data saved
ebuilt each time...but I cannot figure out how to tell SQL that the rows in this table needs to be rebuilt (and is not really data per say).How do you guys "clear" or reset your database during development?-=STZ=-
View 2 Replies
View Related
Jun 2, 2000
how do I clear sql 7 logs they are full and I am stuck?
thanks you
View 3 Replies
View Related