I cannot believe the number of people who advocate functions on columns in where clauses...   Think in terms of your white pages -...

Your problem, I assume, is that you have a datetime column - note that it contains both a DATE and a TIME value.  If you have your where clause resembling

where...

Are you sure that it is Snapshot replication you are using?  My understanding of the snapshot replication is that it is essentially a backup on server A and a restore...

The same stored procs as in SQL 2000 should still work, but there are new SQL commands for this - I think you can use things like CREATE USER much...

Thanks for the article - I've been a bit slow on the new world of SQL 2005 and find such bits of info useful for the increasingly frequent times that...

From the point of view of someone who completely agrees with the author - that someone being me I guess - the article...

Think you misunderstood what I was saying - I wasn't saying that the user should be logged on as an account, but the SQL Server account should be changed/examined.... Turned...

If you need to execute SQL stuff from a command prompt (batch file), run the OSQL utility with the -Q or -i parameters.  Look in SQL BooksOnline for osql or...

Hi.  I imagine your problem is actually due to the account that you are using to run MSSQLSERVER service.  If it is LOCALSYSTEM, then it will not have access to...

For the consumer running things like Windows XP, MS Office, web browsing, etc - the most CPU intensive thing they will ever do on their computer is to run games... ...

But it's no good saying "you failed" without at least saying why and how things could be improved... 

Solitare with 3D cards might be nice - have to make use of the processors/cores somehow

I suspect the word "processor" has become synonymous...

Do you mean the FTC login filename stays the same but it still moves the file for you as you hoped?  If so, not a problem..?  You could perform your...

Gee that's a bit harsh    

Anyhow, your code

insert into tableA

select * from tableB

and the error message

Msg 8101,...

No - all objects such as tables, views, stored procs, users (not logins), functions, constraints, etc are stored in the database...

Think along the lines of a backup / restore - if...