Viewing 13 posts - 2,341 through 2,354 (of 2,354 total)
As a long time VB programmer / SQL Server DBA, I would not use Hungarian for any object names is a database. One of the biggest challenges I have faced...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 3, 2004 at 8:57 am
Ah. The joys of inheriting a database.
It sounds as if you have multiple issues.
If I understand the first issue, the job is set to run as a user against...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 23, 2004 at 9:15 am
A few ideas that may work.
What type of sql autentication is the application that you want the users to use doing?
For example, if the users are connecting with SQL authentication...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 23, 2004 at 8:57 am
This is a shot in the dark, but this sounds similar to an issue I have run into with ADO. SQL server can't figure out the specific row that needs...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 17, 2004 at 5:53 am
Unfortunatly, I do not.
Download the beta and try to create a table. Then you can let all of us know!
Actually, there is a forum for SQL server 2005 on this site. Post...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2004 at 11:48 am
Keep doing it with option A.
You are asking for trouble, as well as potential performance issues, with option B
Been there, done that!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2004 at 11:35 am
Unfortunatly, SQL 7 or greater will not allow a constraint between two different data types or two identical datatypes with different sizes, even if they are "functionally identical".
So, what you...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2004 at 11:31 am
If you are using Windows Authentication and ODBC, your connect string is in conflict with itself.
Yours:
SQLServer = "DSN=" & maDB_LOC(intIDX).lrdata_dsn & ";SERVER=SQLSERVER;Network=DBMSSOCN;Address=10.0.18.5,1433;UID=" & strLoginID & ";PWD=" & Me.txtPassword
Mine:
Provider=MSDASQL.1;Persist Security Info=False;Extended...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 24, 2004 at 1:57 pm
I think the problem started when you got the "SIDS" out of sync between the master (syslogins) and database tables. The user "sa" is mapped to dbo in each individual...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 23, 2004 at 2:23 pm
Sorry, slight misunderstanding.
But, I still stick with my original thought that this is normal, or at least not unusual, after doing a reindex and a shrink.
Are your database file...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 23, 2004 at 1:48 pm
You may be confusing index free space with database file free space.
Index free space refers to the free space in each page of an index. When an insert operations occurs,...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 23, 2004 at 1:13 pm
This doesn't sound like a SQL problem, it sounds like a Crystal problem.
While Crystal is designed to simply "connect and create" reports against a database, it's notoriously slow if...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 23, 2004 at 8:54 am
Transaction logging cannot be "turned off", regardless of the recovery model in place.
SQL Server issues a "checkpoint" every 60 seconds in the transaction log. This interval can change depending upon...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 19, 2004 at 9:07 am
Viewing 13 posts - 2,341 through 2,354 (of 2,354 total)