Viewing 7 posts - 31 through 38 (of 38 total)
Just out of interest, having been through the world of pain that is changing the collations on columns of a table in a database that had a goodly few GB...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 6:09 am
Sorry marfu, but without seeing the structure of your tables, indexes etc it is difficult to see why this could be happening.
How big is the actual table? If you look...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 6:03 am
Is it SQL 2005? Is the proc in a schema that the profile that the app is using to access the DB can't see?
In order to eliminate security "issues" temporarily...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 5:56 am
From what I could see, Gail was trying, very patiently, to give sound advice to someone who, if they really did have all those qualifications, would have known what to...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 5:48 am
I tend to agree with ybol.
Are you using a 32 or 64 bit server btw?
If you use an average of 2GB per instance, that will allow 5GB left over for...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 5:25 am
You can also set it to deploy to the MSDB of the server. this is the only way I found - other than to change the security settings of the...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
June 2, 2006 at 7:38 am
You can choose the database collation in 2K according to your requierments. RebuildM.exe will wipe out all your logins, DTS packages etc. TBH you are better off changing the default...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
May 26, 2006 at 4:28 am
Viewing 7 posts - 31 through 38 (of 38 total)