Database

Re: error installing SQL Server 2008 Express

8-Oct-08 21:59

Have you installed all your service packs for your OS ?

DEVELOPER DAY SCOTLAND 2009 Watch this space
http://www.developerdayscotland.com/[^]

Jassim Rahma8-Oct-08 22:10

Jassim Rahma

8-Oct-08 22:10

yes I did..

Re: error installing SQL Server 2008 Express

Jassim Rahma8-Oct-08 22:37

Jassim Rahma

8-Oct-08 22:37

just tried to start the SQL Server (SQLEXPRESS) service and got the following messages in the evet log:

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17207
Date: 09/10/2008
Time: 11:35:27 AM
User: N/A
Computer: JASSIMRAHMA
Description:
FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 37 43 00 00 10 00 00 00 7C......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17120
Date: 09/10/2008
Time: 11:35:26 AM
User: N/A
Computer: JASSIMRAHMA
Description:
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e0 42 00 00 10 00 00 00 àB......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17826
Date: 09/10/2008
Time: 11:35:26 AM
User: N/A
Computer: JASSIMRAHMA
Description:
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a2 45 00 00 12 00 00 00 ¢E......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17182
Date: 09/10/2008
Time: 11:35:26 AM
User: N/A
Computer: JASSIMRAHMA
Description:
TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 1e 43 00 00 10 00 00 00 .C......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17182
Date: 09/10/2008
Time: 11:35:26 AM
User: N/A
Computer: JASSIMRAHMA
Description:
TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 1e 43 00 00 10 00 00 00 .C......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17204
Date: 09/10/2008
Time: 11:35:26 AM
User: N/A
Computer: JASSIMRAHMA
Description:
FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 21(The device is not ready.).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 34 43 00 00 10 00 00 00 4C......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: Server
Event ID: 17190
Date: 09/10/2008
Time: 11:35:26 AM
User: N/A
Computer: JASSIMRAHMA
Description:
FallBack certificate initialization failed with error code: 1.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 26 43 00 00 10 00 00 00 &amp;C......
0008: 17 00 00 00 4a 00 41 00 ....J.A.
0010: 53 00 53 00 49 00 4d 00 S.S.I.M.
0018: 52 00 41 00 48 00 4d 00 R.A.H.M.
0020: 41 00 5c 00 53 00 51 00 A.\.S.Q.
0028: 4c 00 45 00 58 00 50 00 L.E.X.P.
0030: 52 00 45 00 53 00 53 00 R.E.S.S.
0038: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/10/2008
Time: 11:35:27 AM
User: N/A
Computer: JASSIMRAHMA
Description:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 1814 (0x716).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

what is @identity in sql server 2005

Roney8-Oct-08 20:55

Roney

8-Oct-08 20:55

what is @identity in sql server 2005............is a table or variable what functionality it has...plz explain.

Re: what is @identity in sql server 2005

Ashfield8-Oct-08 21:10

Ashfield

8-Oct-08 21:10

@identity is not part of SQL Server, so either its a variable you have declared or you meant @@identity which contains the last value inserted into an identity column.

Bob
Ashfield Consultants Ltd

Re: what is @identity in sql server 2005

Frank Kerrigan8-Oct-08 22:03

Re: what is @identity in sql server 2005 [modified]

8-Oct-08 22:03

I think you mean @@identity

example

<br />
INSERT INTO Production.Location (Name, CostRate, Availability, ModifiedDate)<br />
VALUES ('Damaged Goods', 5, 2.5, GETDATE());<br />
GO<br />
SELECT @@IDENTITY AS 'Identity';<br />

This gets the last Identity field inserted into a talbe, ie usually the primary key.

DEVELOPER DAY SCOTLAND 2009 Watch this space
http://www.developerdayscotland.com/[^]

Roney9-Oct-08 0:25

Roney

9-Oct-08 0:25

yes sure....that one only and thank you for reply.

so when we use @@identity it will get last identity field right.........it means one field value or total column......I think it returns only single value.

one more...select Rank(1) from table update set=some column.
it will get affect first row of the table ok.
when i want 4th row should be execute is possible to give rank(4) .

modified on Friday, October 10, 2008 2:54 AM

sp_fulltext_catalog [modified]

dangquoctrang8-Oct-08 20:23

dangquoctrang

8-Oct-08 20:23

I used sql server 2005:

use book
go
exec sp_fulltext_database @action='Enable'
go
sp_fulltext_catalog @ftcat='name' @action='Create'

error :Incorrect syntax near '@action'.
why? help me, thanks

modified on Thursday, October 9, 2008 11:35 AM

Re: sp_fulltext_catalog

Ashfield8-Oct-08 21:08

Ashfield

8-Oct-08 21:08

Its a typo

sp_fulltext_catalog @ftcat='name' <big>,</big> @action='Create'

Bob
Ashfield Consultants Ltd

Special Characters [modified]

Dushan1238-Oct-08 19:03

Dushan123

8-Oct-08 19:03

