So when I use SSMS to exexute the procedure and I enter the Login it puts a single ' in front of the Sample/abc when I go to enter the second parameter for the database. So it looks like 'Sample\login; it works if I go back up and manually change it! How can I keep out the single ' before the string?