I have Microsoft BizSpark subscription in which I received Azure credits as well. I created a Virtual machine on it and I am planning to install SQL Server Enterprise edition which I see available under Subscriber downloads page. Can I install it on my VM and host a website using this.
Can I also create users with sql authentication and assign them to multiple people in my team for making changes in sql script or do any development activities. Is it allowed?
Possible Duplicate:
Can you help me with my software licensing issue?
I was reading a topic in a book regarding sending database mail in sql server. But I found that in express edition DatabaseMails is not available.
So I started googling and found the link to enable database mail in sql server express edition.
http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx
In this article it was written "Now the only problem with this is that you have to get those 3 files from either standard or enterprise edition of SQL Server". Would this terminate license agreement of Sql Server express edition or it can be used in production without terminating license.
I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions.
I googled on MSDN and haven't got clear answer on this. It seems with googling that it is avaialble but not started when sql server is installed.
Few months back, I installed a sql server 2005 on one of my client machine. I gave him a backup option to take backup timely but he never took any backup.
Today he called me that "i m not able to see any record of mine." I visited at my clients system and saw that none of the record was present on the tables. There was not even a single row in any of the tables. Then I checked if he has any backup file which i found to be absent.
I asked him the reason what could be the possible cause. He said it might be due to virus.
After this I checked the size of mdf and ldf file and found it should be what it is. when i created his server mdf ldf file had 2MB of database now it is 83 MB and 193Mb mdf/ldf respectively.
This shows the data is still present in it but it is not being displayed.
What could be the possible cause and how can i restore all data back to my tables ?
I forgot W2K3 admin password. Is it possible to reset it
I am working on a project with my friends online as well as locally through connecting LAN.
I am using Windows Server 2003 that allows maximum 3 instances of remote desktop connections.
I have static Ip(when working on internet else local ip) through which all my team mates gets connected to my W2K3 instance and can work on their own desktop screen.
Now in this case all the 3 users are working on their own instances of desktop which is actually running on 1 system only, whether they are connect it online or on LAN.
But what happens sometimes is, if one of the user gets stucks at certain stage. Now i want to help him by checking his instance screen at my instance.
In this case all the 3 screens are situated at same system only. So I actually need not use internet for sharing screen as all the 3 instances are their only on the same system. So how would i access the other instance screen.
I need some such solution where i can minamize bandwidth(Internet) usage which a very very crucial for me at this point. Any software or some method.
Client machines are connecting thru Windows XP. Server Machine is Windows Server 2003.