Viewing 15 posts - 61 through 75 (of 161 total)
You do realize that by using "ThisPublication" directly from the Request and then concatenating it to the SQL, you're setting yourself up for SQL Injection?
Steve G.
April 29, 2008 at 12:26 pm
You could try something like this...
select 'update '+t.table_name+' set '+column_name+
' = null where 0 = len(ltrim(rtrim('+column_name+')))'
from information_schema.columns c
inner join information_schema.tables t
on c.table_name...
April 11, 2008 at 10:44 am
Don't forget to update statistics when you're done!
Steve G. 😀
April 9, 2008 at 11:03 am
from (select tb1.col1, tb2.col1, tb2.col2, tb2.col3 from db.dbo.table1 tb1
Is there a significant difference between the total columns in table1 and the columns listed in the new derived table?
April 2, 2008 at 10:36 am
So, then the answer is: "You can do it but it's not worth it." I'll take that as the final word on this and go back to using temp tables....
March 7, 2008 at 11:03 am
I've always run into problems trying to use Integrated Sign ons with Linked Servers. There's some extra setup that needs to be done in Active Directory (which I don't have...
February 29, 2008 at 10:48 am
Yes, I agree that it appears that the problem appears after a certain threshold is reached - the question is which system in the chain is having the problem?
Some things...
February 4, 2008 at 3:39 pm
Has there been any changes in the client software? (Installations, configuration changes, etc.) Also, are your clients segmented so that certain clients only contact certain servers? This sounds awfully like...
February 4, 2008 at 11:32 am
Congrats! I'm in a very similar situation and I do have one piece of advice: Document everything you do because you won't remember what you did when you come back...
January 23, 2008 at 11:18 am
Make sure the table has a primary key. MS's CRecordSet code will not open an updateable cursor without this.
While I know that the sequence you mention is the "planned"...
January 16, 2008 at 12:35 pm
First of all, realize that a log file is not "supposed" to be a certain size. As was mentioned earlier, the size is related to the activity in the database....
January 8, 2008 at 2:52 pm
Of course, this may not be the right answer, but let's assume first that SQL Server is working ...
In Query Analyzer, choose Tools->Options and select the Results tab. Make sure...
December 31, 2007 at 5:24 pm
Gotta love AD - who decided that a single point of failure was an improved security model?? Guess one password, access dozens of sytems. 😀
November 30, 2007 at 10:14 am
you'll never see me use a While Loop to create a list of contiguous dates... I'll always use a Tally table for that (and a lot more).
Sounds like a useful...
November 24, 2007 at 10:58 pm
Viewing 15 posts - 61 through 75 (of 161 total)