occasionally do the timeouts occur when the TLOG backups are running.. These TLOG backups only run once every 2 hours. and sometimes the timeout errors occur when...

Along with a bunch more of these errors,

A time-out occurred while waiting for buffer latch -- type 4, bp 03675BE4, page 1:18272, stat 0x3c0400f, database id: 2, allocation unit...

Thank you all!

I actually was able to import the packages under SSIS, Stored Procedures, MSDB, Maintenance plan then right click and import!!

Thank you so much for your help and guidance.

yeah.. I'll have to play around with command line.. but not now : )

question. now that I'm connected to SSIS (duh!!! i should have known...

Thank you .. that worked.

I created the SP in my master DB and then executed it like this:

Exec changemanagement_Training..sp_ScriptRoles

and I got this?

Msg 451, Level 16, State 1,...

I did see that one.. it errors out on me..

Msg 102, Level 15, State 1, Procedure sp_ScriptRoles, Line 4

Incorrect syntax near '?'.

Msg 137, Level 15, State 2,...

Thank you for your reply!!!

I will download Visual Studio ...

I do have a related question thought. I DID create an SSI package via the...

very true.. but when I add DISTINCT to my Select, I didn't expect it to totally reorder my results. Adding DISTINCT dropped 20 duplicates. ...

Great advice. Thank you!!

That worked!!!!! Thank you so much.

Now I am trying to exclude duplicates. I thought this would work.. but I seem to be getting garbage in...

so how do I get my query to actually populate History_YN with either blank, Y or N?

a little more help? 😀

here is the lastest version of my SQL:

SELECT a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

,a.history_YN

FROM FRATERNAL.CONTACTS a

inner join FRATERNAL.CLIENT_CONTACTS a1 on a.CONTACT_ID = a1.CONTACT_ID

inner join FRATERNAL.MEMBER b on a1.CLIENT_ID...

gail,

Thanks for all your help. My startup parameters WERE miss-aligned (spaces where there shouldn't have been and one missing)

I fixed the startup parameters in the registry...

I checked the registry and the startup parameters for this instance seems fine:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.5\MSSQLServer\Parameters]

"SQLArg0"="-f"

"SQLArg1"=" -T3608"

"SQLArg2"=" -dF:\\MSSQL\\OVOPS\\Datafiles\\master.mdf"

"SQLArg3"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL.5\\MSSQL\\LOG\\ERRORLOG"

"SQLArg4"="-lG:\\MSSQL\\OVOPS\\Logfiles\\mastlog.ldf"