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

You've posted in the SQL Server 2008 forum, so I assume that's what you're using. If so, search this site (or elsewhere) for Running Totals. If you're on...

Once you've got the views created, the rest is easy. All you need to do is grant SELECT on the views to all users, and revoke SELECT on the...

The problem here appears to be that you've got too many (more than one, that is) different pieces of information stored in each value of nine_data. Such denormalisation may...

It gives info for all active sessions. If you have the patience, you can look at the stored procedure definition and try to find the part that retrieves tempdb...