Search results for query: *

I have a database that is using the Security.mdw for user login control. What was happening a few weeks ago was that each time the main database was open, the login prompt would appear and usually the username of the user who is opening the database would appear. For some unknown reason, this...

So I've been trying to tackle this procedure and I just don't see where the error is coming from. The error I get is "Numeric or value error: character to number conversion error". I'm a SQL Server guy and this was originally in SQL Server, but this other project I'm on is having me convert...

I am trying to create a stored procedure that outputs records to a table. Each day the sproc is run, I would like it to output it to a table name and concatenate the current date to the table name. This is what I wrote, but the error I'm getting is when it's building the SQL select statement...

Sorry if this is common sense, but I'm new to DTS here. I was wondering how do you go about backing up all the local packages that I've created? I can easily backup the databases I have, but seeing that packages are outside the database area, how can they be archived? In case SQL Server...

I have an ActiveX Script task that uses recordset to open up a table within a database. To facilitate not having to go to all my packages and edit the connection strings, I want to use a UDL file that stores the connection string...this way I only have to change the UDL file when going to...

I'm attempting to parse out a column of data in a table(Table A) into another table(TableB) that has all the fields. In total there are 127 fields that are going to be populated. Can I use a standard SQL INSERT statement to do this or will I reach a max limit on the size of my SQL statement...

I have a fixed length text file in which 1 rec has many fields that stretch to a column length of about 10,000. The DTS wizard bugs out at about the 3700 position number and it doesn't allow me to designate a field beyond that; nor can I remove one of the automated field designators. Also, I...

I have an existing table in which I want 2 fields to make a composite key. Both fields are set to "allow null". When I use the "alter table" and add a primary key constraint, I keep getting the error - "can't create primary key on nullable column. Any suggestions? Thanks

How do I programmatically create a link to a delimited text file using a defined file schema?