Viewing 15 posts - 16 through 30 (of 35 total)
Sorry I had your source mixed up with your destination.
You said that you were db_owner of only a certain database which I am interpreting as being the database in question...
Tim Januario
February 19, 2010 at 11:10 am
Is your log file on a disk that is experiencing a lot of other write activity? It is always recommended to keep your data files and log files on...
Tim Januario
February 19, 2010 at 10:37 am
That's probably a better solution. Cleaner and more obvious what the purpose is.
Tim Januario
February 19, 2010 at 10:24 am
Try a where clause like:
WHERE
(
releasedate IS NULL AND
@filterparam = 'off'-- or whatever it would be when you want null
) OR
(
relasedate IS NOT NULL AND
@filterparm = 'on'
)
Tim Januario
February 19, 2010 at 10:10 am
Nikki123,
Your original post was passing in an anonymous string value as the parameter with your param data as part of the string. The parameters each need to be passed...
Tim Januario
February 19, 2010 at 9:59 am
Is the truncate the right option in this case? You said that when you move the data you keep the keys, but (in case of an identity column) the...
Tim Januario
February 19, 2010 at 9:54 am
Are you trying to do an update or an insert? I'm seeing in your code for tablea that you have a lot of not null columns, so I assume...
Tim Januario
February 19, 2010 at 7:39 am
And I forgot the important part regarding your question. If the query analyzer thinks it has given you an efficient plan, you will NOT get it to use a...
Tim Januario
February 19, 2010 at 7:10 am
Was the intent of the query and the procedure to have the same body, because your stored procedure is different than the query. Your query has LIKE '%NTT%' which...
Tim Januario
February 19, 2010 at 7:06 am
Or the world comes to an end. But I think it was my first answer.
Tim Januario
February 17, 2010 at 6:14 am
The difference between DDL and DML results in a Operand data type varchar is invalid for subtract operator exception. Was that a trick question?? (several days later I am...
Tim Januario
February 17, 2010 at 6:12 am
A new table is created with the new column, data is copied into the new table, the old table is dropped, and the new table is renamed to old table...
Tim Januario
February 17, 2010 at 6:07 am
Ashok,
Are you saying that you need to test for errors after each query in order to know, for example, that the error happened in query 2 rather than query 1...
Tim Januario
February 16, 2010 at 10:16 pm
I agree with PaulB. Access does have it's limitations, but security shouldn't be one of them because you can delegate that to a different layer such as the db....
Tim Januario
February 15, 2010 at 6:45 am
My personal opinion is that it is the database's responsibility to maintain data integrity. While the application can do this, it only works if the application is the only...
Tim Januario
February 15, 2010 at 6:38 am
Viewing 15 posts - 16 through 30 (of 35 total)