Mhlewis (4/29/2011)

---

The MS Press Test Kit book comes with an evaluation edition of SQL 2008 which includes all of the features that you can be tested on. I believe...

Mhlewis (4/29/2011)

---

The MS Press Test Kit book comes with an evaluation edition of SQL 2008 which includes all of the features that you can be tested on. I believe...

Hi Mhlewis,

Congratulations!!!

I am also planning to pass this certificate. Can u pls tell me which sql server 2008 edition will be the best for preparation?

Thanks in advance!

Hello, got solution?

Hi Cláudio,

Kindly provide some sample of your both SPs.

Please try this,

IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'ServerName')

begin

EXEC sp_dropserver @server=N'ServerName', @droplogins='droplogins';

end

GO

EXECUTE...

Are you able to connect to linked server(s) through SSMS?

Also check if there is any firewall effecting? Is all your server running with default port; OR any of ports are...

Network connectivity may be the problem, but not all the time.

When you are transferring data from SQL Server to ORACLE or vice-versa, data need to convert from their type to...

and This is the Error am getting occasionally

Could not find server 'ServerName' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. Cannot find the object "TempRelease" because it does...

Hi manikandan,

You can find more detailed description regarding your question here with, including described by sudhanva.

1) http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1052737,00.html#

2) http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/[/url]

With the same, this is just a quick reply from myside with hope...

It also depends on how well...

You can use CASE Statment here. See CASE (T-SQL) in BOL, it may help u..

I hope i could get proper idea regarding ur question as i m in hurry right...

There are plenty of ways to do so..

- You can create Stored Procedure with cursor

- You can create queries with subqueries

- create queries with CASE

did u try anything?

Hi,

1st of, all there is a field missing in ur table definition. I have corrected here with.

CREATE TABLE [dbo].[LINKS] (

[LINKS_ID] ...

Bob:

You are right! Actually i had different idea in my mind. I thought the code give here was just for our reference; and the actual requirement is just this calculation...