Viewing 15 posts - 2,371 through 2,385 (of 3,061 total)
how long a comparable size FTP takes in between the two servers?
September 7, 2009 at 7:10 am
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...
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...
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.
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.
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?
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
August 29, 2009 at 6:33 pm
Did you check SSIS cast? http://msdn.microsoft.com/en-us/library/ms141704(SQL.90).aspx
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...
August 29, 2009 at 4:15 pm
Rule #33: Never ever run neither DML nor DDL against production without having successfully tested it before.
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 😉
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...
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? 😀
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...
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
August 25, 2009 at 9:29 am
Viewing 15 posts - 2,371 through 2,385 (of 3,061 total)