I don't think you will be able to do that. However you could create a function in Access that duplicates the functionality.

Why not create a View with the date fields...

I'd probably be even more lazy(?). Since I use Visual Studio for all my dev work I would simply create a project with all the files. Then have Visual Studio...

lambje,

What "Gary" are you refering to? 🙂

I was responding to Gary Billins question on Excel files only. For text files I would use BCP as stated above. But for...

I've always just used a macro in Visual Studio for this. I don't know of any tools that will do this for you though. Plus I probably wouldn't like their...

As Allen stated you need to use the square brackets and you should be OK. The only place I have found where this doesn't work is when you are using...

I think what I would do is create a temp table and do an insert of the table name and date.

IE:

DECLARE @SQL nvarchar(4000)

  ...

Buddy,

Since you don't have "BEGIN" and "END" on your error block he will never get to the second query! 🙂

mcmcom Give this a try....

CREATE PROCEDURE...

Noise words are stored in a text file.

FROM BOL: SQL Server includes a standard list of noise words in the directory \Mssql\Ftdata\Sqlserver\Config

If you are having troubles with the queries...

Also,

You will want to use Snapshot replication for Views, SP's, and Functions(SQL 2K only) as you can simply update the snapshot and replicate it out.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr....

I don't know of anyway to do that. Why do you need it to be separated?

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

If you open Enterprise manager on the machine that gives you the error and then go to the Replication Monitor and check the refresh rate settings you will find that...

Give this a try...

IF NOT EXISTS (SELECT srvname FROM master.dbo.sysservers WHERE srvname = <ServerName>)

EXEC sp_addlinkedserver <ServerName>

GO



--now do the mapping from local machine to Servers remote...

canguru,

In SQL Server the ONLY way you can guarantee that the ordering of your resultset is correct is to put an ORDER BY clause on your select statement. There are...

Gary,

If you want to create/get data from Excel use OPENDATASOURCE. It is by far the easier way to go. The only problems I have had is that I have to...

Personally I would use BCP to pull the data in and then push it back out.

Something along the lines of...

 

SELECT @SQL = 'bcp...