Don't agree with this answer for the same reason most people are talking about. You can define a primary key on a table variable which technically creates an index but...

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near (This represents items 1,2,3 as True, 4,5 as False.

Nice Question.

Not sure if or where it might be but I had the results to text include a lot of extra non printable data. Where if I opened it ( Been...

If the table is not too large I would reinitialize the subscription on Server2 with a new snapshot. This will allow it to be synced together.

The distributor will not...

Are you trying to rollback data or code in the database?

There are several ways other than a backup however a backup is typically what I take before I push...

mw112009 (5/22/2012)

---

This tool is great.

Unfortunately it does not allow you to select one or few tables for scripting. ( See attached JPG file )

Our database has more than 2000 tables...

Does this same behavior happen when you simply restart SQL Services without changing Nodes?

db_owner is required for the specific databases but I am pretty sure they cannot add a distributor and turn the option on for the database to be published. Once those...

It sounds like you are logged into the server directly, is this correct?

I don't typically log into the server. I run SSMS from my desktop and connect to the servers...

I might be misunderstanding your issue. The issue you are having is that you don't want to install SQL Server Managment studio 2008 on you local machine? What version of...

One other way that it could be done as well is

select status, count(status) as total, (select count(*) from table) as alltotal

from table

group by status

Yes, it will need a different file name.

logical file name tempdb_data1, physical file name T:\tempdb_data1.ndf

logical file name tempdb_data2, physical file name T:\tempdb_data2.ndf

etc...

dan_g (5/18/2012)

---

Q1. I want to write a stored procedure to change the filename. The file currently comes to the server that includes the timestamp.

For example: The file lands on

E:\Folder1\Filename_yyyymmdd_hhmmss.txt

and...

One of the things I have seen done is pass it in as a string with all the values seperated by commas and have the procedure either parse it accordingly,...

We had the same issue. I want to say it is the communication between the witness and the Principal. If there is a small delay that might cause a timeout...