Cheers

I also had the drop table problem, I just removed the quotes altogether, which seemed to solve the problem

I have a problem with the ActiveX script, it results in an...

Hi,

I think I have determined the cause of the problem.

The particular data in question is historic, was loaded two or three years, is never changed and rarely queried. The query is...

Another snippet of information,

the data was invisible until I ran the query in query analyser, when it 'magically' appeared. I have found that some of the settings which are ON...

Found this link on the SQL Server Mag website (I am allowed to post this please Moderator?)

http://www.windowsitpro.com/SQLServer/Article/ArticleID/24600/24600.html

It refers to the fact that complex views, especially those involving several levels of hierarchy...

Hi Rich,

A nice thought! Blind them with jargon

Actually I do have a handy server problem which was occurring at about the same time...

I have been thinking that the indexes may be the chief suspects, and wondered if they can get into a state where some rows are invisible to them.

Another suspect is...

I don't believe it was a user error, because it was reported to me and I was able to verify it.

I ran the report, the data wasn't there.

I extracted the...

Hi

re: unfinished transaction. The data is extracted to a temporary table with a query using the (nolock) locking hint. Usually the application whould freeze if it encountered a block, hence...

Hi Ray,

Several hundred rows. All imported in the same run and sharing a date in common. When I ran a report which should have included this data, it didn't show.

Can...

Hi Martin,

Thanks for your suggestion. I was thinking about writing the filenames to a table on the backup server, and having the backup server process the contents of that table...

Hi Mike,

thanks for that information. If I feed the file-path into xp_cmdshell to xcopy the file onto the backup server I can have the server restore it to the database there.

Now...

sp_tables @table_type="'TABLE'"

will also work

David

Hi,

this works, but it I am so sorry that it is really inelegant and needs a WHILE loop and a temp table.

I have used the RAND function to generate...

Hi, thanks for that. I didn't realise you could use COLLATE at the column level too.

Your suggestion worked, I also tried the following,...