Thanks Lowell and bitbucket.

Finally i got it working. Everything is in place now, including sample databases 🙂

Though i have msde, standard and enterprise of 2000; and msde, enterprise of 2005...

Hmmmm. I've XP SP2 on my laptop and it wont allow me to use my LAN resources when i'm on wireless network (i am unable to even ping other resources)........

Posted twice!!

http://www.sqlservercentral.com/Forums/Topic621581-1281-1.aspx

THis is not an issue of Sql Server....

It relates to network. Once you're on your wireless network, you wont be able to connect to your LAN or access other machines...

Thanks Lowell. I was just wondering how much they've squeezed to make an express edition in just 50 MB where as enterprise one takes more than 800 MB.

This one has...

i installed the 53 MB Express edition.. I dont see the VSShell folder under BINN folder.. also searched for ssmsee.exe on my hard drives... didnt find it..

I had also installed...

probably u may want to go through these links... similar issues..

http://bytes.com/groups/ms-sql/79584-remote-database-updates-take-long-time-complete

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/ab74608f-6e5f-4afb-be61-e9ee55420889/

getdate()

I completely agree with Michael. Worst part is you'll present inconsistent data to your users. You got to understand the dangerous part of it. Users tend to take help of...

You may want to browse through few more informative sites on that besides the one given by David.

http://www.sqlmag.com/Article/ArticleID/25710/Synchronizing_Logins.html%5B/url%5D

Also, search for synchronizing logins on SQLServerCentral.

The example you gave supports you. will give it a try on monday to see the results(just to 'see' it with own eyes ). But definately clarifies my doubts.

🙂

1. I assumed you database has not crashed. You just needed to restore the full database, the backup of which was already available to you. Methods i wrote was sufficient.

2....

1. To copy data within two databases residing on same server, its rather easy...

something like

Select * into db1.dbo.DestinationTable from db2.dbo.SourceTable

Do keep in mind that only table structure and data...

i would suggest you to design the spreadsheet in the format of X rows and Y Columns and remove all those merged columns.

Make sure you enter the raw data in...

I'm all the more confused. I believed what Adi said in his post. But again searched through internet when Ewan raised the issue.

Here are some of the exceprts :-

Each time...