moving to ssdt is not something I would advise - SSMS is a administrator tool, SSDT is a developer tool - functionality is rather different and SSDT will be missing...

touch-typist

As part of my travels through the air force (transmissions/communications) we went through intensive typing training - at start of the course we were having 12 hours a week of...

you have other views there - and views over views over views always cause issues with the query processor.

the actual explain plan for this will be useful - and all...

I find this a bit amusing - you ask for help, we give you some and we point you to...

what type of files you talking about - if SQLProjs then SSMS works differently from Visual Studio and there is no straight migration.

which one failed?

and did you do

execute as login = 'domainname\username'

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

i've used this with other windows groups only granted to sql and it works fine without the...

• This reply was modified 4 years, 2 months ago by frederico_fonseca.

size of the column

e.g. varchar(xxxx)

so do give the ddl as asked.

that death.location column is bigger than 1k bytes I would assume by the error.

but do give has the ddl for the 2 tables involved.

alongside what has already been suggested (plenty of it and with indication of what how you could/should approach the issue).

hire a rather good SQL Developer to do this for you.

placement of files on physical drives (same or separate) as well as being local or SAN (and type of SAN) as well as being SSD or SATA (and RAID setup)...

• This reply was modified 4 years, 2 months ago by frederico_fonseca.

I assume you know which login dropped/created the procs.

and assuming you are a SYSADMIN what output do you get out of these

execute as login = 'loginname'

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

use...

yup it was...

count the brackets

don't waste time with small changes that will have minor impact on the process.

Do worry about trying to put on paper what the process should do to a whole set,...

https://www.microsoft.com/en-us/sql-server/sql-server-downloads