Hi Thanks.   I started in Azure 2 years ago, but the company shyed away from it so didnt learn more. I've been a MSSQL dba for years and surprised they...

I've been a Snr DBA for 10+ years and know what the ramifications are, but that wasnt my question. I didnt setup this database/system and did change the Db isolation...

We had similar issues(same error) a few jobs ago when upgrading the OS and SQL same day. Maybe you did, or didnt also upgrade the OS, but our problem was...

Hello, sorry for the late reply.

They have jobs they kick off from the "Sql Agent" which run thier packages, sometimes they run one pack, or the whole job(a bunch...

Thanks for the replies. The main issue is we have executives who, for politcal reasons have access to create/run DTS(x) packs, and are now SSIS savy, running them on schedules....

That group needs to be added to the local sever you are trying to run the job on. Have you confirmed that..? For instance when I setup replication I have...

No to sound rude, but are you kidding me by saying Nolock is a bad idea 99% of the time....? Everyone I know has clearly shown it has huge benefits...

Hi Grant or(Anyone else) :),

Thanks for the reply; you're comments helped. I did want to ask (if you dont mind) for more feedback on the "migrate the keys" suggestion..?...

Thanks everyone. The only reason I suggested changing to Varchar was my hope the value would evaluate the same and not force a re-order of the index, but it sounds...

Hi Gail,

I ran

ALTER DATABASE [VSD] MODIFY FILE ( NAME = N'VSD', SIZE = 29864824 MB )

and this is the error again:

Msg 1842, Level 16, State 1, Line 1

The...

I was using

ALTER DATABASE [XXXX] MODIFY FILE ( NAME = N'VSD2', SIZE = NumberBiggerThatbeforeKB )

Technically they are in filegroups, right now we can't even open the database properties because...

Well not to sound rude, but I wonder how you got the job in the first place. Most companies ask a lot of questions, but then again some dont. All...

I would do some searching in this forum for performance tuning for more details. I personally and so do many others prefer to stick all the items on seperate drives...