Viewing 15 posts - 271 through 285 (of 644 total)
maheshkrishnas (5/7/2012)
Hi all,I am new to sql server, How to write a trigger which stops the DML operation on a table for particular time...
Can anyone help on this......
As suggested...
May 10, 2012 at 5:12 am
panwar.jt (5/10/2012)
In few case both option giving different result set in case...
May 10, 2012 at 3:35 am
jyoti.patel (5/9/2012)
Two sql server 2005 instances are configured by Active\Active cluster configuration and working fine but every day we dont know what happen i saw the email like"SQL is...
May 9, 2012 at 4:48 am
Sony Francis @EY (5/9/2012)
Any way other than replication ?Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!
Seriously ??? You said that you are using linked server already to get...
May 9, 2012 at 4:35 am
shailesh.thapliyal (5/9/2012)
"failed with the following error: "ORA-00942: table or view does not exist". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameter not set correctly,...
May 9, 2012 at 3:55 am
Sony Francis @EY (5/9/2012)
May 9, 2012 at 3:48 am
ramrajan (5/8/2012)
asa
I think he wanted to write asap, but before writing "p" he got something even more important to do 😀
May 9, 2012 at 3:36 am
andymay-496937 (5/8/2012)
The 2 servers are built the same, 1 is live the...
May 9, 2012 at 2:37 am
manju.ccc (5/9/2012)
Thank you guys.I solved the porblem.
:-D:-D
Care to explain what was the issue 😉 ?
May 9, 2012 at 2:31 am
vahid.arr (5/9/2012)
May 9, 2012 at 2:24 am
nick.mcdermaid (5/8/2012)
What about simply creating a SQL Server Job with a step of type CmdExec to...
May 8, 2012 at 5:06 am
SQL Developer's work is to write sql queries for differnt processes/applications. It includes writing stored procedures, triggers, functions etc. You'll need to learn the sql syntaxes to write the queries....
May 4, 2012 at 4:23 am
Larry Page(Ehsan.Akbar) (4/27/2012)
before i thought we can use linked server for increasing performance.
so suppose you have a huge data like google ,how you can get best performance?
what is...
April 27, 2012 at 5:18 am
Larry Page(Ehsan.Akbar) (4/27/2012)
vinu512 (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
what about update?
You need performance...right??
The best performance you can get is by getting all the data on 1 server and then perform whatever actions you...
April 27, 2012 at 5:04 am
Viewing 15 posts - 271 through 285 (of 644 total)