|
I will be astonished if you can do this. The idea that you can take a 05 db back to 2000 seems unlikely in the extreme.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways
|
|
|
|
|
Hello,
If you have modified the structure of your database or introduced features specific to SQL Server 2005 like PIVOT in a view or stored procedure, bad luck.
Try to reattach your database to your SQL Server 2005 , check if the compatibility level of your database is always 80 ( SQL Server 2000 ). If yes, bad luck, if it is 90, try to modify it to 80.
Detach it properly and try to reattach it to your SQL Server 2000. You have a little hope of success ( except if you have introduced features specific to 2005 )
|
|
|
|
|
I have deleted some of the records from my SQL server Database table
How can I recover those records?
|
|
|
|
|
By restoring from a backup? You could restore the backup to a new database and copy the rows over.
Scott
|
|
|
|
|
how i can create pyramid in sql server 2005.
|
|
|
|
|
Which pyramid you want to create by SQL Server 2005?!
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
1
2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9
|
|
|
|
|
Here it is:
DECLARE @i AS INT<br />
SET @i=0<br />
<br />
DECLARE @j AS INT<br />
SET @j=1<br />
<br />
DECLARE @kosova AS VARCHAR(255)<br />
SET @kosova=''<br />
<br />
WHILE(@i<10)<br />
BEGIN<br />
WHILE(@j<@i)<br />
BEGIN<br />
SET @kosova=@kosova+CAST(@i AS VARCHAR(10))<br />
<br />
SET @j=@j+1 <br />
END<br />
PRINT @kosova<br />
set @kosova=''<br />
SET @j=0<br />
SET @i=@i+1<br />
END
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
1
2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9
|
|
|
|
|
And your question is?
I don't understand what you mean by this last pyramid!
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
1
2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9
here the 1 printed after 8 spaces 1 times
here 2 printed after 7 spaces 2 times .
and so on .
|
|
|
|
|
You're cheating! You can't get a decent pyramid by adding a number, you'll have to add two numbers to get a decent pyramid
1
222
33333
4444444
I are troll
|
|
|
|
|
i think u should try it ,
its possible in sqlserver .
so dont laugh ,but try it.
|
|
|
|
|
|
Result
0
111
22222
3333333
444444444
55555555555
6666666666666
777777777777777
88888888888888888
9999999999999999999
Here's my homework;
DECLARE @R AS INT
SET @R = 0
DECLARE @FILL AS INT
SET @FILL = 10
DECLARE @NUMCNT AS INT
SET @NUMCNT = 1
DECLARE @ROWSTR AS VARCHAR(100)
DECLARE @I AS INT
WHILE (@R < 10)
BEGIN
SET @ROWSTR = ''
SET @I = 0
WHILE (@I < @FILL)
BEGIN
SET @ROWSTR = @ROWSTR + ' '
SET @I = @I + 1
END
SET @I = 0
WHILE (@I < @NUMCNT)
BEGIN
SET @ROWSTR = @ROWSTR + CAST(@R AS VARCHAR)
SET @I = @I + 1
END
SET @R = @R + 1
SET @FILL = @FILL - 1
SET @NUMCNT = @NUMCNT + 2
PRINT @ROWSTR
END
I are troll
|
|
|
|
|
ITS GOOD BUT THE RESULT IS NOT SO DESIREABLE .
BECAE WHEN I PASS 5 THEN ITS NOT GINGING THE PROPER RESULT
I NEED A DYNAMIC FUNCTION FOR ANY INPUT VALUE
EX .FOR 5
1 ,1 TIMES
2 2 ,2 TIMES
3 3 3 ,3 TIMES
4 4 4 4 ,4 TIMES
5 5 5 5 5 ,5 TIMES
I NEDD LIKE ABOVE
|
|
|
|
|
|
That is similar to calculating Mandelbrot sets in SQL, only somewhat faster.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
modified on Saturday, March 28, 2009 1:46 PM
|
|
|
|
|
how i can create pyramid in sql server 2005.
Do you having something called SQL-Pyramid-Building-Blocks? just like we have Intel Thread Building Blocks? if one exists,I wish to suggest that to the OP!
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
|
|
|
|
|
How would it be possible to maintain, structure, scripts and preferably data (the whole shebang) between multiple Databases on different machines? Or is simple replication the way to go?
Mirroring?
|
|
|
|
|
Hmm I don't think replication is ever "simple" but it will achieve duplicating the database to additional copies. Get complicated when you need to replicate both ways.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
So what would you suggest? What I'm looking for is like source control for DB but atop all the scripts I'd like to move the data around as well.
|
|
|
|
|
Mustafa Ismail Mustafa wrote: What I'm looking for is like source control for DB but atop all the scripts I'd like to move the data around as well.
Now thats a different requirement altogether. I found a script that moves all procs into sourcesafe a few years ago - never used it but it should be around. We do not have the databases under source control but have a very strict backup policy.
We have a strict Dev/UAT/Production deployment path and only scripts can be deployed to production. We us Red-gate sql toolbelt. SQL Compare is bloody brilliant and I have just started to use SQL Data Compare on the latest project and it is excellent. That takes care of moving scripts and data through the deployment phases (we only deploy the static tables).
Recovery of old scripts is done by restoring a database to another server (localhost usually) and using sql compare to recover the script you need.
Whenever possible we take a copy of the production DB and restore it to UAT and Dev (before starting another development phase).
Reg-gate is really the tool you need to look into - I think they are a sposor of CP as well.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi All
To run an exe file using sp_xpcmdsell?
EXEC xp_cmdshell 'c:\testfolder\testexe.exe', NO_OUTPUT
Thanks & Regards,
Inder Dureja
|
|
|
|