Database

Debugging in Sql Server 2005

29-Dec-06 4:25

lehya wrote:
I hope its expiry date is on..

What expiry date?

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

coolestCoder29-Dec-06 2:58

coolestCoder

29-Dec-06 2:58

Hi All,
I want to debug a stored procedure in Sql Server 2005. But no option is available for this. I read somewhere that Business Intellegence Development Studio is required. So i tried to install it. But the setup application gave a message that the studio is already installed. Then i read somewhere that VS.Net 2005 is the BIDS. I already have VS.Net 2005 installed on my machine along with SQL Server 2005. But the "Step into Stored Procedure" option is not available under vs.net 2005.
Hope i am clear enough. I just want to enable debugging in Sql Server 2005, if possible without depending on VS.Net 2005.

Thanks !

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

VK-Cadec29-Dec-06 3:21

29-Dec-06 3:21

Hi - You do need the SQL Server Business Intelligence Development Studio to debug stored procs - which is a part of SQL Server 2005.

I have used this feature and it is very, very helpful in debugging stored proc by stepping into them.

Vani

coolestCoder29-Dec-06 3:32

coolestCoder

29-Dec-06 3:32

Hi !
I already have VS.Net 2005.
Now i have the BIDS installed.
But i am new to BIDS.
Can you explain in detail how can i debug a Store Procedure using BIDS ?
It is very urgent.

Thanks.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

VK-Cadec29-Dec-06 3:39

29-Dec-06 3:39

Open BIDS
On top icons - select tools - connect to the database where sp exists.
Go to the location where sp is - right click on sp and step into the Stored proc.
You can provide the input string and set up break points - kind of similar to debugging in VS-2005

Hope that helps.

coolestCoder29-Dec-06 3:44

coolestCoder

29-Dec-06 3:44

I tried what you told. There are a few problems -

1. When i click on BIDS from the Sql Server 2005, it opens VS.Net 2005
2. There is no option named "Step into Stored Procedure"

Is there any setting which i am missing ?
ALso the stored procedure was not built using VS.Net 2005. It is written in SQL Server 2005 only.

Any help will be appreciated.
Thanks.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

VK-Cadec29-Dec-06 3:55

29-Dec-06 3:55

Did you connect to the database and navigate to the sp - THEN - right click on sp - you should see this option.

Lock Unlock Table

VK-Cadec29-Dec-06 2:57

29-Dec-06 2:57

Hi - I want to lock a table,data is then inserted and selected from this table, send to an application(thru sp) and then unlock the table.

I tried searching for some thing on web - unable to find it - maybe the syntax is incorrect?

Thanks.

Re: Lock Unlock Table

Colin Angus Mackay29-Dec-06 4:24

oracle ODBC Driver Connect window appears frequently

29-Dec-06 4:24

Put it in a transaction.

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

bprashant29-Dec-06 0:02

bprashant

29-Dec-06 0:02

hi
I am running an application wriiten in vc++.I have installed the
application at the remote client end
succesfully.Initaily set the DSN for Oracle (10g exe) .When I start
using application I get "oracle ODBC Driver Window" after regular
intervals.
why this window is appearing frequently when i set the DSN initally and
tested succesfully.

pls help!!!

Query SqlServer2003 stored procedure

vivek_r28-Dec-06 19:29

vivek_r

28-Dec-06 19:29

Hi,
I am working on a forgot password module in which i have to send the mail having password to the user.I am using UserID,Email,IsApproved,IsVisible fields in my table.The module is working fine with sending mail on the basis of existing email of user.But i have to apply checks on the stored procedure that if the IsApproved and IsVisble fields are set to 0 by admin then the password would not be sent to the user and if IsApproved is 0 and IsVisible is 1 then do not send mail and if IsApproved is 1 and IsVisible is 0 then send mail.
I am using SqlServer2003 stored procedure.

Vivek Rathore

Re: Query SqlServer2003 stored procedure

_AK_28-Dec-06 20:40

_AK_

28-Dec-06 20:40

You can use IF condition in your stored procedure.

Best Regards,
Apurva Kaushal

Re: Query SqlServer2003 stored procedure

Colin Angus Mackay29-Dec-06 0:27

Re: Query SqlServer2003 stored procedure

29-Dec-06 0:27

vivek_r wrote:
I am using SqlServer2003 stored procedure

I very much doubt that.

vivek_r wrote:
I am working on a forgot password module in which i have to send the mail having password to the user

