Can you provide table deffinition and sample data and your query?

You could build the data up including a row_number function adding 5 so that it starts from 6 and ends at 905.

INSERT INTO

sometable

SELECT

ROW_NUMBER() OVER(ORDER BY intcoloumn ) +...

If the procedure generates an output then it will usually be stored in the job history, if not unless you have some custom logging on the tables then I dont...

1 - could you just not set the accounts to never expire, that way the passwords never need changing?

2 - use something like impersonation where a user clicks the link...

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,...