Two times the user Bob? Surely you'll get a Bob and a Robert? Now, how are you going to decide which one of those to choose if you...

The CASE expression will stop evaluating conditions as soon as it finds one that is true. If you want the other conditions to be evaluated every time, you need...

Make sure that the CreateDeploymentUtility property is set to True. Right-click on the project in Solution Explorer and choose Properties, and go to the Deployment Utility page.

John

No, don't use a loop. Here's something to get you started, although it's not the full solution. Make sure you understand the code - have a read of...

You need to forget about FILEPROPERTY because it only works for the current database. You can use sp_spaceused '[TableName]' to get the details for each individual table. That...

I'm sorry, but you've totally lost me. You complain that it only works if the database has a filegroup (which, incidentally, all databases do), and then you say you...

Yes, FILEPROPERTY. From Books Online: "Returns the specified file name property value when a file name in the current database and a property name are specified. Returns NULL for...

Does the account that you are using to make the linked server connection have access to the database in question?

John

As far as I know, SSMS is a client tool and therefore doesn't require a licence, whereas Integration Services is part of the server product and therefore does. So...

Do you have the remote server set up as a linked server? Your syntax won't work if you don't. Another thing you could consider is to use Integration...

It depends... of course. If you don't have anything else running on the server, I'd start with 8GB for SQL Server and 2GB for the operating system.

John

Almost. The non-clustered index contains the indexed column(s) and the clustered index column(s), just as the index at the back of a book contains the word you're looking up...

marlon.seton (3/22/2012)

---

I'm probably exposing my ignorance here but with a view on just one table is there any difference between having an index on the view and having an index...

If your source is a SQL Server table, just use the UPPER function in your T-SQL query.

John

Paul

I don't know how you do that. There's probably someone here who does, but even so, you may be better off posting this on some sort of development forum.

John