Database

Using LIKE with variable [modified]

21-Jul-06 13:04

Try and find a SFTP that supports command prompts so you can use batch files in DTS i.e. ftp.bat which can be run by DTS.

Look where you want to go not where you don't want to crash.

Bikers Bible

cyber-will20-Jul-06 22:09

cyber-will

20-Jul-06 22:09

Hi,

I am trying to perform a search with a search term sent to a stored procedure. However when I use this

<br />
WHERE <br />
    Column LIKE '%@SearchQueryVariable%' <br />

it doesn't work. This doesn't work either

<br />
WHERE <br />
    Column LIKE @SearchQueryVariable <br />

Any ideas on how this is done?

-- modified at 4:23 Friday 21st July, 2006

Solved :

<br />
WHERE <br />
    Column LIKE '%' + @Search + '%'<br />

Re: Using LIKE with variable

Frank Kerrigan21-Jul-06 2:22

Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003)

21-Jul-06 2:22

Try this using sp_excuteSQL

<br />
use northwind<br />
<br />
DECLARE @MyLike nvarchar(50)<br />
DECLARE @mySQL nvarchar(200)<br />
<br />
<br />
SET @MyLike = '''%AN%'''<br />
<br />
SET @mySQL = 'SELECT * from Employees Where FirstName Like '  + @MyLike <br />
<br />
exec sp_executeSQL @mySQL<br />

Look where you want to go not where you don't want to crash.

Bikers Bible

Balavardhan20-Jul-06 21:57

Balavardhan

20-Jul-06 21:57

Hi,

I had Intalled Sqlserver 2005 for Dotnet 2.0 in PC on the Operating System Windows Server 2003

I had Installed Sqlserver2005 in Mixedmode Authentication,

When I make the Connectivity, It Showing Error i.e Login Failed for user

NT Authority\Network Server

When I installed Sqlserver 2005 in same in WindowsXP it working well,
But in WindowsServer2003 only it showning this Error

I used Normal Connection Sting "server;uid;pwd;database;integrated security;"

Give me reply as soon as possible.. when u know this info..

Thanking for you

Balu

Re: Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003)

Mike Dimmick21-Jul-06 0:46

Mike Dimmick

21-Jul-06 0:46

I'm guessing that you're trying to make an ASP.NET website. Integrated Security uses the credentials of the thread making the call to authenticate with the database.

Under Windows XP, IIS 5.1 knows nothing about ASP.NET. The ASP.NET runtime itself starts an ASPNET_WP.EXE worker process, which by default runs under the machine-name\ASPNET account. You can change this by editing the <processModel> element in machine.config.

IIS 6.0 on Windows Server 2003 recognises ASP.NET natively, and uses a standard W3WP.EXE worker process. The worker processes use the identity configured in the Application Pool for the application, which by default is the NETWORK SERVICE account.

You have three choices:

- Create a database server login for the NETWORK SERVICE account;
- Change the application pool's identity to a different account that already has a SQL Server login;
- Use SQL Server authentication and pass a username and password in the connection string.

Stability. What an interesting concept. -- Chris Maunder

Re: Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003)

Balavardhan22-Jul-06 2:52

Balavardhan

22-Jul-06 2:52

hi,

Thnak u for your reply,
I got that connectivity..

Re: Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003) [modified]

Frank Kerrigan21-Jul-06 12:57

graph in reporting services

21-Jul-06 12:57

