Viewing 15 posts - 16 through 30 (of 50 total)
ichbinraj (5/5/2009)
I am planning to do on-line Reindex for 100 tables one by one.
Is it possible to put them in script like when 1 st table done...
May 5, 2009 at 12:41 pm
Jules Bonnot (5/4/2009)
May 4, 2009 at 2:18 pm
Jules Bonnot (5/4/2009)
May 4, 2009 at 1:57 pm
Jules Bonnot (5/4/2009)
So mirroring and log shipping will allow me to run schema updates on the secondary or slave DBs whilst the transactional replication will continue feeding the uneffected tables?
If...
May 4, 2009 at 1:40 pm
My vote would go for separate databases, based mainly on your statement that each database represents a different business unit, with its own hours, etc. If you try to...
May 4, 2009 at 12:22 pm
So, that's the equivalent of
update tbl_pages set pdf_e ='n'
where page_id =3 and image_id is null and pdf_e is null and pdf_f is null and text_e like 'orginal text'...
May 4, 2009 at 12:18 pm
Then what's probably happening is that the management window is updating multiple records at a time, based on what it sees as the primary key to the table. When...
May 4, 2009 at 11:45 am
Have you tried issuing the update statement, for the same row, from T-SQL?
May 4, 2009 at 11:37 am
troy.hodge (5/1/2009)
Our...
May 1, 2009 at 3:05 pm
What is the error message that you are getting?
When you set up the linked server, there's the Security tab where you specify how the login will be made...
May 1, 2009 at 5:25 am
Junior_DBA (4/30/2009)
I have some third party applications like geophysics ones, that runs with SQL database. When this apps were installed in our servers automatically creates its own database structure,...
April 30, 2009 at 1:35 pm
Krasavita (4/30/2009)
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated. What is wrong...
April 30, 2009 at 7:11 am
vrabhadram (4/30/2009)
hi to all,how vbscript is useful for sqlserver. please provider some information.
VBScript doesn't really apply to SQL Server. VBScript is a scripting language, usually used for client-side code...
April 30, 2009 at 6:03 am
Tara (4/29/2009)
April 29, 2009 at 2:22 pm
gaganks (4/29/2009)
Can some one help me in building a Simple SQL scripts which can be used to moniter the Error Log (Sql server)
As my monitering Tool does not read...
April 29, 2009 at 8:41 am
Viewing 15 posts - 16 through 30 (of 50 total)