CREATE PROCEDURE USP_BOOM_DATA

AS

DELETE FROM TABLE_NAME1

DELETE FROM TABLE_NAME2

.

.

.

.

DELETE TABLE_NAME100

after that you can call this procedure

EXEC USP_BOOM_DATA

But if you have the table with Primary Key and it's sure that you...

Interesting your mdf file is 38 ~ 39 MB and your C drive is out of space so the D drive has 170 GB!!! What do you have in...

Check the Shared Memory is enable in your SQL Server Configuration Manager

Start->All Programs->Microsoft SQL Server 2005-> Configuration Tools -> SQL Server Configuration Manager and click Protocols for your_server_name and you...

sreevani.chireddy (7/17/2008)

---

Hi, I'm having trouble to access my DB(SQL server 2005). I prefer to use SQL Server Authentication over windows Authentication. The problem I'm facing is that...

GilaM thnx for alternatives!

:hehe:

You can use system procedure, it shows the information about login name, host name instead of IP address, also in which DB etc etc!

sp_who ( it has info what command...

Here I agree with Jeff ( his is also SQL Server MVP), he writes the very professional code how to do it without PIVOT and simply you do not need...

Another important thing to know is that I'm trying it in Oracle 8i - but not working! Is it any reason for the Oracle version!

Dugi

richard.clarke (7/9/2008)

---

Hi

Sorry about the original SQL, it was using MS SQL syntax and not Oracle. Anyway try this. I tested this on Oracle Express 10 and it looks...

I forget it to post reply, I tested today and it works very fine!

Also I changed and I tested with function TO_CHAR, but not working the wrong things was [...

hmm can you explain how did you do shrinking the log file till you said that you detach the DB!?

:w00t::w00t:

Hi Jeff!

Your code here just selecting and ordering asc the data inside the table it doesn't do any elimination of duplicate records!

Can you explain little bit this!

Dugi

Ooppsss I didn't see in which forum we are discussing ... sorry!

I posted the technique for the SQL Server 2005!

there is one of the solutions:

you should add the column as...

Swamy seems to be very professional for T-SQL! This code is very profi!

:w00t::w00t::w00t::w00t::w00t:

Hi,

First of all you will do a full backup of you db or make a copy of your db as you want!

than try to change the compatibility level from 90...