Viewing 15 posts - 18,481 through 18,495 (of 19,564 total)
It does not look promising that we will see any of the additional information necessary to best assist on this thread.
December 24, 2009 at 3:09 pm
Yes, it will be SQL 2008 R2. It was originally slated to be SQL 2010 - but that plan and name changed a few months back.
December 23, 2009 at 1:09 pm
nitincaet05 (12/23/2009)
OK. This code runs on the server over the ASP, Not sure how to use SSIS task..How do I convert creation_time ("173736") to time format?
17h37m36s
5:37:36 PM
HH = left(creation_time,2)
SS =...
December 23, 2009 at 1:05 pm
Better yet, lock them down so they can't do anything in the systems :Whistling:
December 23, 2009 at 11:43 am
Grant Fritchey (12/23/2009)
GilaMonster (12/23/2009)
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.Time to fetch the chain-saw?
Too...
December 23, 2009 at 11:42 am
GilaMonster (12/23/2009)
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.Time to fetch the chain-saw?
Pork-chops and TNT...
December 23, 2009 at 11:36 am
sureshdeenu (12/23/2009)
Greg, after logging ON, where exactly i need to find the Log to look for error in sql server.
You would be setting your DTS to write it's error log...
December 23, 2009 at 11:35 am
One of two methods come to mind:
1. Use this command in an SSIS task and then do some transformations on it prior to inputting the data into the table.
2....
December 23, 2009 at 11:32 am
GSquared (12/23/2009)
I will run stat updates after index reorgs (not rebuilds, would be redundant).
This is typically what I do.
Grant
December 23, 2009 at 11:31 am
GSquared (12/23/2009)
CirquedeSQLeil (12/23/2009)
10 am here - and not seeing a rousing response about work.Next question is: Who has mentally checked out for the holidays?
This question assumes I ever mentally...
December 23, 2009 at 11:21 am
Matt Miller (#4) (12/23/2009)
Roy Ernest (12/23/2009)
December 23, 2009 at 11:20 am
Here is the related contents of that XP
// Set the Creation Date column in YYYYMMDD format
record.SetSqlString(2,f.CreationTime.ToString("yyyyMMdd"));
// Set the Creation Time column in HHMMSS
record.SetSqlString(3,f.CreationTime.ToString("HHmmss"));
From there...
December 23, 2009 at 11:11 am
10 am here - and not seeing a rousing response about work.
Next question is: Who has mentally checked out for the holidays?
December 23, 2009 at 11:06 am
tosscrosby-60625 (12/23/2009)
CirquedeSQLeil (12/22/2009)
Boot - as in what is done after over indulging.Boot or toot??? 😀
celebrating the "real" reason for the season!
However, the toot may come out as well.
December 23, 2009 at 10:53 am
Viewing 15 posts - 18,481 through 18,495 (of 19,564 total)