typically, you want to insert into a temp table, so you get everything in a single table for ease of review.

this seems to have worked for me:

USE master;

GO

IF (SELECT OBJECT_ID('Tempdb.dbo.#TBHELPUSER'))...

in a programming language, you could use a thread pool and spawn mulktiple asyncronous commands, like the code you are using to refresh each excel spreadsheet.

you'd have to convert from...

how many instances of SQL are installed on your dev machine?

could it be that another isntance is answering the default port of 1433?

What i'm saying is that maybe you changed...

if the SQL browser service is running, any connections that ask for the server will be directed to the proper port.

if you stop the SQL Browser service, then the port...

a table created inside a procedure is destroyed when the procedure completes.

if you want to a proc to load your data, you have the following options:

1. have the same procedure...

JoseACJr (7/12/2012)

---

Hi everybody,

I will create an application to list the columns of my database, what the difference between sys.columns and syscolumns ?

They are not tables? which tables these views...

and a code example of what Jason was talking about:

sp_msForEachDB 'select ''?'' AS DatabaseName,

...

if you leave the schema name to auto resolve, does it work, like this?

SELECT * FROM [LINKSERVER_1].[ActualDBName]..DAYPART

deprecation?

last i heard, the views were there to stay, but could be changed;

some article i read said any changes would be things like adding columns to the end of the...

the opposite question for me really, is what advantage would there be to use the information_schema instead of the sys tables?

typically there's more information available in the SQL specific...

here's what i use , a procedure i built called sp_UglySearch.

since you are searching every table/column for text, this is slow, and any tables with a Million rows are going...

i took over a screwed up database like that once; the table names and column names had been obfuscated, i guess in order to protect someones proprietary schema; they took...

sounds like two things: this database was upgraded from SQL 2000, and someone had ran "EXEC master.dbo.sp_configure 'allow updates', '1'", and deleted the row from sysobjects directly, without deleting the...

CREATE PROCEDURE [dbo].[DR_Premier_PO_O]...

you are just missing the word create; after that my syntax issues went away.

i got 4 errors total, and only the last matched your error.

Msg 156, Level 15,...