Viewing 15 posts - 691 through 705 (of 928 total)
GilaMonster (8/2/2011)
BrainDonor (8/2/2011)
I was seconded to a company in Zimbabwe many years ago for 6 months.Before or after around 1997?
Long before - mid-80's if I recall correctly. Had some good...
August 2, 2011 at 4:54 am
GilaMonster (8/2/2011)
Tom.Thomson (8/1/2011)
August 2, 2011 at 4:03 am
Ghanta (7/27/2011)
Anyone has Procedure to scramble data like addresses
Do you mean column encryption? http://msdn.microsoft.com/en-us/library/ms179331(v=SQL.100).aspx
Ghanta (7/27/2011)
July 28, 2011 at 1:29 am
Anybody in here going to the SQLBits gathering in Liverpool, UK http://www.sqlbits.com/?
BrainDonor.
July 27, 2011 at 4:57 am
ISNUMERIC is not always the best way to check that a column contains (what you may think is) a purely numeric value.
See http://www.sqlservercentral.com/articles/IsNumeric/71512/
BrainDonor.
July 4, 2011 at 8:59 am
June 9, 2011 at 1:18 am
Right-click on a table name and Design works here (although this is 2008R2, I'm sure it existed in 2008 also).
Do you see the option, or do you get an error...
June 9, 2011 at 1:16 am
crazy4sql (6/3/2011)
[
I get "The database 'TestDB' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported."
you might have ignored...
June 3, 2011 at 8:10 am
Change is Required (6/3/2011)
no we can't restore 2008 backup in 2005 backup
Correct - there are an inordinate number of discussions here showing why it cannot be done. It is never...
June 3, 2011 at 7:53 am
crazy4sql (6/3/2011)
use copy database wizard
That was an interesting suggestion, that I've never come across before, so I thought I'd give it a go.
I get "The database 'TestDB' cannot be opened...
June 3, 2011 at 7:42 am
Didn't mean to sound like I was just copying you Gail - five minutes between pressing the 'Reply+' button and the 'Post Reply' button can make a world of difference!...
May 23, 2011 at 2:04 am
Now I know this isn't possible....
Then you've answered your own question - it isn't possible. R2 is a later version than 2008 and you can never 'downgrade' a database. The...
May 23, 2011 at 2:00 am
Welsh Corgi (5/16/2011)
Marking the columns as unused is not that costly but when you rebuild the table you are going to take a hit so...
May 19, 2011 at 1:34 am
Not that I think it makes any difference, but you have posted this in the SQL Server 7, 2000 forum. I assume you meant the 2005 forum.
The problem is to...
May 12, 2011 at 5:35 am
Viewing 15 posts - 691 through 705 (of 928 total)