If you have SQLServer 2008 Trial edition installed, how can you find out how many days are left?
It doesn't seem to be in the Help-About dialog, or anywhere obvious.
Has anyone ever ran across a program that in a generic manner will execute a sql query and then based on criteria email out alerts. Going to create such a framework but don't want to re create the wheel if I don't have to. It could be used to check various things like if things are setup correctly inside our ERP etc...
Thanks for any thoughts.
Michael
How is it possible that a cached query could take that long. With cache cleared it takes 25000 ms (I know that's just way too long but that's not the issue here). Once it is cached, it takes 2500 ms. What could be the problem here? If it's cached, I assume SqlServer gets it out of the RAM. So, again, 2500ms???
Where do I find this drivers on my .iso image for the server software, or what is the ftp: location to download these files as those are the two options i am given on how to solve this issue.
ubuntu-server 11.10, hardware: dell r210 what I am reading is that I am possibly missing 'mpt2sas' driver somewhere in this boot disc. I'm attempting to download a different version in the hopes that the mistake I made was downloading software meant for an AMD architecture.
I've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a webpage in Visual Studio to, basically, SELECT * from a table in the SQLEXPRESS, but I can never get the connection string to work. Please help
My connection string
"Data
Source=localhost\SQLEXPRESS;Initial
Catalog=test;User
Id=xaa9-PC\xaa9;Password=abcd;"
Error Message:
Query is select * from tblCustomers
where username='johndoe' error is
Login failed for user 'xaa9-PC\xaa9'.
I have my RADIUS server up and running and a custom external captive portal. But I'm not sure:
what information should I send to the Open-Mesh AP with my login form (it is necessary to encrypt the password?, because if I don't use a secret word to encrypt in my network configuration the RADIUS server complaints about it and in the log shows me some strange characters in the password)
I don't know what to do with the "challenge" and "md" parameters in my login splash page.
Thank you very much for your help.
Hi
I currently loook after 20 odd databases in SQLserver 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job.
Thanks
Hello,
I run into the same issue as someone who posted this question on experts-exchange.com (couldn't read the answer though as I don't have an account there):
{Quote Begin}
I noticed that the 180-day Evaluation version of SQLServer 2008 is the
Enterprise version. Is there going to be any problem "upgrading" the Evaluation Enterprise
version to a licensed STANDARD version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?
{Quote End}
Any advice is appreciated.
I have 8 SQLServer installations (on 8 separate servers).
I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making such reports?
Hi,
On a SQLserver, why do we need a weekly update stats job (with full scan) when we have AUTO_UPDATE_STATISTICS=ON for all databases?
Doesn't this option update statistics all the time?
Regards
What is a little bit of snow-covered server between friends, right? From YouTube: This is an experimental Free Air Cooling setup called a Helsinki Chamber. You can learn more about this experimental server cooling technology here. Snow is not a problem for servers in Finland [via Fail Desk] Our Geek Trivia App for Windows 8 is Now Available Everywhere How To Boot Your Android Phone or Tablet Into Safe Mode HTG Explains: Does Your Android Phone Need an Antivirus?
I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.
I was wondering if anyone could recommend some resources in regards to administering MySQL for DBAs already experienced with other relational database (SQL Server and some Oracle in my case). Specifically I'm looking for information around disaster recovery as well as high availability to start with, but I do want to get well rounded with the entire system.
Thanks in advance,
Dan
Hi i have installed and configured ftp server on ubuntu 12.04.
vsftpd.Config
#anonymous_enable=YES
write_enable=YES.
when i drag and drops files to the Sever with filezilla, it fails:
****550 Permission denied.
Error: Critical file transfer error.****
but when i try to do the same thing to another server on the Internet, it works just fine.
I even tried severe times to changes settings in the vsftpd.config file but it had the same problems respectively
Help Thnks
Hi,
I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensible data. Is it possible?
Thank you all for help
I use Windows 7 & SqlServer 2008.
If I run Management Studio as normal user and try to connect to database 'MyDatabase', I get this error message 'The database MyDatabase is not accessible'.
I I run Management Studio per right click 'Run as administrator', then 'MyDatabase' is accessible.
Where & what should I set, to be able to access MyDatabase as normal user?
I have a SqlServer database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on these tables). I have no clue what could be causing this as I would assume zero rows would mean nearly zero space taken.
Any ideas?
Waited to deploy SQLServer 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4 ? You're running out of reasons to procrastinate! The SQLServer team has released CU #1 for Service Pack 1, which should include all of the fixes from CU #3 & CU #4, as well as some others. KB article: KB #2765331 Build # is 11.0.3321 I count a whopping 44 fixes! Relevant for builds 11.0.3000 -> 11.0.3320....(read more)
I have a VPS running Ubuntu server 12.04. A while ago, my host installed an alternative kernel (one of Amazon's EC2 kernels) to fix a boot issue I was having. Now, 2 Ubuntu releases later, this kernel (2.6.31-302-ec2) is still being used even though later (3.2.xx) kernels have been installed.
How can I make the server use the most recent installed kernel, preferably without just uninstalling the EC2 kernel just in case doing so causes issues?
Recently we completed a new MSSQL cluster that we are planning on migrating all existing SQL databases to. This includes our Sharepoint databases, while looking into moving the databases I found the Microsoft documentation for moving Sharepoint 2007, however have not been able to find anything similar for Sharepoint 2003. Can anyone point me to a guide for moving the databases, or provide some tips, instructions or warnings? Thanks
I'm having a strange problem with a SQLServer Maintenance Plan. It's set up to run a Reorganise Indexes and Rebuild Indexes, the history shows it has succeeded, but the fragmentation is still bad and requires me to manually intervene to fix them.
Has anyone seen this before?
We are switching from a SQL cluster to a mirrored solution. The problem is that we have a bunch of programs that would have to switch connection strings to handle the failover. Is there any way the we can set up a redirect or proxy that would take any legacy requests and forward them to the mirrored solution?
Microsoft SSIS Service:
Registry setting specifying configuration file does not exist.
Attempting to load default config file.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
this is my MsDtsSrvr.ini.xml
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>.\SQL2008</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
i found here
http://msdn.microsoft.com/en-us/library/ms137789.aspx
that i need to update my registry. Only entry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS\ServiceConfigFile
is (Default) with no value.
what i must add in registry that i will not get this error any more?
In Windows Server 2003/IIS6 land we typically create an app pool that runs as the identity of an AD account created with minimal privileges simply for that purpose. This same domain user would also be granted access to SQLServer so that any ASP.NET application in that app pool would be able to connect to SQLServer with Integrated Security=SSPI.
We are making a brave move to the world of Windows Server 2008 R2/IIS7.5 and are looking to replicate this model, but I am struggling with how to make the application pool in IIS7.5 run as the identity of an AD account? I know this sounds simple and hopefully it is, but my attempts so far have been fruitless.
Should the application pool identity be a 'Custom account' for a domain account?
Does the domain account need to be added to any groups?