Viewing 15 posts - 18,691 through 18,705 (of 19,564 total)
SQLRookie 6502 (12/17/2009)
Files are supposed to populate in specific queues when certain criteria are met.
What is the problem you are running into (programmatic or logic)? What are the specific...
December 17, 2009 at 4:03 pm
Does anybody see a broken image in place of their avatars or images here at SSC?
About half of the Avatars show a broken image icon in lieu of my pic,...
December 17, 2009 at 3:40 pm
Matt Miller (#4) (12/17/2009)
GSquared (12/17/2009)
The Dixie Flatline (12/17/2009)
Is it just me, or is there a sudden frenzy of demands right at the end of the year?
Probably people trying to solve...
December 17, 2009 at 3:13 pm
Paul White (12/16/2009)
nmoore (12/16/2009)
Transportable filegroups would be nice.You'd need to downgrade to Oracle for that.
nice
December 17, 2009 at 12:55 pm
Robert Frasca (12/17/2009)
select *FROM PM.vw_LastSelfPayPaymentActivity --where account_id = 107246
...
The query plan for the slow one says that it is performing a clustered index seek where the cost is 100%. ...
December 17, 2009 at 12:52 pm
Thanks for posting back and updating the forum.
December 17, 2009 at 12:49 pm
This might get you headed in the right direction:
http://deepakrangarajan.blogspot.com/2007/06/role-change-in-sl-2005-log-shipping.html
December 17, 2009 at 12:35 pm
novice_coder (12/17/2009)
GilaMonster (12/17/2009)
novice_coder (12/17/2009)
We will probably have about 3-5 million records by the end of next year. I guess then I will have to think about partioning.
That's not a...
December 17, 2009 at 12:30 pm
Or this would work too:
;WITH uppity (id, lft, rght, idx)
AS
(
SELECT t.col_01
...
December 17, 2009 at 12:22 pm
The second set of insert statements for your FROM_UPD table do not match your table definition.
Could you clarify which set of statements and the requirements?
December 17, 2009 at 11:32 am
The method Emily is describing has worked for me in the past.
Using xp_cmdshell, run a dir of the directory. Output the results of that directly to a table.
Once in...
December 17, 2009 at 11:16 am
What are the options you selected for the backup? Did you specify the with move option as the error text indicates?
December 16, 2009 at 9:11 pm
As a separate step you could execute xp_cmdshell if this must be done via SQL Server. However, you could do this using an OO language rather than TSQL.
December 16, 2009 at 8:59 pm
Paul White (12/16/2009)
Jeff Moden (12/16/2009)
Hmmm... hair color is just about right. Need to add a "No RBAR" tatoo, though. 😛It's the no-RBEAR 😀
ROFLMAO
December 16, 2009 at 8:53 pm
Viewing 15 posts - 18,691 through 18,705 (of 19,564 total)