Is it safe to place indexing on a live production database without shutting it down first? I have a client that has a table, and I need to place indexing on two columns as they are searched u...
An EE genius figured out this script below to find injected junk in my SQL Server DB. I'd like to take it a step further and perform an action if some junk is found. Can this run in a DTS pa...
Hi.
What I want to do is pretty simple.
I have an SSIS package.. with an Execute SQL task.
Basically I want to restore last night's backup to another server, then do stuff on that another...
I'm trying to setup email alerts via SQL's maintenance wizard... I have everything setup except the Outlook profile.. I don't have Outlook on the server, however, I do have a SMTP server I ca...
I configured a new server with windows 2K3 standard R2 with updated .net and installed SQL server 2005 dev edition. I am duplicating everything from a previous server running identical softwar...
I want to sort out put in the following way
Prod A Cust_1
Prod A Cust_2
Prod C Cust_1
Prod C Cust_2
Prod B Cust_1
Prod B Cust_2
is there a way to sort entries forcebly (e.g. Prod ...
Hi,
We are currently in the process of setting up two databases that will use replication, one as a master and one as a slave. However, when it comes to the point where we may need to restore...
I have a query that I returns columns NULL for a specific code, see image attached. I need a query that I return the columns that are not NULL. My result should be only columns for a specific ...
Been through all the listings on the act support forums and knowledge base and followed instructions.
Original error message was
Check network connection or firewall settings.
Used actdi...
I am working on a program that I didn't develop. I am trying to understand how the original developer is getting data from the DB. I've never used parameters like the attached code to get da...
I have the following table:
Key , Qty, Date
100 1 2008-06-27 12:57:00
100 2 2008-06-27 13:57:55
100 7 2008-06-25 12:57:00
How can I retrieve one record per day and ...
An SSRS 2005 is developed on a dev box and deployed. After deployment, all developers can access and run it, but end users complain getting erros "Reporting service error". The permissions gra...
Hello,
I run an sql express 2005 in my SMB, i want to take automatic backups in specific intervals.
Thanks,
Can MS SQL 2005 - used as a backend with VB.NET as frontend - work on other platforms (Linux etc) or is it Windows specific ?
Hi,
I am trying to create a partion function, group and scheme. I seem to run into an error while creating the Scheme.
Volume of data expected each month is 4+ million.
Here are the...
I have a simple statement I am runniing:
backup database scan to disk ='c:\temp\backup.bak'
I know you can verify readabilty of a backup using the backup command from the context menu, ...
This is a bit difficult to explain. Basically, I have a 3rd-party product that acts as a "data-pump" between our manufacturing plant and my instance of SQL Server 2005. Activities in the pla...
I have a database with multiple schemas each containing structurally identical tables (different data). I need (in the interest of reducing objects) to reduce all the schemas down to one. Ho...
Dear Expert,
I have a query like this:
insert into dbo.Master_Tier_Assignment
Select 'Non-Named', 'Other', 'P', 500, T.Trimed_term, '199', 500,
Cast('2008-04-01T00:00:00.001' AS Datetim...
Greetings Experts!
I hope someone could help me with this, I am totally stuck!
I need to add a new role assignment on the report manager, so that my application which happens to be on a diff...
When MSDE is installed on a server (i.e. Windows Small Business Server), what is the proper way to then install SQL Server Professional Edition.
We tried to just install an instance of 2005...
I have a Access 2003 FE with a MS SQL 2005 backend. I need to be able to copy the backend database at night to be able to update the data in an developmental database that we use to test agai...
I recently used SSMA to migrate the backend of our Access database in SQL Server 2005. I noticed
that in a couple of tables some of the column names had been changed (words deleted or rearran...
I have set some default values for my database columns. For example zero for an int data type, GetDate() for a dateTime column etc. However, when I try to add a new row I am informed (with the...
Hi,
I have SQL Server 2005 and using a database with arabic collation. Certain fields have english and others have arabic (there are no mixed languages, strictly one language per column).
...
