David Atkinson (8/6/2015)

---

What problem do you think it might...

undo

This certainly looks like a tool that can provide some good benefit. I will have to give it a test drive.

Jeff Moden (8/5/2015)

---

fnndala2 (8/5/2015)

---

I have the following SQL-Query:

CREATE FUNCTION fn_SelectTopEmployees ()

RETURNS TABLE

AS

RETURN

(

SELECT TOP(10) EmployeeID

FROM Employees

);

When I run the query, how many times between 1...

Luis Cazares (8/5/2015)

---

Grant Fritchey (8/5/2015)

---

Well, Luis is right. It won't run and therefore will return zero rows. But that question is an extremely poor demonstration of SQL Server knowledge. However,...

Paresh Motiwala (8/6/2015)

---

I could not check permissions since our service account cannot log on to the box....I do suspect however that, it is the problem.

Anybody can...

About the simplest method would be to do this:

sys.sp_MSforeachdb @command1 = N'use ?',

@command2 = N'EXECUTE [sourcedatabase].[sourceschema].SearchAllTables'

Or write a cursor that will call the execution of your stored procedure.

Or do...

It's pretty easy to change. It's just a script.

If you try changing it otherwise, then yes it can become annoying.

http://bit.ly/LufgiB

and

http://bit.ly/eocpXA

They can own a schema as well.

We started with:

sqlinterset (8/4/2015)

---

I need to fetch data from one SQL server to other SQL Server. One solution is to create linked server and other is to use SSIS....

Lips

Ed Wagner (8/5/2015)

---

Lynn Pettis (8/5/2015)

---

Sean Lange (8/5/2015)

---

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against...

And in "back to the countdown" news:

49,913 posts with this post:-D

pooping

Sean Lange (8/5/2015)

---

Or better yet - don't forget to...