Search results for query: *

I am trying to encrypt a column in SQL server 08. I am using AES, certificate and symmetric key. Can I change the data type and length of the encrypted column from varbinary(128) to a smaller length and also change it to varchar? Is there a way to prefix the encrypted column data? Is there a...

I am trying to upgrade from SQL server 2008 to SQL 2012. Do we need to migrate each of the databases? or is there a way to install SQL 2012 and upgrade all databases automatically?

I would like to convert a zoned deciamal (IBM's S9(9)V99 last character is overloaded) to SQL server numeric data type with decimals. Can a query be used for it? or are there built in conversions that we can use?

I am trying to create a derived column of data type char from integer variable and a string "ABC" In SSIS when I use this as an expression for derived variable "ABC"+ (DT_STR,3,1252)[id] it becomes a nvarchar/DT_WSTR ? To comply with same data type in DB I need char. I think it's happening...

I have a full back up of a large database in SQL server 2008. the back up was done using standard optinos in Task-> Backup When I try to restore in SQL 2008 R2, it goes fine almost till the end( The files are created) and then I get this error. The media family on device is incorrectly formed.

How do we automate FTP downloads from a server? I would like to schedule and also make sure security protocols are enforced.

In the web app(.net IE7) for URL links we have http://wwww.<sitename> show up for the data displayed on the page. When clicked on the link the site opens up as http://wwww.http://wwww.<sitename> and we get an error as the site doesn't exist. Data for URL comes form a database. Is there a way...

In the web app(.net IE7) for URL links we have http://wwww.<sitename> show up for the data displayed on the page. When clicked on the link the site opens up as http://wwww.http://wwww.<sitename> and we get an error as the site doesn't exist. Data for URL comes form a database. Is there a way...

I am trying to develop a password protected web page using VBscript, MS Access and Front Page 2003. I am very new to VBscripting and found a good article on Microsoft's web site(http://support.microsoft.com/kb/825498/en-us). I tried to implement it but I am getting a HTTP 500 server error. I...

I need to set up a password protected secure website (https) for getting files from our clients.The clients should be able to login and then upload the files We have IIS as our web server. Any suggestions on how to approach? Thanks

I need to set up a password protected secure website for getting files from our clients.The clients should be able to login and then upload the files We have IIS as our web server. Any suggestions on how to approach? Thanks

We have a web application that users access from different locations for data entry and reports. One of our users is having an issue and we cannot replicate it. Is there a way to shadow users session with their permission and see what is going on? I have a windows xp machine. The user and us...

We have a PDF that we made in Adobe LifeCyle. When users click submit by email, a pop up window comes asking users to choose email client. Our users are getting confused which one to choose. Is there a way to make the desktop email application as default so that users don't need to choose?

I haven't used Flash before and downloaded a trial copy of Adobe Flash CS4. I have two questions regarding a map. 1. Hyperlinks I have a map of US with some agency specific links across different states. I need to add hyperlink to a star in the state. A state can have multiple stars. I have a...

I have a US map(gif file) with state borders. Each state has some stars to point to the location where our centers are. I used Front page to create an image map - when user clicks on a star, a new web page with the location details will show up. How can I zoom a state?(because oif the size and...

I am new to VB/ASP.net I have a login form with user data in SQL server database. I am trying to compare the password for the username the user entered on the form with the one stored in database. In the button click event I am trying to use the following, but I get an error. Dim strchkpw...

I have an access database on a network share drive. Multiple users access it. We get a security warning when we try to open and when we trust and enable, it opens. Is there a way to automatically add the location on the network as a trusted location so that each user does not have to add it...

I am trying to check if a query exists. Here is my code. I get a runtime error: Object variable or with block variable not set Private Sub CmdCheck_Click() Dim db As Database Dim qry As QueryDef Dim i As Integer For Each qry In db.QueryDefs If qry.Name = "qryTempcat" Then i = 1 End If Next...

I want to run multiple update queries(aorund 25 statements) Eg: update table1 set col2=null where col3 is null; update table1 set col4=null where col5 is null; Is there an easy way to run all the update staments by placing all of them at the back of a command button or can I use modules? If I...

I have a table where I would like to rank based on a group and column. I want to create a rank column for each type based on cdate column as below. ID Type CDate Rank 1 Pens 5/20/2000 1 2 Pens 4/10/2004 2 3 Pencils 1/2/2000 2 4 Pencils...