Viewing 15 posts - 3,046 through 3,060 (of 3,232 total)
Set based operations, from my experience, are always much more efficient than row based operations using loops of any kind. I would recommend not using cursors period. Any other row...
January 23, 2006 at 9:24 am
I've done it both ways, adding a prefix/suffix in the DB name and using passwords. I prefer using passwords because of what Jo P. points out. He also makes another great...
January 19, 2006 at 4:51 pm
You may try the 'Execute Process' task in DTS. This should allow you to call a .bat file.
January 19, 2006 at 9:21 am
'...how do i use a wildcard for a column in another table'
I assume that you are trying to compare AgsSite.Descriptor values to the values in tblScootlist.strMajorRoad? If this is...
January 19, 2006 at 9:03 am
I have seen application that use ODBC gather the username/password during runtime and pass them into the connect string along with the DSN.
You may want to explore using the...
January 18, 2006 at 3:53 pm
If you are using the standard ODBC driver for SQL Server, SQLSRV32.DLL, it does not save the password within the DSN. Even if you go into your DSN from the...
January 18, 2006 at 3:26 pm
See osql in BOL:
If neither the -U or -P options are used, SQL Server 2000 attempts to connect using Windows Authentication Mode. Authentication is based on the Microsoft Windows...
January 18, 2006 at 3:14 pm
Add the -E switch to your osql command. Does this help?
January 18, 2006 at 2:33 pm
Please disregard my question.......Windows XP sp2 firewall was blocking the necessary ports.
January 18, 2006 at 2:05 pm
Can you give an example of how one of your fields would appear with the tags?
January 18, 2006 at 1:56 pm
select origfillfactor from sysindexes where name = INDEXNAME
January 18, 2006 at 1:54 pm
This should grab the first row it runs accross based on the EmpID:
INSERT INTO EmployeeTable (Columns) SELECT Top 1 FROM StagingDatabase..StagingTable WHERE .......
January 18, 2006 at 10:02 am
Is that all of the tables in the database? If so and depending on how much data is in each table, you may consider rebuilding your database from scratch. Do...
January 18, 2006 at 9:49 am
It will not list the user names of user inheriting permissions from dbo. I do not know how to tweak it to get the results you are after. Sorry....
January 17, 2006 at 2:23 pm
Viewing 15 posts - 3,046 through 3,060 (of 3,232 total)