Viewing 15 posts - 42,211 through 42,225 (of 49,571 total)
There are no errors there. That's SQL's startup messages. You need to connect to SQL from another command window, using sQLCMD and restore the database.
Does the restore database give...
December 22, 2008 at 1:36 am
ps (12/22/2008)
December 22, 2008 at 1:35 am
They are SQL reserved words. Hence management studio highlights them as such.
December 22, 2008 at 12:44 am
TheSQLGuru (12/21/2008)
PLEASE check Books Online before posting questions!
Read the manual? What a radical, way out idea!
December 22, 2008 at 12:43 am
Your screen shot is too compressed to be readable. Please copy the error from the command prompt and paste it in a reply.
December 22, 2008 at 12:43 am
30 sec is still a long time for a query to run, unless it's some massive report. I don't know many users who will be happy waiting 30 sec or...
December 22, 2008 at 12:29 am
SQL 2000 doesn't have any native encryption functions. If upgrading to 2005 is not an option, you'll have to do the encryption and decryption in the front end app.
December 22, 2008 at 12:25 am
That means that the number of columns in the table don't match the number of values in the insert. What's the definition of the Log table?
In general, it it recommended...
December 22, 2008 at 12:23 am
Jeff Moden (12/21/2008)
So, what is it, supposedly?
Spatial, xml, hierarchy, etc. The 'rich' data types that some bright spark in marketing thought meant SQL was evolving beyond a relational database. I'd...
December 22, 2008 at 12:22 am
Ahmad Osama (12/21/2008)
however am unable to restore.....
For what reason?
December 22, 2008 at 12:07 am
Krishna_DBA (12/21/2008)
December 21, 2008 at 8:40 am
Krishna_DBA (12/21/2008)
I have above e books with me if you need any. I can upload them for you.
Those are all copyrighted materials, and hence it is illegal to freely distribute...
December 21, 2008 at 8:06 am
RBarryYoung (12/21/2008)
Yes, but Microsoft is the one who started this "Beyond Relational" campaign with SQL Server 2008.
Meaningless marketing drivel. I doubt the people who though that up even...
December 21, 2008 at 8:03 am
Not possible without recreating the table completely, which is what Management Studio does.
Why do you need the columns in a specific position? Technically, column order has no meaning in SQL....
December 21, 2008 at 7:59 am
Krishna_DBA (12/21/2008)
December 21, 2008 at 7:53 am
Viewing 15 posts - 42,211 through 42,225 (of 49,571 total)