From Books Online, here's something that might rain on your parade:

"Database snapshots are available only in the Enterprise Edition of Microsoft SQL Server 2005"

And here's something that definitely will (my italics):

"Multiple snapshots...

I think the issue here is that there is a new table created for each new day.  Therefore, to have replication, you'd have to keep creating new articles and initialising...

Please don't post the same question on different forums.  Follow the thread here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=347395

Joe

Just substitute the name of your table for @t in the query.  Obviously you will also need to change the column names to match yours.

John

What defines the order of the values in your column?

John

You're spoiling him, Amit!  Note that your query doesn't account for the possibility that there may be companies with no branches defined in Table2.  You can solve this by using...

Ed

In Query Analyzer, change to Results in Text and run the following query:

SELECT 'SELECT TOP 10 * FROM ' + USER_NAME(uid) + '.' + [name]

FROM sysobjects WHERE xtype =...

Ed

I'm stumped.  Try putting USE MyDB at the beginning, where MyDB is the database in question.  Otherwise, do you have a case-sensitive collation on your server?  If so, did you...

Bakr

Yes, a trusted connection is the same thing as using Windows authentication.  I'm not quite sure how it would work - you'd need to experiment.  But I think either that...

Ed

The first query returns all tables with the name specified; the second returns all tables owned by the user specified.  If you do SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE =...

Ankur

Is this a homework question?  What have you come up with so far, apart from the cursor method?  Here's a hint: try writing it as a SELECT statement before you...

Ed

It sounds like the table doesn't exist at all under any owner, then.  Have you refreshed the window in Enterprise Manager?

Try this query:

SELECT TABLE_SCHEMA, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE =...

Here are some things you can try:

(1) Create your stored procedure with encryption so nobody can read it

(2) Use DTS instead of bcp

(3) Use Windows authentication instead of SQL

John

Ed

OK - so the object in question is definitely a table and not a view or stored procedure or function?  What is the result of this query:

SELECT TABLE_SCHEMA,...

Ed

Who does Enterprise Manager show as being the owner of the table?

John