Does anyone know how to fix issue with TrustedInstaller.exe when it takes a lot of CPU?
Operating system: Windows 2008 x64
Windows' Modules Installer service is set to Manual.
Hello everyone,
I am using SharePoint Server 2007 with collaboration portal template on Windows Server 2008. The default search address for a site is pointed to /SearchCenter/Pages/Results.aspx. Any ideas how to change the address to some other address? Either programming solution or easy config solution is fine.
thanks in advance,
George
I'm using SQL Server 2008 Express and I'm doing a bulk insert of data. I'd like to have more verbose error messages, ideally printing the data that failed to be inserted. Is that possible?
I was using
CreateEx(
0,
className,
"XXX",
WS_CHILD | WS_VISIBLE | WS_CLIPSIBLINGS | WS_CLIPCHILDREN,
rect,
parent,
0);
in Visual C++ 6.0.
when i port the same to VS 2008..,
its giving an error message saying that..
error C2664: 'BOOL CWnd::CreateEx(DWORD,LPCTSTR,LPCTSTR,DWORD,const RECT &,CWnd *,UINT,LPVOID)' : cannot convert parameter 3 from 'const char [7]' to 'LPCTSTR'
how to rectify the same
thanks
Chitra
It appears there is a memory leak in the Status property of the SMO Database class.
Using the code below with SQL 2005 SMO libraries works fine, but as soon as you use SQL 2008, the memory leak appears....
Any other good way of getting the database staus in SQL 2008?
A quick example that magnifies the problem:
private void button1_Click(object sender, RoutedEventArgs e)
{
for (int x = 0; x < 100; x++)
{
CheckStatus();
}
}
private void CheckStatus()
{
Server server = new Server("YourServer");
DatabaseCollection dbc = server.Databases;
if (dbc.Contains("YourDatabase"))
{
DatabaseStatus dbStatus = dbc["YourDatabase"].Status;
}
}
Hi,
I installed SQL Server 2008 on a Win XP SP2 workstation in a AD domain and configured to run with the "Network Service" account. In my error log I have the following message (Event ID:26037):
The SQL Server Network Interface library could not register the Service
Principal Name (SPN) for the SQL Server service. **Error: 0xd, state: 13**.
Failure to register an SPN may cause integrated authentication to fall
back to NTLM instead of Kerberos. This is an informational message.
Further action is only required if Kerberos authentication is required
by authentication policies.
The strange thing is that I have another SQL Server 2008 installation in a Win 2003 server configured in the same way and there I do not have this message.
My questions are:
Does anybody know if there are limitations with Kerberos on Windows XP and SQL Server?
Why the SPN is not automatically registered on Win XP when I use the "Network Service" but it works on Windows 2003 server?
THANKS!
Hi,
I have the following query which uses a date variable, which is generated inside the stored procedure:
DECLARE @sp_Date DATETIME
SET @sp_Date = DateAdd(m, -6, GETDATE())
SELECT DISTINCT pat.PublicationID
FROM PubAdvTransData AS pat
INNER JOIN PubAdvertiser AS pa ON pat.AdvTransID = pa.AdvTransID
WHERE (pat.LastAdDate > @sp_Date) AND (pa.AdvertiserID = 12345))
The problem is that the @sp_Date value appears to be being ignored and I am wondering why? Have I defined or used it incorrectly?
sql microsoft sql-server-2008
User error...
Thanks, R.
I just installed microsoft chart controls software on my system. Now the chart is present on the data toolbox on visual C# 2008 express edition. But it is not available on visual web developer 2008 express edition
When I tried
<asp:chart >
it is not available...
Do I have to do some procedure to get it active on web developer.
Can anyone tell me what is the problem...
I added the below said to the web.config, The is available but I am getting an error..
The type or namespace name 'DataVisualization' does not exist in the namespace 'System.Web.UI' (are you missing an assembly reference?)
What should I do now...
I am using InstallShield 2008 premium edition. I created one basicMSI project only to target x64 platforms. I changed summary property to "x64".
But this installer is writing registry entries in "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CompanyName\ProductName" .
I am using both installshield script and vc++ DLL for custom actions.
Why x64 installer is using WOW64 registry ?
Hi guys,
I have two SQL Server 2008 databases called Anna and Bob.
Bob has to pull and transform data from Anna to keep updated
his tables.
Ideally Bob will be
always synchronized with Anna,
but some delay would be acceptable.
What is the best way to do this?
Thanks in advance.
I've created a windows service in c#, using VisualStudio2008
I pretty much followed this:
http://www.codeproject.com/KB/dotnet/simplewindowsservice.aspx
I created a setup project, as instructed to in the article, and ran it...
it installs my service to c:\program files\product etc.... however, it does not then appear in the services list..
What am i missing?
Hi,
My company receives data from an external company via Excel. We export this into SQL Server to run reports on the data. They are now changing to PDF format, is there a way to reliably port the data from the PDF and insert it into our SQL Server 2008 database?
Would this require writing an app or is there an automated way of doing this?
Hi there,
I am currently building a webshop for my own where I want to increment the product-stock when the user fails to complete payment within 10 minutes after the customer placed the order. I want to gather information from this thread to make a design decision.
I am using SQL Server 2008 and ASP.NET 3.5. Should I use a SQL Server Job who intervals check the orders which are not payed yet or are there better solutions to do this.
Thanks in advance!
Martijn
I'm using MS SQL 2008.
Is it possible to create a script to loop over all tables in a database generating a set of index drop scripts and create scripts separately?
What I have to do is drop all indexes on a set of databases to run a heavy data load process but then I want to re-enable all the indexes. I don't want to have to go through each table and script an index drop and then index create.
Thanks!
I have two tables in my database schema that represent an entity having a many-to-many relationship with itself.
Role
---------------------
+RoleID
+Name
RoleHasChildRole
---------------------
+ParentRoleID
+ChildRoleID
Essentially, I need to to be able to write a query such that:
Given a set of roles, return the unique set of all related roles recursively.
This is an MSSQL 2008 Database.
I have a SSIS package I am trying to schedule. I create a new job under SQL Server Agent. On the Command line tab of the jobstep, I choose "Edit the command-line manually".
The changes are retained as I switch from tab to tab within the job step but whenever I exit and save the job, the changes are lost.
Any ideas what's going on?
I'm on SQL Server 2008.
Hi everyone,
How can I insert time wait value in web test in VisualStudio2008 test edition?
I have recorded a web test that I want to use in Load test. Now I need to put some time delay between pages in web test.
Thanks a lot.
Ok, so I'm trying to select an amount of rows from a column that holds the value 3, but only if there are no rows containing 10 or 4, if there are rows containing 10 or 4 I only want to show those.
What would be a good syntax to do that? So far I've been attempting a CASE WHEN statement, but I can't seem to figure it out.
Any help would be greatly appreciated.
(My database is in an MS SQL 2008 server)
The cluster managing software for managing clusters on a windows server 2005 cluster had a checkbox for "allow application to interact with desktop" when creating a generic application resource. This appears to be gone in the management software for server 2008 clusters. Does anyone know where this option, if it still exists, is?
I am not able to remove sql server 2008 from my machine.
I installed it in the past as a part of the installation of an application, this installed the runtime of sql server 2008 SP0. But now I cannot uninstall.
I tried to use the setup of SP0 and even of SP2 but it was not able to uninstall, by giving fatal errors when it does the preliminary checks.
This means that the only option I have is format my machine?
I cannot even intall a new instance, something is really corrupted.
Is it a way to remove it manually?
I've created small database under SQL Server 2008. Now i wanted to move it to SQL Server 2005 and it doesn't work since it doesn't have Time datatype. What option do I have to store only time in SQL Server 2005. I've written small TimeSheet application which needs to write hours and minutes mostly in format like 05:30:00 (hh:mm:ss) but ss is optional.
Hi,
I want to move 500 table from Database to other with their data and constraints all the tables have column who has default value, I used SSIS using "Transfer SQL Server Object Task" and I choose to copy all tables, copy data and primary keys, it copies the table except the default bindings
I tried in SQL Server 2008 CopyAllDRIObjects Property but still the same result.
How can I copy all tables from database to other with their data and maintaining their constraints.
asp website with access database freezes for 30-60 seconds intermittently. The site is on an internal 2008 server. About 25 users access the site simultaneously. Is it just the limits of access or can i do something to improve the situation? change any timeout/refresh settings anywhere? or could it be a problem with the network?