Search results for query: *

http://home.iprimus.com.au/billmcc/PlatformVB/dun/contents.htm This is a good site that will tell you how to use the rasapi's. It has all the code you will need for dial-up networking

looks like I was composing a reply same time as James, sorry for the duplication

i think this is what you ment declare @var varchar(50) select @var = (select alias from Wherever) exec('Select column_name as [' + @var + '] from table') I think that is what you are tyying to do

My appologies for mis understanding the question, before, that is a really good soultion.

does print not work for you. e.g print 'Testing' In query analyzer the text will apear on the messages tab.

add a col;umn to the database called _transfered with 0 and 1 the only add able values. then create a trigger on the table that when a record is added the value is cahnged to true. Hope this helps

a idea could be to do the count as a if statement and if it is 0 then raise error then you could use the on failure method in the dts to capture this. No idea if this will work but its a idea.

try this raiserror ('85009',10,1)

you can save as a structured storage file, this will save on a hard drive and can then be moved about on a floppy or something between computers. To load it on the live computer from enterprise manager right click on the data transformation services folder and chose open, then save to sql...

I would use CallDate + RecNo as the PK, for the only reason that for searching on the table it will be quicker. A identity column would not be too helpful to you in this instance unless you where going to use it in every day life. This is my opinion hope it is usefull.

with a three column table col1 would be the identity, for the first go the value of 1 would go into col1 automatically. insert into test (col2,col3) values ('test','test again')

you could create a job using sqlserver agent, if you do this make sure the sqlserver is not login on as local system. Within the job have 4 steps one for each job. The steps would look like this master..xp_cmdshell 'dtsrun /S servername /E /N dtsname' that should sort it out then you could...

bcp example - this is used from the dos prompt not through query analyzer this gets the data out bcp "select * from database..tablename" Queryout name.txt -c -T bulk insert example -run through query analyzer this gets the data in bulk insert tablename from 'location'

check how the sqlserver agent, and mssqlserver is set up, what user is it loging on as, if it is local system then this can be a reason for it not working.

this is another way to do it, this will only work if the table does not exist in the new datbase select * into otherdatabase..tablename from source_table otherwise you will need to do insert into otherdatabasae..tablename ( columns go here, * will not work ) select columns or * from...

You can try just doing it like this. select forename + surname as name from table

here is a way of finding duplicates, do with it as you like SELECT columns(can't be * and must include the column with duplicates) FROM table WHERE (((column with dups) In (SELECT [column with dups] FROM [table] As Tmp GROUP BY [column with dups] HAVING Count(*)>1 ))) ORDER BY column with dups

here is some code to do what you want: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[disablefk]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[disablefk] GO CREATE PROCEDURE disablefk AS declare @table_name varchar(32) declare @constraint_name...

it was all trial and error, simply going to the command prompt and typing osql /? gives you a list of commands. I then went through and worked out what they all do.

have a look at the rights you have, there is a bulk insert administrators permision, this could have something to do with it