say my PC Name is NITESH-PC. When I installed sql express it added NITESH-PC\NITESH to the logins.

I need to create a login for the user that is installing sql server....

thanks alot. That's exactly what I was looking for;-). How can I get the Windows User Name for example I want the user to be created like this:

SQL Server Name\User...

Hi Lowell,

this is my view

GO

/****** Object: View [dbo].[OSC_Users_Meetings] Script Date: 07/08/2010 14:15:35 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[OSC_Users_Meetings]

AS

SELECT DISTINCT m.MeetingID, m.Name, m.Description, m.Venue, mm.UserID

FROM ...

thanks again for the great advise. You program is a gem. it has saved me hours of research and development and it works so well;-)

Hey Lowell,

sorry to be a pain. I have a quick question. How do you deploy your application that uses this project?

Do you only display the connection form on the very...

awesome:Wow:. thank you. will do.

not to worry;-) I downloaded the SMO objects from here after quite a bit of searching:

http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

Will test the code today. Had a quick look and it looks great. This is...

Great. Thanks again. is the project attached to your previous post the updated one? Will let you know how I get along. You are a genius

I dont have those references available to me for some reason:crying: will do some more research and get back to you

Lowell I cannot thank you enough for your help and effort. I appreciate you sacrificing so much of time to help me. I hope I can return the favour one...

Thank you Lowell. I will try that now. You are a lifesaver:-D

I would really really appreciate it if you could do a sample of that form for me as I...

Hi again Lowell,

Please help me. I've seen examples of how to add all sql servers on a network into a combobox. How can I list all instances of sql server...

wow. that looks great Lowell. Please can you point me to an example of how to create that form, or even some code of your own. If I could do...

Hey Guys,

I found this link which is very helpful:

http://msdn.microsoft.com/en-us/library/49b92ztk(VS.80).aspx

I have also acquired Visual Studio Team Edition over the past week. So I am now able to create Installer Classes etc.

The...

thanks Lowell.

That's a great idea. Is it the preffered way though? Also, say a client has SQL server installed on a server somewhere. Then the client installs my app on...