Search results for query: *

Does anyone have a good method or script they use for benchmarking new sql servers?

Is there a way to run an update in SQL using some function to remove any non ascii characters from the column? We are loading data from AS400 and somtimes there are extra characters and we need to remove them.

Is there a way to change the page response.redirect sends the user to? I have a combo box that has a list of values and depending on what the user selects, I am refreshing the page and running a db query to get the file to redirect the user to based on their selection. Below is the code to the...

I am building an asp application and cannot figure out how to compare two integers.. Is this possible using vbscript? Below is a brief example of what I am trying to do.. Any suggestions?? dim strIntOne dim strIntTwo strIntOne = CInt(rsValues("value")) strIntTwo =...

I have setup log shipping on a primary and secondary server. I am testing the fail over and am having trouble with the sp_resolve_logins procedure. I can successfull bring up the standby server as the primary but when I use the resolve logins procedure i run into problems. Has anyone...

I have an application that I need to track time spent on a specific task.. My question is, should I use date time to do this? Later I will need to run totals on the time spent on each task.

I am looking for a solution if possible using asp or vbscript to talk between browsers. If you have ever used yahoo mail and when you compose a message, you have an option to open another window and select the address you want to send the email to. when you select that user, that value passed...

I am looking for a solution if possible using asp or vbscript to talk between browsers. If you have ever used yahoo mail and when you compose a message, you have an option to open another window and select the address you want to send the email to. when you select that user, that value passed...

Has anyone ever had to drop constraints on one schema, truncate data and then move data from an identicle schema and then recreated the constraints.. My question is, is there an easy way to do something like this?? I have tried it a few times and for some reason I get some primary key...

I have a linked server connection to a sybase table and have created a view with a join that joins local MSSQL tables .. I am trying to create an indexed view but cannot. Is this even possible in this situation? I read where you can do this with mssql but can you do it using a linked server...

I am currently using the confirm box in my page but I would like to customize the way the box looks. I would like the user to choose yes or no instead of ok or cancel.. Below is my code. Is there another way to do this? <script language=&quot;JavaScript&quot;> function verify() { var...

I have a column in my db that stores the date value as the following in varchar 07292002163002 mmddyyyyhhmmss I need to convert this to datetime and am having no luck. below is my attempt. select convert(datetime, timestampd, 109) from stage_uptime Any suggestions??

I need to be able to fail a package if my query doesn't return the correct number of records. Is there a way to fail a dts package if a certain criteria is not met?

I am having a problem calculating dates. I have a field datetime and I need to delet records older than 60 days.. my query is something like this. delete from table where statdate < dateadd(day, -60, getdate()) For some reason this doesn't work.. Can you give me some suggestions?