Viewing 15 posts - 1,276 through 1,290 (of 2,010 total)
This sounds very much like the situation RBarryYoung discussed in his talk. In that case he was just packaging up an XML doc and sending across the wire, but...
December 18, 2008 at 11:11 am
So I guess there are a couple of basic questions here...
1, is this some sort of API or whatever that you are being forced to interact with and this is...
December 18, 2008 at 9:52 am
So I've been looking into this a bit and the one piece of info I can't seem to find is, what the heck does sp_replwritetovarbin do? I've disabled it...
December 17, 2008 at 2:20 pm
I believe you can do what you want with the User!UserID global variable...
Create a Hidden Parameter of type string, call it LoginName for instance.
for the default value select the radial...
December 12, 2008 at 11:27 am
Are you attempting to use this in a piece of TSQL because I don't believe it's a built in function.
there is a function for that in SSRS. If...
December 12, 2008 at 9:36 am
Actually I've been seeing reports of a new SQL Server vulnerability, this is a different one from the IE exploit.
Here's the post from secunia...
http://www.sec-consult.com/files/20081209_mssql-2000-sp_replwritetovarbin_memwrite.txt
December 12, 2008 at 9:17 am
Go to Book Online and look up the LEN() command.
I think you will find that helpful.
-Luke.
December 10, 2008 at 9:02 am
Just to add to what Jerry already said...
If you are using columns in your Select statement that are not part of your index in one way or another and the...
December 5, 2008 at 1:39 pm
Sure, it makes it clearer what you are trying to do. In my above post, I posted a few links to articles by Jeff Moden who recently covered how...
December 5, 2008 at 1:20 pm
It sounds liek perhaps you are looking for a pivot or cross table...
Here are some more articles by Jeff on doing just that. Have a read and see if...
December 5, 2008 at 1:11 pm
Martin, unfortunately it will be very difficult to guess exactly what you are asking about.
Could you please post a bit more detail? Some Table DDL and test data would...
December 5, 2008 at 1:09 pm
Do you have disk quotas turned on? You say the disk space is fine, have you checked while the job is executing or only before and after it's completion?
December 5, 2008 at 1:06 pm
GilaMonster (12/5/2008)
Does this work?
select top 1 idfrom tblname
where tblname.person = 'xxx-xxx...'
group by id order by max(dttm) desc
Just outta curiosity, doesn't the above make the TOP unnecessary, or is there...
December 5, 2008 at 11:45 am
Another Great article Jeff. Very informative and useful.
-Luke.
December 3, 2008 at 8:05 am
If this is on a Dev workstation Win XP or Vista, you could use System restore to restore back to before you attempted to install adventureworks.msi. windows should have...
December 2, 2008 at 6:18 am
Viewing 15 posts - 1,276 through 1,290 (of 2,010 total)