Viewing 15 posts - 2,371 through 2,385 (of 3,060 total)
As a rule of thumbs there is no way of reusing PL/SQL code as Transact-SQL - provided code does something more complex than a "select column from table" or similar...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 3, 2009 at 11:27 am
sunil88_pal88 (8/29/2009)
No actually client wants like this only.Can we use locking for this
If your client insists and having into consideration an Employee table shouldn't have heavy inserting after initial load...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 30, 2009 at 9:48 am
x198yn (8/29/2009)
... what should i do as an administrator when i insert a record to the table all the clients can see this inserted record ...??
Nothing.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 30, 2009 at 8:53 am
thomas.garay (8/27/2009)
It must be able to be done some how...
Probably you are confused with Oracle transportable tablespaces - even there you cannot move around a single datafile.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 30, 2009 at 8:45 am
... including columns indexes, would you believe my wife wrote a functional version of that - never-heard-about-at-that-time - technology during the late 80's running in a old-n-good Wang/VS system?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 7:17 pm
611/612 are two SQL Server 2005 versions.
If all you need is to change collation in one database all you need is alter database command... check here http://msdn.microsoft.com/en-us/library/ms174269.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 6:33 pm
Did you check SSIS cast? http://msdn.microsoft.com/en-us/library/ms141704(SQL.90).aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 6:09 pm
MothInTheMachine (8/19/2009)
I still have the task of maintaning the relationship between the data items (master-detail for instance) but I think that can be done with an update script.
:ermm: please... do...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 4:15 pm
Rule #33: Never ever run neither DML nor DDL against production without having successfully tested it before.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 4:09 pm
In general I would trust SQL Server and say "job is not running" but if you are certain the job is executing... kill the session 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 3:58 pm
vijaysingh (8/28/2009)
Is there any way to merge all the tables with relationships from multiple Databases to single Database.
The simple answer is: Yes, everything is doable.
On the other hand, this is...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2009 at 3:04 pm
Jon.Morisi (8/25/2009)
http://msdn.microsoft.com/en-us/library/ms190940%28SQL.90%29.aspx
Did you find it by yourself or just copy/pasted from my second post? 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 1:00 pm
Msg 7312 is most of the time related to upper case/lower case Oracle side naming issue, privileges or even existance of the target table.
Executing storedproc below returns list of all...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 11:05 am
luckysql.kinda (8/25/2009)
My question is whether this can be used if the master database is corrupted.
No, it can't
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 9:29 am
luckysql.kinda (8/25/2009)
I didn't find any convincing posts on google
first google hit for "mssqlsystemresource database"... http://msdn.microsoft.com/en-us/library/ms190940.aspx
What is the basic use of this
trap curious people and, it works! 😀
Didn't you mother...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 9:25 am
Viewing 15 posts - 2,371 through 2,385 (of 3,060 total)