Not working as in what - returns the wrong results, or gives an error? If the results are wrong, please provide in tabular form the results that you would...

I could ask you the same question. To verify the data that's going to be deleted, use the SELECT statement. To delete the data, use the DELETE statement....

Where are you connecting from? Are both nodes in the same subnet? It sounds like you need to ask your network people to sort your access.

John

When you attempt to connect, are you supplying the node name (or IP address) or the virtual SQL Server name? If you look in SQL Server Configuration Manager, what...

I've given you a SELECT statement and a DELETE statement. What more do you need?

John

There's your answer. Make sure that all databases (replicated or not) that are in Full recovery mode have regular...

The log file for which database - the publisher or the subscriber? Are all subscribers currently in synch with the publisher? What do you get if you run...

SQLserver_learner (12/29/2016)

---

i want to retain the rows that we get from this query and rest want to remove from table. So, do we have to prepare a delete query...

Not sure how we're going to get you the exact query when you haven't posted the required results based on the sample data. The CREATE TABLE and INSERT statements...

Well, if the database structure really is as you posted it earlier, you wouldn't get the error message you described - you'd get this one:

[font="Courier New"]Could not locate file 'dbname'...

Please post the command that you're attempting to run.

Simply taking backups of the transaction logs who aren’t in the...

You need double quotes for each file path that contains a space, not just one pair for the whole lot - something like this:

exec master..xp_cm dshell 'copy "\\server_a\D$\Program Files\Microsoft SQL...

Which bit do you need help with - checking the fragmentation or sending the e-mail? Use the dm_db_index_physical_stats function to get fragmentation levels. Use sp_send_dbmail to send the...

Rod

If you don't specify a collation when you create the database, it will indeed inherit the server collation. I'd say the most likely explanation for your situation is that...

MFlanagan 91357 (12/22/2016)

---

This is why I was thinking that a view created as SCHEMAB.TableA with a select that includes the WHERE clause MEMBERID in (1,2) would work. Since USERB has...