Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: katehol
  • Content: Threads
  • Order by date
  1. katehol

    SQL Server Managemet Studio folder

    Hope someone can help me with this annoyance... Every time I open MS SQL Server Management Studio it automatically creates a folder in My Documents. However, I have the same folder stored elsewhere, as I don't want it at this level - is there any way I can point it to this other location...
  2. katehol

    Problem with links in pdf converted from powerpoint

    Hello I've created a pdf file from a powerpoint presentation, but for some reason all of the links on one of the slides have been converted to one big link. The second slide in the presentation has 11 links on it - one to the homepage and the other 10 linking to the next 10 slides. However...
  3. katehol

    Clean up postcodes

    Hi I am stuck on a query where I need to clean up the postcode data we have been given by a client. Some postcodes are in the proper format (eg AA1 1AA or A1 1AA or AA11 1AA). But some are in the incorrect format (eg AA11AA or A11AA or AA111AA). Does anyone know of a way to update all of the...
  4. katehol

    Microsoft Word toolbars resetting on logoff

    When I log off my customised Word toolbars are resetting themselves, which is rather annoying - does anyone know how to stop this happening? Thanks Kate
  5. katehol

    Top 20 Daily...

    An easy little query for someone - I appear to be having brain freeze over it (think it's because it's a Friday...) I want to be able to show the daily top 20 pages from a table. If I run the following query, I only get the top 20 from the first date stored in the table - how would I show the...
  6. katehol

    Intranet link from outlook doesn't work

    When I try to add a link in an Outlook email to a page within our Intranet, when you click on the link it does not recognise that the link is a local page, and so does not automatically log the user on and asks for a password. I tested this out by changing the Internet Security Settings to...
  7. katehol

    Change string to title case

    I have a table of contact details, some of which are in lower case, some in title case and some in upper case. I want to change all of these to title case (ie lower case with a capital first letter). I can't seem to find a function for this though. Any clues?
  8. katehol

    Remove string before or after a specified character

    I need to split up some web addresses that are being stored in my database. I currently have strings in the format of {name}/web/guest/home I want to be able to split this into 2 columns - one for the name and one for the remainder of the web page, so that I can count individual users and...
  9. katehol

    Find data in comma-delimited lists

    I need to see if a certain integer appears in a column that contains multiple comma-delimited lists. eg SELECT * FROM TableA WHERE TableA.id IN (SELECT list FROM TableB) ...where 'TableB.list' is a comma-delimited list, and there are multiple rows in this TableB table, therefore meaning that...
  10. katehol

    Removing part of a text field

    I'm having trouble removing part of a text field. When I run SELECT REPLACE(journalarticle.content,'?doAsUserId=BedNOLxX0dg%253D','') FROM journalarticle WHERE content LIKE '%?doAsUserId=BedNOLxX0dg%253D%' I get the following error Argument data type text is invalid for argument 1 of...
  11. katehol

    Indexed views

    Hi, I am trying to create an indexed view, but because I am using a MAX function, I get the error Cannot create index on view "dbo.View" because it uses aggregate "MAX". Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute...
  12. katehol

    Set permissions using variables

    Is there any way that I can set up permissions on SQL Server 2005 with the use of variables. I am looking to do something like this... DECLARE @Login varchar(255) SET @Login = 'LoginName' GRANT CONNECT TO QUOTENAME(@Login) --(ie GRANT CONNECT TO [LoginName]) As I...
  13. katehol

    Renaming all default contrainsts

    I am currently trying to rename all of the Default constraints in my database to fit in with my naming convention of DF_+TableName+ColumnName. Since there are over 300 of the things, I don't particularly fancy doing them all manually. I was hoping to use something like... --Declare the...
  14. katehol

    Permissions for SQL Server Agent & Activity Monitor

    I am currently setting up various access groups for SQL Server Management Studio and am struggling to find the permission scripts that will allow me to give people access to the Activity Monitor (under the Management folder) and also to the SQL Server Agent (showing all of the scheduled josb...
  15. katehol

    SQL Server - hide password

    I am trying to find out how to hide/obscure a password in SQL server. Currently the passwords are being held as a text field, which means that anyone who queries the table or just opens it can see everyones passwords. Is there some way of hiding this? I was just wondering if there was a...
  16. katehol

    Run query against multiple databases

    I have to run a script I have written against multiple databases (about 40) - how would I do this? Once I have the results I need them all to be unioned into one table. Part of the script is below... Thanks for any help. :) USE db1 SELECT * FROM Users WHERE (Users.user_type = '1.0' AND...
  17. katehol

    Joining 2 queries in one table

    I am trying to join 2 queries within one table, but as the results return 2 columns and 12 rows for each query, I am having problems working out how to join them together. (This is actually part of a far larger join of many queries, but this is the bit I am stuck on!) Any help would be...
  18. katehol

    Using variables when creating a database

    I am trying to create a database using variables, so that the variables can be passed in when the script is run. But when I run the code below I keep on getting an error - any clues what I have done wrong? I’ve not used variables before, so sorry if it is obvious. (NB The script was creating...
  19. katehol

    Need to save SQL Server bookmarks

    I have a really long SQL server script which I have bookmarked. But when I close the script the bookmarks are wiped - does anyone know of any way of saving the bookmarks, so that when I re-open the script the bookmarks are still there? Thanks K

Part and Inventory Search

Back
Top