Yeah, I never realised it was in CTP! No matter as I was having similar problems with SP1.
"Library not registered" <--- That's it! Not very helpful is it :/ Nothing else. There SQL SP1 wasn't much better.
Hi all,<br /><br />I keep getting "Library not registered" when trying to either create or modify a Maintenance Plan in SQL 2005. This is the case on...
Hi Akthar, As I said, the 2 servers are not on a domain so they can't connect to each other. I've come the conclusion that it's not going to work...
The problem with the above is the fact that the 2 SQL 2005 Servers I have arn't on a domain so how can I setup the "Service Accounts" so they can...
OK, I think I know what the problem is now, it's the "Service Accounts" as they arn't configured. Turns out that the service account on each SQL...
I'm connecting the servers via the "sa" user which should be ok as it does have full database access.
I don't know what "client alias definition" is? I tested the port 5022 on both servers and they connect to each other. Also check port via cmd:...
Hi all, I'm having a problem setting up a SQL 2005 Mirror across 2 servers. I'm using a manual failover at the moment so I don't use a witness...
Ah! I don't think I've explained properly. I've already transfered the database via restoring a backup onto 2005, but some of our databases are still...
<font face="Tahoma"><br />We have just setup a new SQL 2005 box which we are eventually transfering all our SQL 2000 databases across to. Some of the...
I posted this on experts-exchange and I do have a fix. If your interested:...
Hi,<br /><br />I'm having a problem where I have a full-text catalogue setup on a table "candidates" where the "CVText" field is the text that is...
Yeah, makes sense. SQL is going 2 return the recordset in the fastest way possible so it's going to order by whatever it feel best if no ORDER BY is...
Yeah! That's quite annoying really. If the search was done through SQL, I'd just use the CONSTAINABLE statement with Full-Text indexing and get the...
I cannot see how I can use the order by in the normal sense, because I want the results ordered how they are in the list! 1093, 1210, 997, 1005,...
Hi,<br /><br />I have the following SQL statement:<br /><br />SELECT *<br />FROM candidates<br />WHERE (CandidateID IN (1093, 1210,...
DBCC UPDATEUSAGE did not make any difference to the database size. However copying the database from one location to another reduced the size by 10x!...
We have removed the CV (image) field on a test database, but this has not made any reduction to the database size (it should be approx half the...
Thanks but that doesn't answer my question on whether I should transfer the CV's without removing them as I go along or move them in stages due to...
Separate names with a comma.
