Search results for query: *

I have a table where I need to only want to return the 2nd row no matter what the values contained within the row. Is there a simple way to do this? Thanks

Thank you very much for you help. I will have a go today using what you have provided and let you know how i'm getting on. Thanks again, Dan

I have a DTS that imports a txt file from an FTP location. The text file has started to arrive with errors where new lines \ records are positioning themselves correctly. (It is a little lie the data is wrapping itself in the original extract) I can identify new lines \ records within the text...

I am using SQL 2000 I have a datetime field containing an example string of; 01/08/2006 15:25:00 I would like to return a value containing only the time. e.g. 15:25:00 I have tried; Convert(datetime,DateField,108) but this continues to return the original string. Can anyone help?

The CPU usage on our Web server can stick at 100%. On investigation it is the dllhost.exe causing this. At the moment I am resorting to a server reboot to bring it back to normality. (This is something I don't wish to continue with) Is there a better way to deal with the problem? Thanks Dan

Works perfectly. Thank you very much.

Thanks for your reply! The Print command works in the sense that it prints the string. However the exec commmand returns the error msg; Incorrect syntax near the keyword 'convert'. Any ideas? Thanks.

Thanks for your reply, (I can see what your want to do it looks like a good idea) When I run the statement in Query Analyzer it returns Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'GetDate'. Any ideas? Thanks

I would like to create a series of tables within an SQL 2000 db. E.g. the tables will be called [Data] (followed by the date and time the table is created) ; create table [LiveDB].[dbo].[Data] + { fn NOW() } ([testcolum] varchar (10) NULL) I am trying to end-up with a series [Data] tables...

I am afraid the views are simple. You would expect the graphic to appear. The problem is v.strange as one time you can enter the view and you see no graphic -try later and it will appear. i.e. the problem is intermittent. Could this be a memory\CPU usage issue?

Using SQL 2000. Logged in as SA. Within Enterprise manager when I go into the design of All Views - I return the SQL but no table graphic. This is proving very annoying. All other databases under the same SQL registration work as expected, other that this one key database. I have looked...

I am setup as ADMIN so I can be certain I have the rights. Thanks

I am using SQL 2000. When I go into the Design of a View I do not see the table structure. (This has started recently for myself, is not a problem for some colleagues and has been happening for a while for others) The Design views I am referring to are simple and should return the structure...

The ID can be generated whenever I execute \ run a report. It should be generated retrospectively i.e. when week has finished \ finalised. I am looking to generate the position (costID) so as I can generate reports based on 'centiles'. Centiles look at position e.g. 10th percentile and return...

I have a table containing week numbers, and cost. I want to generate a costID that starts from 1 as each week begins. The tricky part is I need the costID to be ordered so as the Min Cost of the week = 1st ID, and the next min to be costID number 2 and so on so as the highest cost = max costID...

I have a user that requires access to modify the design of a limited number of tables. While admin access will provide this privilege - I would prefer to only attribute admin wrights to specific tables. Any advice?

I want to overwrite the system databases with .ldf & .mdf files from back-up .ldf & .mdf files. i.e. To restore the DTS data which exists within the MSDB.

I want to detach the system db files, when I run the sp_detach_db command I am told I cannot do this. I have read many threads that suggest; detaching system db is a matter of course. Any ideas as to why I encounter an error msg - cannot overwrite system databases

Thanks for the pointer. My real issue stems from the need to remove the logins and then reattach the to the same rebuilt database. It would be easy if I had a second db that I could move loggings into on a temp basis and then transfer back, but I do not have this luxury - is there a way of...

I need to rebuild a database. To do this in need to detach my logins > then recreate db > then reattach logins. What is the best way to detach and re attach the logins?