Search results for query: *

Hello - I am building some dynamic sql and I have a problem with a field I am reading from a database that contains a double quote that I am then trying to include in some dynamic sql to update another table. Basically I have this problem: create a recordset by selecting * from table A loop...

I am stuck here. I have 3 databases, A, B and C. Databases A & B contain my data for two different locations. Database C contains my custom stored procedures and functions. I would like to be able to call a stored procedure which resides in database C from database A. I want the stored...

I am using WSS 3.0. With regard to the built in Announcement web part, I would like to display more than 5 current announcements at a time on the main page. Currently, it only displays the 5 newest announcements. Can this be increased, preferrably to display all that have not expired?

IIS 6.0 Last week a page on my classic asp site started producing frequent 500 errors. The iis log file contains the error, however it is missing the detailed data of where the error occurred and why. It has the page and the 500 error, but doesn't tell me on what line and why the error...

How do you modify/customize the email message that is sent when you add a new user to your sharepooint site?

I have this up and running, but I need to know how to modify the forms login page. I am trying to use Sharepoint Designer 2007, but when I attempt to save the login.aspx file, it tells me there server must be running either Frontpage extensions or Sharepoint Services. What am I missing here...

With WSS 2.0 is there a way to add content (ex. an announcement) to a site and then automatically have it update all of the subsites with the same addition?

WSS 2.0 I saved a site as a template, so now I have a xx.stp file. I would like to include this template in the list that you get when you create a brand new top level site. How can this be done? Right now, I just see the default templates that Microsoft gives you out of the box. Thanks

I am creating some disaster recovery documentation and doing some testing. My problem is: On my production SQL server all of the sql data is located on drive E:\mssql\data\*.* and I am trying to restore all of the data to a new server on C:\mssql\data. I was able to restore the master db...

I have a line of code that is randomly giving users a problem: Redim yArray(3,Ubound(xArray,2)-1) In the IIS log file it gives me a 500 Out of Memory. The server has 2GB and pretty much runs with 1.3GB free. Other posts on the net have said this could be caused by two things in the second...

I have friendly error messages turned on, so when a user experiences an Http 500 error, it will display the page, line number and error. Is there a way to retrieve this data from the web server. If I look at the IIS logfiles, it just gives me an abbreviated portion of the error. I need to...

I have setup SQL Server Agent to use an Outlook Mail profile. When I created the mail profile, I used the same domain account that the SQL Server Agent runs under. I believe everything was working and now I have some problems. Right now I can successfully start and stop a mail session by...

I was tasked with modifying an xsl file and I know very little about xsl/xml. I need to read the value of a node and then determine if it contains a string value. I have been researching xpath and the contains function but I am having problems. I found this link on here...

I have a sharepoint server setup with multiple subsites. We created a DNS entry in Active Directory called "intranet" that points to the IP of the sharepoint server. I would like to be able to use Host Headers to forward the "intranet" DNS entry to a sharepoint subsite. How do I create a host...

This has to be something simple that I am overlooking, but I have the following code that is driving me crazy. <a href="excel.xls" target=_blank>Excel file</a> I am just trying to open an excel file in a new window, the new window opens however IE attempts to translate the file into html...

I have a sql agent job setup that runs a simple activex (vbscript) script to map a drive to our AS400. When I run the scheduled job, the job is successful, however it maps the drive as Z:\Disconnected Network Drive. I can access the share, but I can't disconnect the mapped drive in a later...

I have the following vbs file that runs fine if I run it from windows explorer. If I try to create a task in a DTS and run the same code I get the error: Variable is undefined: WScript. It errors on the line: Set WshNetwork = WScript.CreateObject("WScript.Network") The code is mapping a...

I just setup remote desktop on a host machine. If I remotely connect with Remote Desktop, I am notified if a user is logged in and I have the option to kick them off and log in. My problem is after I make the intial remote desktop connection, if a second user tries to remote desktop to the...

I setup up a sql server agent job to run a batch file that does nothing more than copy some files from a network location to a share on the local SQL server where the batch job is scheduled to run. My only step in the job is of type Transact-SQL and is as follows: exec xp_cmdshell...

How do I setup my site so that no matter what page you visit, the address bar displays: http://www.domainxyz.com, instead of the full path to all the pages? Can this be done without frames?