dakshinamurthy (4/11/2008)

---

Thanks for the instant and very usefull reply.

I have a doubt, please dont mind if it is a stupid question or a silly question, because i am new to...

EXEC and EXECUTE are identical - one is just shorter than the other. sp_executesql supports parameter substitution and it generates execution plans that SQL Server can more readily reuse...

dakshinamurthy (4/11/2008)

---

Hi,

I have a server, which is used for replication and this server has been made as Publisher server. In...

Jeff Wood (4/10/2008)

---

Our company uses an application that has so many problems that the support staff are running ad hoc updates against the database constantly. Standard procedure is to wrap...

Unfortunately you cannot migrate directly from 6.5 to 2005. You'd have to migrate to SQL Server 7 or 2000 and then migrate to SQL Server 2005. Check out...

That's because you're doing a right outer join and the...

Since you're using SQL 2000 you could potentially use a combination of xp_dirtree and xp_getfiledetails to automate this. Here's a basic template for what you'd need to do.

It's dependant...

The reason it's only working for one row is because whoever designed the trigger decided to design it to only work with one row (as long as CALLNBR is not...

Could you please provide a more detailed requirements specification? Additionally, the nature of the role, location and salary would be useful.

You might otherwise get inundated with emails from applicants...

jon (4/10/2008)

---

Hi.

I am having problems understanding the order in which SQL Commands are executed.

This came about when I wrote the following script.

If not exists(select * from sys.databases where name =...

Andras Belokosztolszki (4/10/2008)[hr

Unfortunately SQL Server 2005 Management Studio does not parse the contents of views/stored procedures, ... other textual objects. What it does is selects everything from the sys.sql_dependencies (on...

Andras Belokosztolszki (4/10/2008)

---

On SQL Server 2000 you can look at the dbo.sysdepends table, on SQL Server 2005 the sys.sql_dependencies.

Unfortunately neither of these system tables/system views are reliable, and many times...

You can try and use exec sp_depends 'P1'

But that isn't necessarily accurate - read up on sp_depends.

The more accurate way of doing this is by right-clicking on the procedure in...

Like I...

I'm not sure what...