Profile of the user I want to send to

Profile of user who is getting my messages

Steve, I did not message from the profile directly. I simply clicked on the user...

If I was using native backups, I would script it myself to leave out the space when creating backups... Or simply don't have it create the path, give it the...

kschwid (2/13/2012)

---

I also stated before that I only use them for reporting, so there are no inserts or updates involved, using NoLock on some of the tables in my query...

I see a significant amount of places where you are creating triangular joins. I'm not sure how that is affecting your insert, but I would try to remedy those...

kschwid (2/13/2012)

---

Well in my case Stored Procedures are used for Reporting Purposes and no I don't care because you report on the day, week, month prior. So the data shouldn't...

kschwid (2/13/2012)

---

I don't think it will hurt for you to have nolock on.

Any stored procedures that I write I add that in, regardless of how long something takes to...

Some people use cursors, but I prefer the ROW_NUMBER solution:

;

WITH RowNumbers AS

(

SELECT columnA, columnB, columnC,

ROW_NUMBER() OVER (PARTITION BY columnA, columnB, columnC ORDER BY columnA, columnB, columnC) AS rn

FROM...

Is this what you are looking for? http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/04/20/clearing-the-recent-servers-list-in-sql-server-management-studio.aspx

Again, using a maintenance plan and using the cleanup task will allow you to specify the extension for files to delete (bak), an age (>90 days), a file path and...

Did you remove the subscriptions first?I always make sure that I drop subscriptions before removing a publication.

I actually create a job using the maintenance plan feature of SQL Server to do this. I create the plan that deletes all differential backups. I then go and add...

When you restore a backed up database, the server logins do not get restored. Only the database users. What you are doing is trying to remove a login...

I wouldn't say that when the native tool doesn't work either. We need to know why.

Are you 100% positive that you are set up that way on that server? Not trying to harp, just trying to verify that...

It could also be a permissions issue for your user on that instance?