Viewing 14 posts - 31 through 45 (of 45 total)
rajdba (10/15/2009)
M.I.Thanks a lot 🙂
I got it.
Thanks,
Raj
welcome
________________________________________
M.I.
[font="Times New Roman"]
October 15, 2009 at 7:03 am
Try this query may it full fill ur desire. It show u the average CPU time for the top 5 query execution plans in cache. Or you can change it...
________________________________________
M.I.
[font="Times New Roman"]
October 15, 2009 at 5:34 am
AlexSQLForums (10/14/2009)
Try this:BULK INSERT OrdersBulk
FROM 'c:\file1.txt'
WITH
(
FIRSTROW = 2,
MAXERRORS = 0,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '',
ERRORFILE = 'c:\file1_error.txt'
)
After run this query i got this...
________________________________________
M.I.
[font="Times New Roman"]
October 15, 2009 at 4:28 am
Yes that error appear repetadely 5 times. So wht shall i do for this.
This all are on my local drive, that is a logical drive.
Is there any problem with...
________________________________________
M.I.
[font="Times New Roman"]
October 7, 2009 at 5:40 am
That is on this date and time.
Date10/5/2009 1:56:25 PM
this db backup size is around 4532096kb.
________________________________________
M.I.
[font="Times New Roman"]
October 7, 2009 at 5:12 am
One more thing i checked now its not showing that db on the physical location of all the db's.
but while i m running dbcc checkdb its runing fine.
So it mean...
________________________________________
M.I.
[font="Times New Roman"]
March 31, 2009 at 10:09 am
I used DBCC CHECKDB command with the db name its working fine.
while i m runing the sp_helpdb dbname (for knowing the physical address of the particular db) in first...
________________________________________
M.I.
[font="Times New Roman"]
March 31, 2009 at 8:52 am
check this
grant user on sp
________________________________________
M.I.
[font="Times New Roman"]
March 31, 2009 at 7:07 am
yes yes, i want to schedule SQL Server Native Backups.
________________________________________
M.I.
[font="Times New Roman"]
January 23, 2009 at 2:22 am
Thanks dear all.
I understood now. and i have done my job successfully.
________________________________________
M.I.
[font="Times New Roman"]
December 15, 2008 at 8:46 am
destination problem i have solved. but new problem is come in front of me when it complete the migration wizard that time its showing an error message,
'Exception of type...
________________________________________
M.I.
[font="Times New Roman"]
November 27, 2008 at 3:06 am
here i want to view the file. so how i can view this file.
Thanks in advance.
________________________________________
M.I.
[font="Times New Roman"]
November 24, 2008 at 9:06 am
yes i want to know, workflow between steps within a package and the order that multiple packages are executed?
Thanks,
Regards,
m.i.
________________________________________
M.I.
[font="Times New Roman"]
November 20, 2008 at 3:04 am
Actually my manager has asked me, to check whether client connectivity tool is installed on our sql server 2005 or not. So i checked this by control pannel >...
________________________________________
M.I.
[font="Times New Roman"]
October 23, 2008 at 5:05 am
Viewing 14 posts - 31 through 45 (of 45 total)