Viewing 15 posts - 2,806 through 2,820 (of 7,503 total)
indeed, every object needs its own drop statement.
In SSMS however, you can select all these tables in the detail pane of the tables section and delete them all in a...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2010 at 2:44 pm
Oh, indeed quick copy / paste, you know ... forgot to translate the comments, but you got it anyway 😎
Off course, IMHO, it is better to avoid this kind...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2010 at 1:38 pm
Keep in mind these "switch" weekends are determined on a country bases.
As in many cases in Europe, every country can do it differently 😉
These are the dates I found in...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2010 at 1:10 pm
GilaMonster (9/24/2010)
ALZDBA (9/24/2010)
I like picture 3 : Finaly computer romance :hehe:
Unfortunately not. 😉
That was also during a power failure. I have 2 UPSs for the computer, TV, xbox and ADSL...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2010 at 6:13 am
I like picture 3 : Finaly computer romance :hehe:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2010 at 5:04 am
How about this:
use tempdb
go
drop table T3
go
drop table T2;
go
drop table T1;
go
drop proc usp_new_T1
go
Create table T1
( col1 int identity(1, 1)
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2010 at 4:56 am
Should we alter our default replies to
"press F1 for solution", "press shift+F1 for urgent solution" :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 1:28 pm
GilaMonster (9/23/2010)
ALZDBA (9/23/2010)
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 12:54 pm
very, very sad indeed
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 10:47 am
use master
dbcc checkdb ( theotherdb ) with tablock
go
Msg 8921, Level 16, State 1, Line 2
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 8:29 am
that results into:
PAGE: (1:19170)
BUFFER:
BUF @0x000000008FFF0400
bpage = 0x000000008FC10000 bhash = 0x0000000000000000 ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 7:02 am
use Anotherdb
print db_id()
go
11
dbcc checkdb ( Anotherdb )
go
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 6:27 am
Since you asked for it 😉
Msg 8928, Level 16, State 1, Line 1
Object ID 53575229, index ID 1, partition ID 72057594039697408, alloc unit ID 72057594043695104 (type LOB data): Page (1:507)...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 2:53 am
Oh yes, Dev Edtn vs Ent Edtn in licensing terms will vary more than a decent hardwares cost.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2010 at 12:06 am
GilaMonster (9/22/2010)
Alvin Ramard (9/22/2010)
There was no attempt at any form of poetry.Records are read,
Logs are backed up.
Some poems rhymes,
And some are messed up!
😛
I am seriously contemplating submitting a...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 22, 2010 at 1:14 pm
Viewing 15 posts - 2,806 through 2,820 (of 7,503 total)