Susan

You'll have to help us out a bit more than that, please - how about an example?

Thanks

John

Derrick

I don't think it's possible to do it how you want to.  You need to create a new virtual server.  I'm not sure whether you'll be able to use the...

Dale

You haven't provided table DDL or sample data, so I can only guess.  You should write your query as a select statement first and then convert it to update if...

"When does a temp table drop.  Obviously when I do a DROP TABLE.  I'm assuming if I reboot the computer it also goes away.  Any other times?"

A temp table (at...

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...