NT Authority\Network Server is anonyous user for ASP.NET 2.0 websites (in 1.1x it was called IUSER_MACHINENAME which is run under a protected thread by ASP.NET.

If you change your IIS to Windows authenication it will pick up your current Windows authenication and pass this to SQL server.

If you require anonyous access web internet then you need to provide an authenicated user to SQL 2005 either via SQL user connection or use impersonation via your web.config using the indentity

<br />
<indentity impresonate="true" userName="username" password="password"><br />

Look where you want to go not where you don't want to crash.

Bikers Bible

-- modified at 18:59 Friday 21st July, 2006

cellardoor071620-Jul-06 21:07

cellardoor0716

20-Jul-06 21:07

i´m working with reporting services and i have to make some graphs and i really don´t know how. there are only 2 report types - tabular and matrix. i also have problem with drill down option when using matrix, it´s not working correctly, i mean it´s hiding rows and columns, but it´s not sumarizing values.

cellardoor

Re: graph in reporting services

Frank Kerrigan21-Jul-06 2:26

Scheduling a Storedprocedure to invoke automatically. [modified]

21-Jul-06 2:26

Graphs are stored in the Chart section of reporting services IDE (Visual Studio).

Look where you want to go not where you don't want to crash.

Bikers Bible

Tiger45620-Jul-06 14:39

Tiger456

20-Jul-06 14:39

I have a scenario in which SQL server 2000 need to execute a stored proccedure on a particular day. If thre is a failure in execution error need to be logged.

How to do and steps to do it.

Re: Scheduling a Storedprocedure to invoke automatically.

Frank Kerrigan21-Jul-06 2:28

Adding LOTS of data to a database table

21-Jul-06 2:28

Use a DTS package or a SQL server Job to schedule the stored procedure. You can setup failure notifications emails.

Look where you want to go not where you don't want to crash.

Bikers Bible

kscadi20-Jul-06 11:37

kscadi

20-Jul-06 11:37

Hello,

I have a program in VB 2005 Express Edition which accesses an SQL Server 2005 Express Edition database.

I have 600,000 rows of data in a comma-delimited text file that I need to add to an existing table.

Is there a way to import this data quickly into the table? (Copy/Paste will take forever, as I am discovering) I know it is easy to do Access use 'Get External Data' from the 'File' menu.

Your help would be greatly greatly appreciated!

-Lee

Re: Adding LOTS of data to a database table [modified]

Paul Conrad20-Jul-06 13:30

Paul Conrad

20-Jul-06 13:30

Have you tried the import/export wizard that comes with SQL 2005 Express? You might want to look at:

C:\Program Files\Microsoft SQL Server\90\DTS\Binn for DTSWizard.exe

It might be helpful Smile | :)

Paul

kscadi20-Jul-06 14:23

kscadi

20-Jul-06 14:23

Beautiful...This sounds like just the thing I need. Only problem is, I've search my whole system for DTSWizard.exe and it's no on my computer.

Is it possible to install it as an add-in, or do you think I need to re-install SQL Server?

Thanks a bunch. Oh and sorry for cross posting. Unsure | :~

-Lee

-- modified at 20:24 Thursday 20th July, 2006

Paul Conrad20-Jul-06 14:35

Paul Conrad

20-Jul-06 14:35

kscadi wrote:
Thanks a bunch. Oh and sorry for cross posting.

Don't worry about it Big Grin | :-D

Just a friendly reminder.

kscadi wrote:
DTSWizard.exe

I don't recall where DTSWizard is found. I think it is a part of the SQL Server Management Studio Express package. I could be wrong, though. Honestly, it's been a while since I've installed SQL 2005 Express and its tools :->

Mike Dimmick21-Jul-06 0:47

Mike Dimmick

21-Jul-06 0:47

Look up the documentation for bcp.exe.

Stability. What an interesting concept. -- Chris Maunder

VK-Cadec21-Jul-06 9:24

VK-Cadec

21-Jul-06 9:24

SQL2005 no longer provides the DTS services or like a wizard as in SQL2000, it is now provides as one of the services. Take a look at that.

Thanks.
Vani

Paul Conrad21-Jul-06 11:20

Paul Conrad

21-Jul-06 11:20

VK-Cadec wrote:
SQL2005 no longer provides the DTS services or like a wizard as in SQL2000

Are you sure about this? DTSWizard.exe came with SQL 2005 Express as I stated earlier Smile | :)

Table Information

hamidreza_buddy20-Jul-06 6:10

hamidreza_buddy

20-Jul-06 6:10

Hi. i want to Get information for each table in DataBase.
especially i want to get column type and column size. (I want to use OleDb) i used OleDbSchemaGid and some select statements but most of its returns are (null) and doesnt have any useful information.

Steve S20-Jul-06 6:20

Steve S

20-Jul-06 6:20

From where do you want to use OLEDB?
C#, VB.NET, Managed C++ or native code?

If the latter, there is stuff in ATL DB Client templates that will help.

Steve S
Developer for hire

hamidreza_buddy20-Jul-06 6:37

hamidreza_buddy

20-Jul-06 6:37

from C# in a Windows form app

Dinuj Nath20-Jul-06 20:36

Dinuj Nath

20-Jul-06 20:36

If your database is SQL Server try looking up Information_Schema views in the books online.

Select * from Information_Schema.Tables

will give list of all the tables.

--
Don't take life seriously because you can't come out of it alive.
-Warren Miller
(From Monty²[^] bio)

hamidreza_buddy21-Jul-06 6:42

hamidreza_buddy

21-Jul-06 6:42

No. I want to use OleDb. I want to write a Program for all kind of Databases like access,Oracle and ... . is there any standard SQL statement for that.