Viewing 15 posts - 1,966 through 1,980 (of 1,988 total)
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
The setup is like Karl Klingler said.
Every weekday I plan a full backup of each database at 5.00 am (normal batch end time), should have finished around 8.00 am.
Saterday: full batch...
August 22, 2005 at 2:56 pm
I removed the truncate log step and the no_truncate clause.
So far so good. Thanks for the advice.
I'll repost in a few days.
August 22, 2005 at 3:05 am
It might be not needed if it isn't visible to the outside world, but every service pack fixes some bugs.
August 20, 2005 at 12:07 pm
although not a security tester, microsoft released a tool to report how properly your sql server is configured.
August 20, 2005 at 11:51 am
1)It is very likely your network is congusted, because your query launched locally just runs fine.
Any hubs remaining? Working on a WAN,dial-up?
Returning a very large dataset ?
ps Sure that SET...
August 20, 2005 at 11:46 am
we use the following connection string in DAO & access 97
"ODBC;DRIVER=SQL SERVER;Description=SQLServer;SERVER=10.0.5.100;UID=user;PWD=user2;DATABASE=master;Network=DBMSSOCN;Address=10.0.5.100,1433;APP=BT
August 19, 2005 at 7:12 am
Viewing 15 posts - 1,966 through 1,980 (of 1,988 total)