Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 3,366 total)

  • RE: Unicode

    In SQL Server 2K5 it is enabled by default. Just keep in mind the storage gets doubled, so a single character takes up two bytes.

    I am not sure...

    Kind regards,
    Gift Peddie

  • RE: Difficulty connecting to a remote SQL Server db.

    This is generally caused by SSRS dropping your connection credential so check the connection property in BIDs you will see it empty add the permissions back. You also need...

    Kind regards,
    Gift Peddie

  • RE: Rich text

    Yes you could the but the file must be static because you could store Word file in an image column and then add the column into a Rectangle. The...

    Kind regards,
    Gift Peddie

  • RE: Windows Authentication Mode vs Mixed Mode

    The link actually covers it about how it is an admin user account that is used for the proxy not the default Agent account. So create the proxy with...

    Kind regards,
    Gift Peddie

  • RE: Windows Authentication Mode vs Mixed Mode

    If I use a proxy for this, I don't see how that differs UNLESS the proxy account allows these people with lower permissions to perform all agent tasks.

    The proxy account...

    Kind regards,
    Gift Peddie

  • RE: Windows Authentication Mode vs Mixed Mode

    No you cannot use a lower level permission because it will not run however that is the reason for the proxy account. The proxy account is not complicated you could...

    Kind regards,
    Gift Peddie

  • RE: Windows Authentication Mode vs Mixed Mode

    No you don't understand me I am telling you to go into Configuration Manager and use that account to run the Agent because when anything it run as a JOB...

    Kind regards,
    Gift Peddie

  • RE: Windows Authentication Mode vs Mixed Mode

    When called from the stored procedure in question, I do believe you are all right in saying that the called job tries to run as whoever the user is who...

    Kind regards,
    Gift Peddie

  • RE: Dundas and SQL Express 2008

    The short answer is you need to wait for VS2010 to be in beta3 or RC because VS2008 ReportViewer control does not support local mode so you need SSRS running...

    Kind regards,
    Gift Peddie

  • RE: tempDB filled 140GB HDD in under 2 days?

    No I know how cross JOINs without the where clause can make TempDB grow because most RDBMS query processors use those JOINs to increase JOIN performance. But these links...

    Kind regards,
    Gift Peddie

  • RE: tempDB filled 140GB HDD in under 2 days?

    Hi Jeff,

    The link below says Trace Flag 1118 is not really needed in SQL Server 2005 and above because of changes made. The user is supposed do some configurations...

    Kind regards,
    Gift Peddie

  • RE: tempDB filled 140GB HDD in under 2 days?

    I don't know why SSRS will cause TempDB to grow because it generally rejects code using temporary tables. So you need to find where and what code is used...

    Kind regards,
    Gift Peddie

  • RE: Promblens installing SQL Server 2005 Express

    In XP pro try system restore to roll the system back to a point in time before the install and run SQL Server 2005 Express with SP3, if that did...

    Kind regards,
    Gift Peddie

  • RE: Unable to load SQL Server OLEDB provider resource DLL

    I need to know where you are getting the OLE DB data and where you are sending it. This is 64bits so I need to know so I can...

    Kind regards,
    Gift Peddie

  • RE: Linked Server to iSeries issues

    I sorry it took so long but here is a thread with many IBM connection configuration code let me know if you can use it. There are specific code...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 2,056 through 2,070 (of 3,366 total)