Viewing 15 posts - 11,791 through 11,805 (of 18,923 total)
Have you seen all the possible variables??? gonna take quite a while to create this script... assuming you can access all those values.
Couldn't the application generate the log using the...
September 13, 2006 at 1:09 pm
The drop trigger didn't work either???
That's what made the most sens in all of this.
September 13, 2006 at 1:08 pm
Much faster to use a triangular join on a numbers (tally) table...
Insert into .... Select ...
from products inner join dbo.Tally on Quantity >= Tally.NumberID
September 13, 2006 at 12:12 pm
Just register the server in management studio and you'll be fine.
September 13, 2006 at 12:11 pm
I looked at the script. Not much help there. It basically creates the new table on the secondary file group, remake the constraints and other objects, insert the data, drop/rename.
Nothing...
September 13, 2006 at 12:06 pm
And why don't they have a clustered index (best/worst pratice)?
September 13, 2006 at 11:02 am
So your column was called _wa_sys(*?"/*("!/&"/%9856786324??????????
September 13, 2006 at 10:58 am
Create a table like UsersHistory
DateHistory smalldatetime not null default (getDate())
Total int not null
The query to insert the data :
Insert into dbo.UsersHistory (Total)
September 13, 2006 at 10:43 am
All I can find is that this happens when the stats was manually created. It then becomes a valid dependant object that must be dropped first (a little like schemabinding...
September 13, 2006 at 9:52 am
Thanx for the script. Too bad we can't figure out why you need the script in the first place.
September 13, 2006 at 9:29 am
Alright, pls post it back once you get it working.. I'm sure somebody else is gonna need this someday.
September 13, 2006 at 8:43 am
Don't know about the question, but this is working on my PC (2005)
change sys. to dbo. in 2000.
Declare
@SortOrder as varchar
September 13, 2006 at 8:41 am
As for the setting change, I have no idea what it could be... I'm sure there's a way but without the exact error message I can't search in that direction.
September 13, 2006 at 8:25 am
I can't make the full script for you, but this can get you started pretty good. All that is left is generating the drop commands and executing them :
September 13, 2006 at 8:24 am
Viewing 15 posts - 11,791 through 11,805 (of 18,923 total)