Viewing 15 posts - 1,471 through 1,485 (of 1,538 total)
I think excel has limit of appx. 65000 rows per sheet.
can u check the number of rows your query is returning
select count(*) from (Your query) as cnt
If its beyond...
December 16, 2008 at 9:15 pm
In Logshipping both Commited and Uncommitted data will be shipped whereas in Mirroring only commited data.
is this so?
In log shipping, I was of the opinion that only commited...
December 16, 2008 at 9:06 pm
somewhat similar issue was posted earlier. You might want to refer that as well...
http://www.sqlservercentral.com/Forums/Topic618626-149-1.aspx#bm618684
December 16, 2008 at 8:58 pm
Either the entire transaction succeeds or it fails.
IF its fails everything will be rolled back automatically.
December 16, 2008 at 10:03 am
I need to know if i need to show all the "Dependencias" and not filter whit this parameter but i cant modify the query, which value can i put in...
December 16, 2008 at 7:46 am
Well I'm at Tata-AIG. Situation was grim couple of months back when AIG managed $86B loan from federal bank. For a moment i thought to go back to my profession...
December 16, 2008 at 6:42 am
Yes.. the first query when grouped by username gives correct result along with max(logdate).
I guess he got quite a few ways of pulling what he wants!
December 16, 2008 at 5:41 am
How do you know this? Sunil hasn't stated it - are you working on the same system?
No, I'm not working on same system. It was a concern intended for him...
December 16, 2008 at 5:14 am
SELECT DISTINCT UserName
FROM tbl_PBN_debugging
WHERE DATEDIFF(dd, Logdate, GETDATE()) < 91
...how many rows do you get?
I hope tbl_PBN_debugging table contains only one row per user. LogDate field gets updated upon...
December 16, 2008 at 4:40 am
Yes, i do take backups to a new file on a daily basis. was just experimenting with backup devices on test server when i came across that question.
---------------------------------
it seems expiredate...
December 16, 2008 at 3:54 am
Gail, i searched and it seems the problem may be due of Full Text Catalog and database was perhaps upgraded from 2000 to 2005... not too sure on this..
http://www.mydatabasesupport.com/forums/sqlserver-programming/188494-backup-help.html
December 16, 2008 at 3:30 am
cant help much with jsp. however can u paste the table definition and the query you're using to fetch records. What all indexes do you have on this table?
December 16, 2008 at 2:41 am
Can you try and run a backup from the query window -
BACKUP DATABASE Emp TO DISK = ' Full path to backup file here '
If it gives an...
December 16, 2008 at 2:38 am
Viewing 15 posts - 1,471 through 1,485 (of 1,538 total)