Viewing 15 posts - 1,471 through 1,485 (of 2,387 total)
quote:
I had considered a batch file but it would need to connect to each database first and check the current schema...
July 17, 2003 at 1:27 pm
Are you looking for SQL Server version or database version?
select @@version will give server information.
SELECT DATABASEPROPERTY('yourdbname', 'Version') will show the database version.
quote:
July 17, 2003 at 12:52 pm
It can be domain user account or local user account, depending on what you want to do with it.
SQL Server Agent proxy accounts allow SQL Server users who do not...
July 17, 2003 at 12:33 pm
From EM --> Management --> SQL Server Agent --> properties --> Job System --> uncheck 'Only user with sysadmin ....'. Please ensure you have proxy account defined too.
July 17, 2003 at 12:09 pm
quote:
/*View*/select v.phcode, v.epscode
from v_phys_site v
where v.projectID=123
and v.phcode like '%abc%'
This is the query runing...
July 17, 2003 at 11:53 am
Can you post your view and the query against the view here?
July 17, 2003 at 9:31 am
quote:
Now to my problem:When I run a query using the view, it will perform a Index Scan of those 2 Million...
July 17, 2003 at 8:04 am
quote:
"The log in this backup set begins at LSN ... , which is too ealy to apply to the database An...
July 17, 2003 at 7:55 am
Can you post your statement and result of sp_helpfile of your database? Which version od SQL Server you are running?
July 17, 2003 at 7:17 am
Sorry I gave you worng command. What I like to have is 'RESTORE HEADERONLY' from both backup sets.
July 17, 2003 at 7:13 am
Use parameter /E to specifice a trusted connection (password not required).
Make sure that user has sufficient permissions to execute the DTS package.
July 17, 2003 at 6:50 am
quote:
BACKUP DATABASE ONEC TO DISK='R:\TEST\ONEC_diff.BAK' with INIT, DIFFERENTIAL-- restore is OK
WAITFOR TIME '13:45'
BACKUP LOG ONEC TO DISK='R:\TEST\ONEC.TLF' with NOINIT
-- !!! restore...
July 17, 2003 at 6:30 am
quote:
With that said, I don't know of very many good reasons to have explicit user mappings into master.
July 16, 2003 at 2:14 pm
Viewing 15 posts - 1,471 through 1,485 (of 2,387 total)