Forum Replies Created
Viewing 15 posts - 1,576 through 1,590 (of 2,487 total)
-
RE: How to script a Job...
Try this. Fill in the blanks as indicated by << >>. Put it in a job with a ActiveX Script step.
One thing you might want to check is where the...
--------------------
Colt 45 - the original point and click interface
-
RE: Exporting Data from an offline Access database to SQL Server
David
I think that should be "30 foot"
--------------------
Colt 45 - the original point and click interface -
RE: Query Analyzer Results - Print with headings?????
In Options on the Results tab, choose "Results to Text" and "Tab Delimited". This will give you the headings and data that you can cut & paste straight into Excel....
--------------------
Colt 45 - the original point and click interface -
RE: Views or Stored Procedure or UDFs : WHEN to use them ??
Generally you would put everything in stored procedures. Even simple selects that return all records from a table (eg: list of companies for a combo box). The main overall benefit...
--------------------
Colt 45 - the original point and click interface -
RE: Error ConnectionWrite
If you could post a bit more information about what you're trying to do and where the error appears wemight be able to help you better.
--------------------
Colt 45 - the original point and click interface -
RE: Views or Stored Procedure or UDFs : WHEN to use them ??
VIEWS : The purpose of a view is to select a data set from one or more tables, they do not have parameters
--------------------
Colt 45 - the original point and click interface
RE: Network Error
Are there any other error messages in the SQL Error Log?
Are you generating a cartesian join when you include both join conditions? Try using SET ROWCOUNT to limit the number...
--------------------
Colt 45 - the original point and click interface
RE: RESTORE DATABASE PROBLEM
... and if necessary, kill any current connections.
--------------------
Colt 45 - the original point and click interface
RE: Jobs failing with event 208
Both services startup using a domain user account.
Problem hasn't re-appeared for the last couple of days. We could have isolated the problem to a dodgy WINS entry that was preventing...
--------------------
Colt 45 - the original point and click interface
RE: error while executing sp_executesql
Ok, the reason you would have got the sp_executesql is because you haven't set the command type to StoredProcedure. I think by default the command type would just be text...
--------------------
Colt 45 - the original point and click interface
RE: Active/Active SQL cluster.
Have you had a look at the white paper here?
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
--------------------
Colt 45 - the original point and click interface
RE: error while executing sp_executesql
Just wondering why you would use sp_executesql anyway?
Couldn't just run,
exec spGetAuthorsList @author_id=1, @FindExact=0
--------------------
Colt 45 - the original point and click interface
RE: Uploading Data from Text file with different column name
OK, so can you map out the fields
A222|ZS08 |0005 |H350 |GENERAL_REPAIR |A |28.02.2004|01.02.2004|0000352836 |000
EG
Table: A222 Field: ZS08 Value:0005 etc...
BTW, who thought up the names and file format?
--------------------
Colt 45 - the original point and click interface
RE: Code Generation
ApexSQL Proc Blaster does do this. There are other products out there as well that generate a full end-to-end solution.
EG: Iron Speed Designer - Point it at the database and...
--------------------
Colt 45 - the original point and click interface
RE: TSQL stored procedure, User roles, best design approach ?
As we are talking about a database engine that is far and away more powerful than Access. Is there any reason to apply the same logic?
0)...
--------------------
Colt 45 - the original point and click interface
Viewing 15 posts - 1,576 through 1,590 (of 2,487 total)