Think this should work, but not tried it for a data source but.....

Grab a copy of RSScriptor, use it to script out the rds and then import it into your...

It wont help as you wont be able to query the data in any of the objects as SQL issues a unique number to the end of a temp table...

What is the starting point for the conversions, is it today, tomorrow, next week? We need this especially for leap years as the last example may span 2 or...

Daxesh Patel (6/13/2012)

---

if table has a large size data, I think SELECT * INTO should be avoided due to its limitations.

I would create New table ahead of time with partitions...

Is that for the DB or the table?

If you need authentication for users outside of your domain you have 4 options,

1 - grant each user outside your domain, their own individual domain account

2 - publish 1...

On Change : Prevent policies create triggers so your not doing anything different as to what you where trying to do in the first place, its just it doesn't look...

If possible use a where clause to limit the data instead of copying 9 million rows

Pre-allocate the storage space required so SQL doesnt need to grow the files

I would say you will need to create a custom DDL trigger which rolls back the change if they try to create an object in a schema which is not...

Then it looks like you have created two object with the same name, which will break the unique key.

You first need to create your multipart identifier condition.

Then create the policy...

knocking up some sample data and results query, I believe this will do the trick

declare @weeks table (weekid int identity, weekstartdate date)

insert into @weeks values ('2012-06-02')

declare @x int = 1,...

http://www.sqlservercentral.com/Forums/Topic805464-6-1.aspx

The above URL details how to setup annoymous authentication in SSRS 2008, other than that you will need to go down the custom authentication route and call the reportviewer.aspx control...

Duran (6/13/2012)

---

ah ok, so just three exams if you already hold MCITP SQL 2008. I kinda wish they had stayed with the MCITP theme though, I still think the MCSE...

Duran (6/13/2012)

---

Just reading about the upgrade paths, it seems to me that if you are new, you take two exams and get the MCSE:Data Platform, but if you are upgrading...

You will need to drop and rebuild all indexes, primary keys etc to enforce the new collation.

Or you could add COLLATE database_default to then end of any string comparisions

SELECT TOP...