This is the explanation

# re: Understanding "login failed" (Error 18456) error messages in SQL Server 2005

State=16 means that the incoming user...

AndrewSQLDBA (4/17/2008)

---

Hey Everyone

I have a SQL 2005 box, the service starts using a domain account. I have noticed errors in the SQL logs for some time now. The error message...

Hello,

The information provided is not sufficient. You need to tell us what you are trying...

balamurugan.ganesan (4/1/2008)

---

Hi,

All the 3 given methods return file not exits eventhough the file is there

-- using the scripting object

declare@Path varchar(128) ,

@FileName varchar(128)

select@Path = 'C:\' ,

@FileName = 'myfile.txt'

declare@objFSys int

declare @i int

declare@File...

xtoolbar (3/19/2008)

---

I am using SQL2000 and I am trying to save all of DTS packages as bas files auotmatically. I had read many messages here, but I haven't...

Loner (2/27/2008)

---

I have a SSIS package which loads data from a text file to a table in DatabaseA. I have another package which loads data from a text file...

I would go with the way Steve said.

Hello Ritesh,

It would be better if you can post your tables structure so that it will help us to help you in a better way. It is good that you...

keverage (2/28/2008)

---

Thanks for taking a look at this! I'm sure there is a simple solution to this, but so far I've not been able to find it. Here...

terrence_daniels (2/28/2008)

---

I have created a database in SQL Server Express 2005 successfully. Now I need to create a stored procedure that will create a hyperlink to a specific website using...

Philip Horan (2/27/2008)

---

Back Again! When I configure the SS Profiler (adding a Column Filter) to apply a filter to the Database ID as suggested do I enter the Database ID...

Hello,

Is this what you are looking for?

http://www.theeldergeek.com/physically_setting_the_page_file_size.htm

Thanks

msaint (2/26/2008)

---

RoomDateQty_In_Out

10101/22/20081

10202/4/20081

10102/5/2008-1

10202/5/2008-1

10202/5/20082

10102/9/20081

10102/10/2008-1

10202/20/2008-2

10203/5/20081

10103/6/20081

The system stores a record each time a room is occupied or vacated. The goal of the statement is to determine how many days the room was occupied...

AVB (2/26/2008)

---

I just created a txt file from OSQL on a remote machine.

EXEC master..xp_cmdshell 'osql -E -Q"select top 1 * from t_Table" -o\\MachineName\C$\var_out.txt'

This worked fine. But if I add a...

Michael Deputy (2/22/2008)

---

The owner of the DTS Job or the owner of the scheduled task?

The owner of the DTS job is the user who created it. The owner of...