Search results for query: *

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...

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...

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...

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

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...

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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