SQL Express Life Saver

Note to self: osql is a life saver.

osql -E -S MACHINENAME\SQLEXPRESS
1> EXEC sp_grantlogin 'MACHINENAME\ACCOUNT'
2> GO
1> USE databasename
2> GO
1> EXEC sp_grantdbaccess 'MACHINENAME\ACCOUNT'
2> GO
1> exit

Helpful links:

ASP.Net Forums
MSDN Forums

Microsoft TechNet

These three links just saved me!

Labels: , , , ,

Posted by Rob at 2:33 PM | 0 comments | Click here for a permalink to this entry.

Deploying a SQL Database

Scott Guthrie: "The good news is that this week the SQL Server team published the release candidate of a new SQL Server Hosting Toolkit that will make it much, much easier to deploy your SQL solutions remotely to a hosted environment. The toolkit allows you to work with SQL Express, SQL Server 2000, and SQL Server 2005 databases locally, and then easily transfer your schema and data and install them into a shared hosting remote SQL Server account."

Labels: , , ,

Posted by Rob at 10:36 PM | 0 comments | Click here for a permalink to this entry.

About

Rob Fahrni has been a Software Developer for 20 years. He's developed DOS, Windows, Linux, iPhone, and Palm based applications in C, C++, Objective-C/Cocoa, C#/ASP.Net, and, yes, even BASIC...
About >>



CrabApples.NET Home Kim Fahrni, Hacker Widow Haileigh Fahrni, My Culinary Journey Taylor Fahrni, Goin' Buggy Jerry Fahrni, Pharmacy Informatics and Technology

Apple Core Labs, LLC RxCalc - A Pharmacokinetic Calculator for iPhone

Etcetra

I work at Pelco. The opinions expressed here are my own, and neither Pelco nor any other party necessarily agrees with them.

Subscribe to ATC Send e-mail to Rob Follow me on Twitter. My Profile on LinkedIn.