Personally, I think that is a bad idea. You should never store the password in a form where it can be sent via email. It is better to store the password as a salted hash which means that it can never be retrieved. Then, if the user forgets the password, it has to be regenerated.

vivek_r wrote:
if the IsApproved and IsVisble fields are set to 0 by admin then the password would not be sent to the user and if IsApproved is 0 and IsVisible is 1 then do not send mail and if IsApproved is 1 and IsVisible is 0 then send mail.

SELECT columns
WHERE Email = @email
AND IsApproved = 1

The logic is very simple. You have stated that if IsApproved is 0 then do not send the email, and IsVisible is unimportant (reread what you wrote if you think that is an incorrect interpretation)

IsVisible IsApproved Send Email
0         0          No
0         1          Yes
1         0          No
1         1          Doesn't say: likely yes

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

vivek_r29-Dec-06 0:33

vivek_r

29-Dec-06 0:33

Dear Colin,
You are saying very much right that the IsVisible field does not mean at all.
A short while ago i got the same answer as urs was.
Thank you very much for your suggestion.

Thanks and Regards
Vivek Rathore.

Vivek Rathore.

How can I take the backup of SQL server database by code

indian14328-Dec-06 19:08

indian143

28-Dec-06 19:08

Dear friends,
How can I take the backup of SQL server database through coding, and I want to restore it through coding. The database must be kept as a text file. And shuld be able to restore it.

And how can I import and export the SQL server data in to MS-Access mdb file. Please advise me, or give me some code snippet if possible.

-- modified at 3:06 Friday 29th December, 2006

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Re: How can I take the backup of SQL server database by code

Colin Angus Mackay29-Dec-06 0:30

find database size sql server 6.5

29-Dec-06 0:30

indian143 wrote:
How can I take the backup of SQL server database through coding, and I want to restore it through coding.

You can issue virtually any command you like through SqlCommand including the BACKUP and RESTORE commands.

indian143 wrote:
The database must be kept as a text file

Why? That is a very inefficient format to store a backup of a database in.

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

manish1980kumar28-Dec-06 17:26

manish1980kumar

28-Dec-06 17:26

i want to know how to find size of database

used space in files,used space in logs,free space for files,
free space for logs,unused space

thanx

manish

Data Set object or XML file

danaliasdan28-Dec-06 11:39

danaliasdan

28-Dec-06 11:39

I have to fill a survey form with data from an oracle database.

We debate two ideas: use a dataset object or a XML file.

For XML file I would use forward only method of reading the file and not DOM, faster.

Is it more efficient generating the XML from database and then parsing the XML on the application server then using a data set returned from the database ?

Thank you

List of Servers

_mubashir27-Dec-06 7:41

_mubashir

27-Dec-06 7:41

Hi,
I am working in ASP.NET. I need to get the list of Servers registered on the local machine. How can I get this??

regards
Mubashir

Every job is a self portrait of the person who did it.

Laubi28-Dec-06 0:57

Laubi

28-Dec-06 0:57

I haven't seen a pure ADO.NET solution for this (I guess this is what you're looking for) but if you can't find such a solution there as an alternative way..

SQLDMO object! Here SQLDMO.Application you'll find a method called ListAvailableSQLServers! Just add a reference to your project and create an instance of it and you've got your list.

_mubashir28-Dec-06 4:27

_mubashir

28-Dec-06 4:27

thanks,
I tried it but it is returning 0 servers. Why is this so? I am using Windows XP and SQL Server 2000.

regards
Mubashir

Every job is a self portrait of the person who did it.

Laubi28-Dec-06 4:34

Laubi

28-Dec-06 4:34

There are several possible reasons for this..

The database might be hidden - to check open sql manager and select the properties by right clicking on the protocols node of the db instance. Look for "HideInstance"..

It could also be that you're running into a latency problem, if your server isn't responding fast enough you won't see it. But it would say this is unlikely on "localhost"!

If this still doesn't help, you might want to use a workaround. You could easily enumerate this registry key: SOFTWARE\Microsoft\Microsoft SQL Server - InstalledInstances

_mubashir28-Dec-06 5:37

_mubashir

28-Dec-06 5:37

Thanks for your quick help...
i tried SOFTWARE\Microsoft\Microsoft SQL Server - InstalledInstances, but it doesnt contains Server Information registered in a SQL Server Group. How can I get that Frown | :(

?

regards
Mubashir

Every job is a self portrait of the person who did it.