quote:Originally posted by khtan select * from syscolumns where id = object_id('your_sp') Thanks! That's perfect.
Is there an easy way to make a call to SQL Server 2005 to retrieve information about a stored procedure? Specifically, I'd like to obtain a list of...
Today I read an article about Yahoo! email accounts and it got me thinking-- of the major free email providers, what would it take to max out an...
Thanks guys for the response. Ok, I realize why I couldn't get my script to work. The CREATE DATABASE command included more than just 'CREATE...
I have an application that has a prerequisite of SQL Server Express 2005 when it is installed. After installing SQL Express, my application needs to...
Thanks for the response. That makes sense. Considering the fact that my connections strings never change for the db commands, I'll add a few close...
I've been developing in .NET for a few years now and it's been quite a while since I've read up on the MS documentation about establishing database...
Thanks guys for responding. The problem has been solved. It was actually caused by multiple things mostly. Some of the issues arose out of...
Maybe this isn't the best place to ask this question but with this exception that I am getting I feel like I'm in a little over my head and I'd...
Sorry, one more question. It's probably covered some where else but I can't find it. How do I interact with the returned data set from the...
Brilliant! Thanks a bunch, that will work perfectly.
Is there a way to declare a variable that I can SET at anytime which I can use to specify a specific column in a Stored Procedure or other...
Ah! Actually I can't now. I just left my bosses office about ten minutes ago and we've decided to take a different direction in handling the data....
I should also point out that it returns two lines every time a stored procedure is executed. The differences in the binary data were taken from the...
The binary columns are slightly different. The slow one begins with: 0x140000000A, and ends with 9A02, the faster one begins with 0x1400000008 and...
The Query from QA show a 68 under the CPU column and an 815 under the Reads column. When I execute it in the app CPU is 27375 and the Reads is...
Oops, sorry. Read the double slash as a single. I took it from a C# string.
Here is the connection string: Data Source=.\sqlexpress;Initial Catalog=BOSS_Quote_V40_Local;Integrated Security=True; Because of the integrated...
Ok, I created the exec statement with the parameters and then tried to execute it from my app. This is it: exec PS_cboMiniPS '', 10, 0, 10, 10,...
Ah, I see what you're saying. I'll give that a try.
Separate names with a comma.
