Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
changlinhngulamtk20
Starting Member
3 Posts |
 Posted - 2010-10-30 : 03:41:15
|
| i want to creat an application by c sharp to remote sql server 2005 security. But i don't know what's object in .net can suppost t-sql language. please help me i being need it. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-10-30 : 09:07:46
|
| You create a connection and send a command to the server which then returns a result.Have a look at the tutorials onhttp://www.csharp-station.com/Default.aspx==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
changlinhngulamtk20
Starting Member
3 Posts |
Posted - 2010-10-31 : 10:34:33
|
| thanks nigelrivett !i mean i want to cread an application that it can manage some task of sql server such as user authentication or creat an account and assign the right for them but not using sql studio management. help me now thank. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-10-31 : 11:40:49
|
| That link should show you how to create an application to interact with sql server. Once you can send sql and receive a resultset you should be able to do whatever you wish.To create an account (login) you could use osql or sqlcmd if you don't want to use management studio.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
changlinhngulamtk20
Starting Member
3 Posts |
Posted - 2010-11-03 : 00:30:47
|
| thanks nigelrivett for your help. i think i found. visit this linkhttp://msdn.microsoft.com/en-us/library/8t72t3k4.aspx |
|
|
|
|
|
|
programming an application to remote sql server