i've done something similar two differnet ways; i ended up making an application because i had more control;

you can get a list of servers several ways, form osql to using...

the devil is in the details, so "it depends"

this:

/*

DO SOME SQL LOGIC

*/

depedning on what that is doing, or going to do, you might not need a loop or tally table...

show us the script you are using...are you tal\king into consderation non-standard database names?

ie select * from [My Database With Spaces Or a Reserved Word].dbo.sys.objects?

you have to define a table with the proper columns before you call the procedure.

if your proc, which is using dynamic sql, returns a different number of columns depending on...

that would limit all connections, whether from your web app or form Management Studio; remember your web server will try too pool connections, so it'll be reusing some of...

Denesh Naidoo (8/23/2010)

---

Hi All,

Working on SQL Server 2005.

Have a query that has a WHERE clause as follows:

WHERE (Documents.Flags & 0x18)=0

Can someone please explain the & 0x18 part which I have...

monietamarind (8/23/2010)

---

I am trying to Connect To Database Engine. I was able to get connected before. But, I am not able to do so now. The SQL...

Parthi i mentioned before that while you can use CAST and CONVERT on the columns, it's best practice to stay within the same datatype by using DATE ADD/DATEDIFF functions;

when...

VNC/Remote Desktop/ TeamViewer / PCAnywhere / GoToMyPC are desktop viewers,

you don't need that.

SQL Server Management Studio is the interface of choice and is backwards compatibile, and can connect to ...

it's pretty basic:

--get just the data we need to...

ricardo_chicas (8/20/2010)

---

Ok lets do this, forget about the original problem

what I really want to know is for a suggestion on what is the best way to retrieve large amount of...

newbieuser (8/20/2010)

---

Hi friends,

I'm creating an application role, the password for the role should be read from a table. Is it possible to do this?

The table need to...

chopping stuff up with substrings not hard to do...but we need...

ouch; Steve's analysis is right on....it'll be tough to determine what changed and what should be kept, especially if competing applications used two different databases at the same time.

Lesson i...

sharp analysis drew... i would not have inferred the regional settings affecting the implicit conversion.

here's my version of the procedure, which seems to return the data with seconds:

CREATE FUNCTION [dbo].[fn_JulianDateConversion](@JulianDate...