Viewing 15 posts - 91 through 105 (of 180 total)
Sounds strange, do you use the same account to run the SQL instance that you use to run the AGENT? Have you tried granting the SQL service account access to...
April 28, 2015 at 10:23 am
from the following link, DTEXEC.EXE looks like a good candidate. you could put the execution string in a batch file that the user could double click to run.
http://www.mssqltips.com/sqlservertip/1775/different-ways-to-execute-a-sql-server-ssis-package/
Can...
April 28, 2015 at 10:04 am
I know you've done this now, funnily enough I was doing service packs for various versions of SQL on the weekend. Worth noting that in SQL 2008r2 you get no...
April 27, 2015 at 9:47 am
Instead of creating objects in system databases, why don't you create a new database specifically for the objects you create? would save messing with the system databases.
you will still be...
April 27, 2015 at 9:25 am
You would be better off backing up the databases on the 2005 box and restoring to the new box.
script out the logins from the old box to create on the...
April 27, 2015 at 9:12 am
Have you got a dba to run it to see if they get the same issues? Just to rule out permissions?
April 25, 2015 at 12:07 pm
it's not important that identity can't be null as the OP isn't going to do that. my phrasing of the question was 'can you add a nullable auto increment' because...
April 24, 2015 at 10:01 am
that's why i added
you can then do a data compare using a 3rd party tool (sql datacompare by redgate is one) to verify the data is the same. this...
April 24, 2015 at 9:55 am
Great, let me know if it is suitable or not after some testing. Yes the auto increment was mainly to let you be sure what records are new and what...
April 24, 2015 at 9:42 am
definitely worth a go with the rebuild, trial and error really!
April 24, 2015 at 9:32 am
have you tried a rebuild on that particular index? is it clustered or non clustered? what edition of SQL is it?
April 24, 2015 at 9:27 am
forgot to add, once you have got to this point, then you can delete from the original table in batches where newcol is null. small batches to minimise locking.
once complete...
April 24, 2015 at 9:26 am
Can you add a nullable auto increment column to the table? this will have little impact, as the autoincrement will start when the next insert occurs. then you can
select...
April 24, 2015 at 9:24 am
Is it always the same index? is it reorg or rebuild?
April 24, 2015 at 9:13 am
Viewing 15 posts - 91 through 105 (of 180 total)