Viewing 15 posts - 271 through 285 (of 1,137 total)
just a simple question, what is the collation for the user database that you are creating this function in
this is from BOL (Books Online) from the CREATE FUNCTION section
COLLATE collation_name
Specifies...
October 13, 2009 at 4:22 am
free_mascot (10/13/2009)
If your database is not on production or if you can manage little downtime on weekend. I suggest detach and attach would be better option to move your...
October 13, 2009 at 4:11 am
That is really strange. I done a T-SQL copy only backup using SSMS 2005. tried to do a restore. got a blank restore option, so couldnt select the backup to...
October 13, 2009 at 3:05 am
Now you habe me curious, i have 2005 and 2008 on my machine, going to check that out now. I am assuming that the copy only was. backup done as...
October 13, 2009 at 2:42 am
ipan_nugraha (10/13/2009)
i mean when i execute DBCC DBREINDEX it tooks 2 hour, table contain 4.000.000 row.
Not sure what I can suggest here, you are rebuilding the index. I could suggest...
October 13, 2009 at 2:27 am
Ok, I accept that, thanks for the clarification
October 13, 2009 at 2:07 am
This is from BOL (Books Online)
You can either modify the maintenance plan, as your biggest table is the maintenance plan history
or you can try running teh stored procedures manually.
Maintenance Plan...
October 13, 2009 at 2:05 am
k.przewozniak (10/13/2009)
Thank you for both replies 🙂the version is 9.00.3042.00
ok, that is Service Pack 2
the latest build is
9.00.4230
I would suggest when you have the next maintenance window, move to the...
October 13, 2009 at 1:29 am
free_mascot (10/13/2009)
To make sure every thing is fine rundbcc checkdb (msdb)
How does that explain the size of it?
October 13, 2009 at 1:24 am
GilaMonster (10/13/2009)
tvanharp (10/12/2009)
I found that I can't restore the backup created with the copy only clause in mgnt studio.
Known bug. Can't recall if there's a connect item opened for...
October 13, 2009 at 1:21 am
nope, there are 3rd party tools that do some intellisense, i think sql prompt is one of them
October 13, 2009 at 1:19 am
Sometimes those errors can be fixed using service packs.
What is the build version of your sql instance?
October 13, 2009 at 1:16 am
k.przewozniak (10/13/2009)
Can somebody tell me how big can msdb grow? I mean, is that normal if size is more then 1GB?
On all my other servers size is much smaller...
October 13, 2009 at 1:12 am
ipan_nugraha (10/13/2009)
Dear all,how to tune DBCC DBREINDEX when data is getting large ?
thank's
Not exactly sure what the question is, can you give more details?
October 13, 2009 at 1:08 am
sarvesh singh-457805 (10/13/2009)
I have a database which is 30GB. At the moment data and the log file points to one drive. The customer is now providing us with two...
October 13, 2009 at 1:00 am
Viewing 15 posts - 271 through 285 (of 1,137 total)