Viewing 15 posts - 24,871 through 24,885 (of 26,490 total)
The 😉 (wink) should just be a close paren )
April 21, 2008 at 7:58 am
Try this:
SELECT
proj_id,
fund_srce_desc
INTO
#KIPP
FROM
PROJ_GOVT_CONTR
order by
proj_id
select
*
from
...
April 21, 2008 at 7:26 am
That's why. I provided a SQL Server 2005 solution since you posted your request for help in a SQL Server 2005 forum. CTE's are not available in SQL...
April 21, 2008 at 7:22 am
What version of SQL Server are you using?
April 21, 2008 at 7:15 am
Try this:
SELECT
proj_id,
fund_srce_desc
INTO
#KIPP
FROM
PROJ_GOVT_CONTR
order by
proj_id
select
*
from
...
April 21, 2008 at 7:07 am
kipp (4/21/2008)
Msg 170, Level 15, State...
April 21, 2008 at 6:43 am
I have the same version of SSMS on one of my desktop systems (I have SQL Server 2005 DE installed, and on this one system I can't get any SP...
April 18, 2008 at 3:04 pm
xuanly (4/18/2008)
update dbo.kippset [desc] = (select distinct b.[desc] from dbo.kipp b where substring(a.proj_id, 1,5) = b.proj_id )
from dbo.kipp a
Try that, Others might have a better way
And here is another...
April 18, 2008 at 2:17 pm
I don't know of any way to throttle the backup process, but I would recommend looking into software that can compress your backups as the backup runs.
I am currently evaluating...
April 18, 2008 at 1:59 pm
Not sure off hand. Just wondering how you saved/deployed the SSIS packages that have delays in execution. You say I may have a gut feeling, but need more...
April 18, 2008 at 12:30 pm
Amit Kumar Sunkuru and schumi
How are your SSIS packages saved/deployed? What I am looking for are what parameters you used when you saved/deployed the packages.
😎
April 18, 2008 at 11:53 am
riga1966 (4/18/2008)
sysaltfiles.filesizeIs it in KB or MB ?
From BOL: File size, in 8-kilobyte (KB) pages
😎
April 18, 2008 at 11:21 am
Kaushik Kumar (4/18/2008)
thanks. This definitely gives me a starting point.also, I feel left out with FLOWR, are there any good online tutorials?
You might want to start with this article: http://www.sqlservercentral.com/articles/SS2K5+-+XML/2840/
😎
April 18, 2008 at 9:40 am
Definately not an intuitive error message. Just reading it you would think syntax error. If trying to restore a 2005 database to a 2000 server you'd think the...
April 18, 2008 at 9:28 am
Just checking, did you put the table name in single quotes in the DBBC CHECKIDENT command?
DBCC CHECKIDENT('tablename',RESEED,@value)
😎
April 18, 2008 at 6:52 am
Viewing 15 posts - 24,871 through 24,885 (of 26,490 total)