setting db in single...

In command prompt type

SQLCMD/?

It will show various options,which will help you to create batch file .

if you want to execute test.sql trough batch file , you can use

SQLCMD -Sservername...

Casper101 (11/14/2012)

---

When I try to send and Attachment (@file_attachments ) with sp_send_dbmail, I receive this error:

"Attachment file ***** is invalid"

The file does exist and the SQL login is sysadmin.

The file...

rummings (11/12/2012)

---

I was hoping to rebuild all indexes on one of our SQL Server 2008 databases over the weekend. The database is used on our campus to record data from...

Happy Diwali to all and have a great Year ahead 🙂

did you try rebuilding your indexes ?

there are so many similar posts like this , where some experts put there opinions, you can check there

http://www.sqlservercentral.com/Forums/Topic1361075-391-1.aspx

Rebuilding clustered indexes can free up unused space.

But as you provide default value 20 GB to data file , it will not fall below 20 GB.

You mean T-SQL developer or DBA ?

Post DDL before CELKO come 😀

do you have copy of mssqlresource database files before the installation of service pack .

if you are lucky and you have copy of these db files , you can...

You can use import export wizard .

and wherever you need data for specific date and dept ,use query in the import wizard

select * from yourtable where date ='date...

Koen Verbeeck (11/8/2012)

---

So, for which versions do you...

McSQL (11/8/2012)

---

Ah apologies, yes you're right, you would have to set RECOVERY to SIMPLE and then run the shrink commands in SQL 2008.

Forgot that this was a discountinued command in...

Eugene Elutin (11/8/2012)

---

sanket kokane (11/7/2012)

---

I'm testing on some part of the application .

My Table structure is like

create table test (id char (8))

I want , whenever user insert value ,lets...