purushottam2 (1/27/2013)

---

Production db had the 100 GB of log file. to remove log file i did following steps.

- Deattached Database

- Renamed logfile

- Attached Database with-ought log file.

Above process creates new...

There is no SSRS2010, SSDT (SQL Server Data Tools) is built using Visual Studio 2010 is the means to create reports for SSRS 2012

SSRS 2008 and SSRS 2008R2 use BIDS...

You can have a 2 node Enterprise cluster.

When you connect to SQL via SSMS run

SELECT @@VERSION

You should get something like the following

Microsoft SQL Server 2008 (SP2) - 10.0.4067.0 (X64)...

If your going to upgrade your report server to SQL 2012, then you can upgrade your reports to VS 2010 but no higher.

If your not planning on upgrading your SSRS...

Again, why don't you get a copy of Solarwinds, install it, configure it and play with it

Also don't cross post, one topic is enough, you don't need to open up...

What edition of SQL? Standard? Enterprise?

If Standard you can only have a 2 node cluster, so you will need to evict the passive node from the cluster, install...

You should use the right version of VS for the version of SSRS.

So if your using SSRS 2005, you use BIDS 2005 built in VS2005

SSRS 2008 or SSRS 2008R2, you...

Only upon restart of the service as TempDB is created from model so the objects inside it will also be created in TempDB

Hence why you should use a script to...

if every database you ever create on that server needs the same sp's tables etc, then use model, if they need different ones, use scripts

What happens should someone create a database while the objects are still in model? Do you want them in that database or not?

Create scripts for all your objects, then just run the script every time you create a database which needs them objects.

Do not cross post, it fragments replies.

http://www.sqlservercentral.com/Forums/Topic1411581-146-1.aspx

yes it makes sense, I am busy with work now, when I get a spare moment I will re-look at this unless someone else beats me to it

tony28 (1/25/2013)

---

INSERT INTO [dbo].[TB_WORK_ORDER_AGVEN]

([ORDER_DATE]

,[COMMIT_NO]

...

That's not your original data set, the last date was 2013-02-15.

CREATE TABLE [#mydates](

[id] [int] NOT NULL,

[mydate] [datetime] NULL

) ON [PRIMARY]

GO

INSERT INTO [#mydates] (id, [mydate])

SELECT 1,'2012-01-03' UNION ALL

SELECT 2,'2012-12-05' UNION ALL

SELECT...