You can create a table with all these columns and Insert/Update with getdate() before/after defrag.
If I want to use a reference table, Is there a prebuild list available for the names?
Nope this doesn't work. It only returns 1 row.DECLARE
I need a query to that will return similar names.
For an example, if i search for mike, it should also return michael.
Is this possible in...
- SQL Server 2000
-Transactional Replication- 1 subscriber
- Distributor and subscriber on the same server- Subscriber always online Would you...
This seems like a network issue.
Rebuilding the index could cause this. Use SORT_IN_TEMPDB option when rebuilding indexes.
I think it will backup to one device.
I would create one plan per database.
It seems like you have a corruption.
Check out the following links
You could truncate log after restore if you wish.
Follow Frank's advice.
If you still want to create a table for each day, you need to create and insert using dynamic query like below:DECLARE...
You could also use :
SELECT a.zipcode, z.zipcode
FROM AgentAddresses a
LEFT JOIN ZipCodes z ON
REPLACE(a.zipcode,'-','') = z.zipcode
It doesn't work.
Either use IF statement or run the whole query dynamically.
Separate names with a comma.