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

Clear Server List

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

Can I Have SQL Server Clear A Value After A Certain Amount Of Time?

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

Clear SQl Server Logs By Run Xp_cmdshell

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

How To Clear Log File In SQL SERVER 2005 EXpress SP2

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

How Can I Clear Log File In MS SQL SERVER 2005 Express Edition SP2

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

SQL Server 2008 :: Change Text Format From Case Sensitive To Case Insensitive?

Aug 31, 2015

How can I change my T-SQL text editor from text sensitive to text insensitive?

View 2 Replies View Related

Case Insensitivity Is On Server Wide: Tables Render Case Sensative...

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

Case Insensitive Searching In Sql Server 2000 When It's Case Sensitive

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

HELP! Case Insensitive Database On Case Sensitive Server

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

Restore Of Case Insensitive Database To A Case Sensitive Database - SQL Server 2000

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

Still Not Clear

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

How To Clear Table?

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

How To Clear Transaction Log

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

Clear Errorlog In SQL 6.5

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

Help Me Clear The Cobwebs

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

How Do U Clear Cache In SQL

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

Clear List

Apr 8, 2008

does anyone know how to clear the sql "connect to server" popup server name list

View 13 Replies View Related

How To Clear The Logfile

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

How To Clear The Whole Databse?

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

Clear Log File

Mar 3, 2008

what is the command using to clear the content of log file

View 2 Replies View Related

Not Clear About This Query

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

Clear DB Fields At Midnight

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

Log Dump Does Not Clear Log Space

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

Clear Log Shipping History

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

How Do You Clear Tables Of All Data?

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

Clear Data In A Table

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

How To Clear The Transaction Log Of Tempdb?

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

How To Clear SQL Authenication Username?

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

Clear All The Tables Of A Database

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

How Do You Clear/ Empty The Transaction Log

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

How To Clear Or Reset A Microsoft SQL Database?

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

How Do I Clear Sql 7 Logs They Are Full And I Am Stuck?

Jun 2, 2000

how do I clear sql 7 logs they are full and I am stuck?

thanks you

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved