It is probably a specific hotfix applied after SP2.

Thanks,

Jared

I am not very familiar with xml, but have you tried this?

declare @Filt XML='<Filter>

<List>

<Node1>100</Node1>

<Node2>10</Node2>

</List>

<List>

<Node1>200</Node1>

<Node2>1</Node2>

</List>

<List>

<Node1>200</Node1>

<Node2>2</Node2>

</List>

<List>

<Node1>200</Node1>

<Node2>3</Node2>

</List>

</Filter>'

Thanks,

Jared

Can you please be more specific with a question?

Thanks,

Jared

You can declare a variable in SQL by using DECLARE @variableName INT and then SET @variableName = SELECT 2 (or pass it in in a stored procedure. Then you...

I think that in this case the RBAR is okay. This is a small query and is only doing the select and inserts. Although I agree it is...

Other issues I have seen is if I am accessing a 2005 database or with the compatibility level of the database being 90. That could be throwing it off as...

Try closing out of your SSMS and going back in. That usually does it for me as I believe the data needs to be loaded into cache.

Thanks,

Jared

SQLRNNR (9/8/2011)

---

Here's a script that should work for you.

SET DATEFORMAT DMY

DECLARE @StartDateDATE = '05/06/2011'

,@EndDateDATE = '31/08/2012'

;

WITH getmonths AS (

SELECT cast(Convert(varchar,'01/' + cast(MonthNum as varchar) + '/' + cast(yr.yr as varchar))...

Ok, here's what I got that can be put into a stored proc format if needed:

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

DECLARE @numMonths TINYINT

DECLARE @calendarTable TABLE (monthNum TINYINT, monthDays TINYINT)

SET @StartDate =...

Start at this page: http://www32.brinkster.com/srisamp/sqlArticles/article_5.htm

The main way for a given month is this: SELECT DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(GETDATE()), GETDATE())) - 1)

That will give you the amount...

Ok, this would have no bearing on the size of the database backup (as was previously mentioned you probably appended instead of overwrote)... However, you should add log backups to...

Ninja's_RGR'us (9/8/2011)

---

troe_atl (9/8/2011)

---

I scheduled the maintenance plan for 8:00 pm. However, I deleted the maintenance plan yesterday and recreated it and it ran last night. The only problem I have...

Am I mistaken, or do I not see any backup even starting in the logs? What time, exactly, is the backup scheduled for. The shutdown may be unrelated,...

So, my guess is that you are generating a user for the database in your scripts that does not exist on your local machine.

Run each statement separately until you...

Sorry... I should learn to read everything first... Give me a minute or 2 and I will post...