|
Colin Angus Mackay wrote: RecordSets in Visual Basic 2005
True. I am thinking of the old days with MS Access + VBA and rs was commonly RecordSet. Maybe the OP has the two mixed up. I noticed the OP refers to SQL 2005 so I am really confused about the whole thread 
|
|
|
|
|
|
gnadeem wrote: i suppose this will be helpfull.
It looks like it could. I found it very interesting 
|
|
|
|
|
Again I got bit by the default CommandTimeout being too dang short.
|
|
|
|
|
PIEBALDconsult wrote: Again I got bit by the default CommandTimeout being too dang short
30 seconds is too short?! I presume this isn't a very interactive piece of software that you are writing.
|
|
|
|
|
Colin Angus Mackay wrote: 30 seconds is too short?
I would almost say that is too long of a time 
|
|
|
|
|
I usually write backend, batch, service kinds of things, so I usually set CommandTimeout to 0 (unlimited).
In this case, it is interactive so I left it set at the default. But... it's a simple messaging system; I'm using a RichTextBox, and putting the "message" into an NVARCHAR(MAX) (Sql Server 2005). It turns out I can drag and drop more than just text in the RichTextBox (graphics, sound, video, etc.) which is very cool (glad I don't have to impliment it myself). It works fine on my desktop which also holds the database, but my cow-worker across town kept getting timeouts when trying to retrieve "messages" of 5MB or more (in one case an msi file of 400MB).
I should clarify that the message pull is performed by a worker thread in the client, so the interface is not hindered by the long-duration query.
Ah, well,
|
|
|
|
|
Hi - Where would information on the indexes created for tables be stored?
Like we can get a whole lot of information on table, stored proc, function by selecting from sysobjects.
Thanks.
|
|
|
|
|
Never mind - found it.
select * from sys.indexes
|
|
|
|
|
Hi,
I need to store large amounts of text (upwards of 20,000 words). I was wondering what is the best type to use, or is this not possible. Will I need to store them as files with links in the DB?
Thanks in advance
|
|
|
|
|
You can use an ntext column type to store upto 2Gb of text.
|
|
|
|
|
When I try to connect to SQLServer..It gives me an error saying "Connection Failed.Check with Registration Properties"..
My SqlServer Service Manager doesnt start. I hope its expiry date is on..Is there a way that i can run it as it was before..Please help me..
|
|
|
|
|
lehya wrote: I hope its expiry date is on..
 What expiry date?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Did you connect to the database and navigate to the sp - THEN - right click on sp - you should see this option.
|
|
|
|
|
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.
|
|
|
|
|
|
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!!!
|
|
|
|
|
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
|
|
|
|
|
You can use IF condition in your stored procedure.
Best Regards,
Apurva Kaushal
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
