As always, it depends 😉

- For small files, rarely requested, you could use a dbmail solution and mail the query result as attachement.

- another alternative is to use a sqlagent...

2 things:

- there is a faulty path in your script !

Should be SET @FileName = 'd:\aveen.txt'

- has your sqlserver instance service account been granted read access to...

By default, there is no order in a set !

1 things you can do:

- Add an order by clause to your select statement.

Keep in mind order by follows the order...

for sure you can define your dns alias like "OurVeryNiceVirtualSQL" but to get to the actual instance (you may have many on your nodes), you'll also have to provide the...

This will for sure get you on track : http://www.sqlservercentral.com/scripts/31797/

I depends 😉

$$$ caused me to have to build my own inventory solution, providing simple history information for instance settings, databases, tables, indexes and volumes.

And a good lesson it has...

satishthota (9/15/2009)

---

I had created following table

Create Table emp(empid int,ename varchar(30))

Insert Into emp values(101,'A')

Insert Into emp values(102,'B')

Insert Into emp values(103,'C')

and I had created following view on emp table

Create View Vw_EmpDet

as

Select empid,ename...

please read this for your options with sql2008 editions and upgrade options:

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

- You can post the results of the DBCC checkdb if you want to.

- The main reason why you cannot just switch to full recovery, run a logbackup and...

- with simple recovery you can only go to the previous full backup ( and if you have a differential backup, you can also apply that).

- how did you...

:hehe:

declare @tmp table (UserName varchar(128) not null, EmailAddress varchar(128) not null primary key, TsRegistration datetime not null)

Insert into @tmp values ('alzdba', 'alzdba@dono.com', '2001-04-01 18:00:00.000')

Insert into @tmp values ('alzdba', 'alzdba1@dono.com', '2002-04-01...

For a couple of years I've had the pleasure to attend SQLPass in Seattle, Denver and Grapevine.

If you do the math on costs, you'll see the cost may even be...

will you toss in a T for the one with the highest added number ? :w00t:

Within the same major version of sqlserver a restore should never be an issue for user databases.

edited: SSC has some response problems, causing this reply to be executed a couple...

Within the same major version of sqlserver a restore should never be an issue for user databases.

edited: SSC has some response problems, causing this reply to be executed a couple...