Viewing 15 posts - 346 through 360 (of 644 total)
adrian.facio (2/23/2012)
I came up with these query using Divine's table ( i just took off a row 3 person 103 pair because i think they were inserted twice).
select [Rows] .Row,
...
February 24, 2012 at 1:30 am
satishm94 (2/23/2012)
no ...can u tell me where it will be????
im new here...
You can find it under the directory path:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log
February 23, 2012 at 6:22 am
So did you check the setup log ??
February 23, 2012 at 6:15 am
Divine Flame (2/23/2012)
Did you try this?
SELECT ROW_NUMBER() OVER (ORDER BY [Name]) AS RowId,[Name]
FROM #Temp
ORDER BY [Name]
If you just need to reset the ID column (with names in order) so...
February 23, 2012 at 4:50 am
Did you try this?
SELECT ROW_NUMBER() OVER (ORDER BY [Name]) AS RowId,[Name]
FROM #Temp
ORDER BY [Name]
February 23, 2012 at 4:38 am
sqlzealot-81 (2/23/2012)
Divine Flame (2/23/2012)
February 23, 2012 at 3:03 am
I don't understand your question. You already have the solution as version 2. True, you should put all the filter criteria in WHERE clause. There is no point in putting...
February 23, 2012 at 2:50 am
Er.karthikn (2/22/2012)
I have a backup of one database physically.database suddenly crashed now I need to restore that database..so While restoring that database,some of the objects are waste I have...
February 23, 2012 at 2:43 am
sqlnaive (2/22/2012)
February 23, 2012 at 1:54 am
paul.knibbs (2/23/2012)
jswong05 (2/22/2012)
If you are already local administrator, why don't you just use DAC. See BOL if you don't understand DAC.
Correct me if I'm wrong, but that would only work...
February 23, 2012 at 1:44 am
maheshkrishnas (2/21/2012)
I have to write storeprocedure program should create a file.if not just show these results when we run the SP
store_salesstore_stat.csv target
StoreProduct SalesStoreAvg Sales TV Avg SalesDVD
S1TV...
February 22, 2012 at 8:36 am
imranx101 (2/22/2012)
It works. Thanksss alot. You are genious. 🙂
You are welcome 🙂 Its just your kindness to say that 🙂
February 22, 2012 at 6:38 am
As the error itself says, you have some LOB columns present in some of your tables/indexes. It is documented that you can rebuild the index ONLINE for those indexes which...
February 22, 2012 at 6:36 am
imranx101 (2/22/2012)
Yes exactly it is. The job runs overnight.
Then you can run below command & check the result:
SELECT SJ.[name],SJS.[command]
FROM msdb.dbo.sysjobs SJ INNER JOIN msdb.dbo.sysjobsteps
ON
SJ.[job_id] = SJS.[job_id]
WHERE SJ.[name]='Your Job Name Here'
check...
February 22, 2012 at 6:27 am
imranx101 (2/22/2012)
The developer of SSIS Package whose not available around has password protected some the SSIS Packages that we are using.
When I try to Export the Package I...
February 22, 2012 at 6:11 am
Viewing 15 posts - 346 through 360 (of 644 total)