Viewing 15 posts - 6,226 through 6,240 (of 6,355 total)
The instance will go into shutdown and not accept any new connections during the fail over. Any connections which are currently running at the point of failure will terminate....
October 19, 2011 at 2:19 am
SQLServerManager10.msc for 2008 and 2008 R2 and I think its 9 for 2005, but as I dont have any 2005 servers any more I cant confirm on that.
October 19, 2011 at 2:14 am
Indexes and FK's can be done by doing schema.tablename after tables
Might have to write some sort of loop when using GCI/DIR to get the list of tables to drill in...
October 19, 2011 at 2:10 am
Sorry I should of mentioned about the Add-PSSnapin parts, the server where the PS1 file was running from was a none SQL machine so it didnt have the SQLPS.dll's registered...
October 19, 2011 at 2:05 am
Assemblies and Users are under at the same level as tables and storedprocedures
Indexes and FK's I have yet to find myself as once your in tables you cant go any...
October 19, 2011 at 2:02 am
i use powershell to script the object definitions out to a .sql file on a nightly basis so that developers dont need any permissions on the live db.
couple of ways...
October 18, 2011 at 7:52 am
Yeah I can connect to the SSIS via SSMS and the SSIS package is there, the SSIS package was created by the maintenance plan wizard, it only rebuilds a few...
October 5, 2011 at 4:59 am
that was the problem, i didnt have a measure.
i have created a new named query which generated the percentage value and mapped it to a measure and dimension to process...
August 31, 2011 at 9:35 am
at the moment we are using system center service manager and I have to say it is one of the worst call logging systems I have ever worked with.
before this...
August 19, 2011 at 2:09 am
if your using something like McAfee AV then there is a block mass mail worm option which needs to be disabled before you can send mail.
if you have an ePO...
August 19, 2011 at 2:03 am
one thing i would say is that sometimes a -2 spid wont die.
we had a similar situation with biztalk where it issued a dtc connection, became -2 and killing the...
August 19, 2011 at 1:59 am
i take it you have a full dev / uat / train or systest / production environment and that things need to go from dev to uat to systest to...
August 19, 2011 at 1:51 am
think i may have just answered my own question
extensionsettings in subscriptions table, dont know how i managed to skip over that.
August 3, 2011 at 2:45 am
I would have to agree with Murray on this, it would have been nice to know which level of the product it relates to.
All the media I have been working...
July 29, 2011 at 2:35 am
Viewing 15 posts - 6,226 through 6,240 (of 6,355 total)