asiaindian (2/26/2013)

---

1. Select statement : owner id=processc59288 is a 'SELECT ... FROM dbo.mtListPrice_view

' statement taking a shared lock on BASE table [dbo].[mtListPrice]

2. Insert statement on BASE table [dbo].[mtListPrice] is taking...

GilaMonster (1/12/2013)

---

muthukkumaran Kaliyamoorthy (1/12/2013)

---

Have a look Truncating and shrinking the transaction log file[/url]

Also take a look @ http://www.sqlserverblogforum.com/2011/06/sql-server-recovery-models-and-backup-types/%5B/quote%5D

There's a bunch of errors in both of those, just beware...

Have a look Truncating and shrinking the transaction log file[/url]

Also take a look @ http://www.sqlserverblogforum.com/2011/06/sql-server-recovery-models-and-backup-types/

Yes you are right. You can shrink it to the reasonable size and schedule the Tlog backup to maintain the size as much as same.

http://www.sqlservercentral.com/Forums/Topic667056-145-1.aspx#bm1027279

fhfh (12/13/2012)

---

I mapped the network drive in sql sevrer box and i have ran this

EXEC xp_cmdshell 'FORFILES /p I:\ /m *.* /d -30 /c "CMD /C del /Q /F...

What is the error it shows?

For bring the DB online. use the online option in a alter...

select @MimeType,BulkColumn from Openrowset(Bulk @image , Single_Blob) as EmployeePicture

| BULK 'data_file' ,

{ FORMATFILE = 'format_file_path' [ <bulk_options> ]

...

I have...

Henrik,

Indeed! That's good for larger databases.

without using mail sql in sql server 2008?

Could not understand it. Can you explain a...

Thank you Jona and Anthony.

Thanks Siebe. Will change it.

Nakul Vachhrajani (6/13/2012)

---

muthukkumaran Kaliyamoorthy (6/13/2012)

---

In my server the browser is disabled. and the port is 5555

Server is listening on [ 'any' <ipv4> 5555].

Dedicated admin connection support was established for listening...

In my server the browser is disabled. and the port is 5555

Server is listening on [ 'any' <ipv4> 5555].

Dedicated admin connection support was established for listening remotely on port 1434.

I...