Viewing 15 posts - 1,741 through 1,755 (of 1,769 total)
If I read this correctly
H1 gives a list of products identified by species.ID and producttype
D1,D2... gives the amount of a specific size
and you want it presented in 1 line species...
September 3, 2005 at 7:03 am
You can implement the log shipping using sql-scripts
Backup database 1, restore to other in Standby mode (with standby or normally)
Backup log database 1, restore to other (with standby or no recovery)
Backup...
September 2, 2005 at 5:55 am
1) Why aren't you using
AND pb.SalesText like 'A%'
instead of
CONTAINS(pb.SalesText, 'A*') ORDER BY SalesText, VendorName
No need for the fulltext indexing and uses a regular...
September 1, 2005 at 11:27 am
Depends on what Access version you are using since the more recent ones work with MSDE (slimmed down sql server). In this case they have the same query syntax.
1) The...
September 1, 2005 at 11:11 am
IIS en SQL SERVER on the same machine?
Is is possible to put IIS on one machine and SQL Server on another?
August 26, 2005 at 4:59 am
How is the authentication to sql server set up?
Windows authentication or sql authentication.
August 25, 2005 at 10:44 am
do you log in using Windows authentication or sql authentication?
August 25, 2005 at 5:12 am
Be sure your idenitity fields are still identity fields, also your timestamp fields.
August 24, 2005 at 4:35 am
Any recent changes (new programs,...) that could coincide with the start of the occurances?
August 23, 2005 at 1:24 pm
Could be a permission problem. You have no problem running it under the sql server agent account?
August 23, 2005 at 1:17 pm
You can script out the jobs, by rightclicking the job and chose All Task -> generate script.
August 23, 2005 at 1:14 pm
Hello Lynn,
The option NT-fibers is generally not needed and should be turned off.
Microsoft has a document on
How to determine proper SQL Server configuration settings
http://support.microsoft.com/default.aspx?scid=kb;en-us;319942
a longer version can be found...
August 23, 2005 at 12:03 pm
SQL Server always expects . as decimal seperator.
Language settings affects system messages & datetime formatting.
See "languages, supported" in the books online
RayM,
Some countries, like Belgium, use 1,5 instead of 1.5 for one...
August 23, 2005 at 11:49 am
2)The sql server administrator will be able to reveal it all.
Perhaps using encryption on sensitive data will hold them off changing it.
August 23, 2005 at 11:33 am
Viewing 15 posts - 1,741 through 1,755 (of 1,769 total)