Activity overview
Latest activity by mikef
Server connection string properties
Howdy,
I get this when connecting to server running a self-signed cert.
Is there any way I can inject a "TrustServerCertificate=True" into the connection string somehow?Cheers,
Mike.
Brilliant - thanks for the help [image] / comments
Brilliant - thanks for the help
Is it possible to change the time when the Fragmented Indexes check is run?
All of our index maintenance is currently scheduled for Sunday afternoon, as it's our lowest load time.This means the check for fragmented indexes happens about 12 hours before the indexes are rebu...
basilisk> Thanks for your super speedy reply!
I've just re-checked the SP it's bailing out on... no usage of any special 'xp_cmd' style procs or functions.
However, I think I've found the issue, I'm guessing it is related to a JOIN to a server that I can't access.
Crisis averted - time to track down the DBA...
Once again, thanks [image] / comments
basilisk> Thanks for your super speedy reply!
I've just re-checked the SP it's bailing out on... no usage of any special 'xp_cmd' style procs or functions.
However, I think I've found the issue, I'...
Howdy,
I think I'm having the same issue... [image]
I'm connecting to a sql2000 db via SSMS 2005 as a user who is dbo.owner.
It seems to hang at the "SELECT text,ctext,encrypted,number from [DB_NAME].dbo.syscomments c WHERE id=<blah>" point.
Running the query manually works, it pulls a "create" script for a SP.
Cheers,
Mike.
ps... your tools kick ass! / comments
Howdy,
I think I'm having the same issue...
I'm connecting to a sql2000 db via SSMS 2005 as a user who is dbo.owner.
It seems to hang at the "SELECT text,ctext,encrypted,number from [DB_NAME].dbo.s...