SQL server runs as a service, so that assumes an install and a lot more.
for a portable type of application, you'd have to use a portable database; SQL Server Compact,or Access or SQLite or XML, for example.
Then you'd have change your data access layer to use that for the data source; whether it supports all the functionality you are assuming is in place or not is the big question;
I've use a pure XML solution before, which just used the built in ability of a System.Data.DataSet to load and save to an xml document.,
so procedures/functions/views would not be possible, for example. you could emulate their functionality in the app.
it really depends on the details, but it sounds like, without any other changes, you must add your database to an existing SQL instance, or install a new SQL instance with your app if it doesn't exist.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!