Viewing 15 posts - 6,226 through 6,240 (of 6,353 total)
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
not available in Sql 2005 but its a sql 2008 feature. and only can be used in same domain
sorry my mistake, I went into the forums via the daily...
July 22, 2011 at 1:24 am
have a look at a central management server,
under registered servers --> database engine --> central management servers
add in your central server, then register any child servers under the central server
then...
July 22, 2011 at 1:00 am
Viewing 15 posts - 6,226 through 6,240 (of 6,353 total)