Viewing 15 posts - 10,426 through 10,440 (of 49,566 total)
Nope, not that one
DBCC CheckDB('<database name>',REPAIR_ALLOW_DATA_LOSS)
Set the database to single user mode first
You will lose data, not necessarily just the corrupted data, you may lose other data as well. CheckDB...
January 13, 2014 at 8:06 am
Varchar.
If the leading 0 is important, then it's not a number. Numbers do not have significant leading 0s, we don't write 0100 for one hundred. We write 0120 for postal...
January 13, 2014 at 6:12 am
Koen Verbeeck (1/13/2014)
GilaMonster (1/13/2014)
January 13, 2014 at 6:05 am
mxy (1/13/2014)
stored proc need to create a execution plan whenever there is change...
January 13, 2014 at 6:05 am
Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for that.
January 13, 2014 at 5:28 am
Hakuna Matata (1/13/2014)
The table is high transaction table with hourly job to delete unwanted data. Could this be the issue?
No. The issue is that you have problems with your...
January 13, 2014 at 5:17 am
The message is pretty clear
The procedure 'sys.sp_addsrvrolemember' cannot be executed within a transaction
You can't run it within a transaction. Why are you trying?
January 13, 2014 at 4:39 am
The SQL 2008 exams have all been retired, they can't be written any longer. Have a read through the Microsoft Learning site for the SQL 2012 exams and certifications.
January 13, 2014 at 12:37 am
Dynamic SQL doesn't automatically cause performance issues by itself (security issues however...)
What symptoms are you seeing, why do you attribute the problem to the fact that the query is dynamic,...
January 13, 2014 at 12:23 am
Fal (1/12/2014)
Just to follow up on a question you posted on the Thread (is that a Threaded question? 😉 You were looking for an editor for the iPad...
January 13, 2014 at 12:21 am
Free downloads don't have a serial number. Serial number is what you get when you buy the product. Main Red Gate support for support on their products.
As for exams, browse...
January 12, 2014 at 1:02 pm
There's no such thing as a transaction undo file in SQL Server. That not an oracle term?
There are standby files in log shipping which store information relating to undo operations.
January 12, 2014 at 1:01 pm
Jeff Moden (1/12/2014)
GilaMonster (1/12/2014)
Please note: 4 year old thread (bumped by a spam post)Why does that matter to you so much?
So that people who don't check the dates don't...
January 12, 2014 at 12:54 pm
ramana3327 (1/12/2014)
Thanks Gail. I restored the data file again but still it is showing me that error.
I suggested reinstalling, not restoring a data file.
January 12, 2014 at 12:53 pm
Viewing 15 posts - 10,426 through 10,440 (of 49,566 total)