SELECT *
FROM RDRetailer
WHERE (RetailerCode LIKE '%'%' )

i want to check (') exsists on retaile code field. but this sql query gives error. please help me

Dushan Perera

modified on Thursday, October 9, 2008 1:11 AM

Re: Special Characters

Parwej Ahamad8-Oct-08 19:19

Parwej Ahamad

8-Oct-08 19:19

Did you type ESCAP '\' ? like

SELECT *
FROM RDRetailer
WHERE (RetailerCode LIKE '%\'%' )

Parwej Ahamad
g.parwez@gmail.com

Override Stored Connection String

chrisace8-Oct-08 15:22

chrisace

8-Oct-08 15:22

I have a Windows application that uses typed datasets. When setting up the datasets, Visual Studio asks if you want to remember the connection. This is helpful when making changes to the datatables or table adapters.

Before filling the dataset, I programatically change the connection string of each table adapter so that it will connect to the remote database. Before this operation, it is set to the local database since that is the one I am developing on.

All goes well except with one form. See the sequence of events below:

First I change the connection string.

Me.LocationsTableAdapter.Connection.ConnectionString = Database.gdbRemoteConnection.ConnectionString

When calling the following fill method, it works as it should.

Me.LocationDataTableAdapter.FillByLocationID(Me.DsLocations.LocationData, cmbTestLocation.SelectedValue)

When calling the following fill method, it displays an error message saying the database location is not correct. It is referencing the local database even though I changed the connection string.

Me.LocationDataTableAdapter.FillByEntryDate(Me.DsLocations.LocationData, dtmDateFrom.Value.Date, dtmDateTo.Value.Date)

If I step through the code, it even shows the connection string set to the remote database when the fill method is called. Is this a known bug?

Re: Override Stored Connection String

Mycroft Holmes8-Oct-08 21:34

Mycroft Holmes

8-Oct-08 21:34

You might be better asking this in the VB forum, Dave Kreskowiak may be able to help, he seems to know how these bloody MS wizard tools seem to work.

Never underestimate the power of human stupidity
RAH

Re: Override Stored Connection String

Frank Kerrigan8-Oct-08 22:05

Re: Override Stored Connection String

8-Oct-08 22:05

You could always try and not using wizard and program it yourself, at first its hard but it gets easier as you go along.

DEVELOPER DAY SCOTLAND 2009 Watch this space
http://www.developerdayscotland.com/[^]

chrisace9-Oct-08 12:42

chrisace

9-Oct-08 12:42

Here is the solution as untyped datasets were not an option.

http://kmccaa.blogspot.com/2007/07/how-to-move-typed-dataset-to-its-own_11.html[^]

how can we restore database if i have DBscripts

Aslesh8-Oct-08 5:36

Aslesh

8-Oct-08 5:36

Hi i have a file with extention .sql which has DBscripts for my database. How can i restore the database using these scripts.

Re: how can we restore database if i have DBscripts

Frank Kerrigan8-Oct-08 6:20

8-Oct-08 6:20

Restore an empty db or with data ?

You could always use the command prompt "osql" (see sql server books online)
and create a restore.bat file.

or

Use Integration Services to run the scripts if you want an automatic restore.

or

simply run the queries

DEVELOPER DAY SCOTLAND 2009 Watch this space
http://www.developerdayscotland.com/[^]

Bulk Copy with Images

JoZ CaVaLLo8-Oct-08 4:25

8-Oct-08 4:25

Hi... I have a table with a column containing images. I'd like that my sql server 2005 stores those images on his backup device.

I tried with the following command
EXEC xp_cmdshell 'bcp "SELECT Image FROM table WHERE ID=1" queryout "C:\Temp\myImage.jpg" -c -T'

I get a file that seems a jpg image... but it's not... I think it's because bcp queryout works only with text data.

Does somebody have any idea on how can I get this working?

Life is not short... the problem is only how you organize yourself

Sherif728-Oct-08 5:17

Sherif72

8-Oct-08 5:17

bcp is not adequate for that, you may need to use textcopy utility.
e.g.
textcopy /S server /U username /P password /T table /D databasename /C Image /W "WHERE ID=1" /O /F C:\Temp\myImage.jpg

JoZ CaVaLLo8-Oct-08 5:30

8-Oct-08 5:30

Hi...

tanks a lot for your answer... The only problem is that Textcopy is not supported in sql server 2005 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=708866&SiteID=1[^]

It was a sql 2000 utility... and I cannot go to all my clients telling that they have to copy Textcopy.exe on their server

#@|°@#@¬@#°§@ Microsoft :-S

Life is not short... the problem is only how you organize yourself

Sherif728-Oct-08 21:23

Sherif72

8-Oct-08 21:23

In this case you could
1. either use SSIS's Export Column task to put the binary data into an image file (http://technet.microsoft.com/en-us/library/ms139818(SQL.90).aspx).
2. investigate the possibility of writing a little CLR to do that job.

if neither is possible check this post which uses sp_OA* (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101754)

JoZ CaVaLLo8-Oct-08 22:16

8-Oct-08 22:16

Hi...

Tank you for your answers... I tried another solution: with bcp I temporarily store a vbscript file where I have the code to connect to the database, select the image and store it in the file I want.

I then call it using the following command

EXEC xp_cmdshell 'cscript "C:\temp\StoreImage.vbs"'

It works very well with SQL Server 2005 in any configuration. But when I try with a SQL Server 2005 Express Edition, when I use trusted connection, the script fails getting an "Access denied" error.

Should I change something in the rights of the sqlserver account? but what?

Life is not short... the problem is only how you organize yourself

JoZ CaVaLLo8-Oct-08 23:24

8-Oct-08 23:24

Found my own response:

USE[DataBase]
GRANT CONNECT TO [guest]
GRANT SELECT TO [guest]

Life is not short... the problem is only how you organize yourself