need to establish sound backup/maintenace/security practices

We are s/w development company with a number of installations that use SQL Server. We are looking for a qualified individual who will help us establish good db security, backup and maintenance procedures and practices for our production sites. We are located in Los Angeles, CA, local contact would be much preferred.

Need to increase Job History SQL Server 2005

We have an application uses SQL Server 2005's sqlagent job feature to runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes depending on the job. Every now and then one of these job runs will error however by the time anyone notices the job run history information is cleared from the MSDB job history tables. Anyone know where I can set the size/retention for job history? Thanks -- Mark D Powell --

SQL 2005 (Express with advance features) reporting services

Hello. I am have trouble getting the above to work. MS IE (Ver 6 SP2) does not access; http://localhost/reports/ correctly. I expect to get the Report Manager but instead I get (in IE panel); ---------- <%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %> <%@ Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI" Assembly="ReportingServicesWebUserInterface" %> ---------- Regards JC....

Many to many table design question

Originally I had 2 tables in my DB, [Property] and [Employee]. Each employee can have 1 "Home Property" so the employee table has a HomePropertyID FK field to Property. Later I needed to model the situation where despite having only 1 "Home Property" the employee did work at or cover for multiple properties. So I created an [Employee2Property] table that has EmployeeID and PropertyID FK fields to model this many 2 many relationship. Now I find that I need to create other many-to-many relationships between employees and properties. For example if there are multiple employees t

Windows Auth issue

I have one machine with an application running that many users need to log in and out of quickly. Logging off the machine, logging in and restarting the app takes too long. Users already log into the application using their windows login and password which I check against the AD, then I build connections strings so SQL Server knows who is logged in - which I need for auditing. Using SQL authentication is not an option. Is it possible to make a connection string to SQL Server using Windows Authentication using a different windows user than the one logged into the machine?

Stored Procedure - Writeline Where

I am trying to create a stored procedure to write out to a text file. I would like it to write a line for each instance of a select statement. Any help? Write information Where field1 = String

Windows Authentication (SQL Server 2008)

We are using SQL Server 2008. As an administrator on the box (part of the admin group), I assumed I could use Windows authentication to log into sql server. However, it is giving me a login failure. #1) How can I verify that sql server is set up to use windows authentication? #2) If not, is there a way to adjust the setting (via regedit or other means)? #3) Can I assume that the admin group has the rights to login into SQL Server (this may be an assumption that is no longer valid). What group would a user need to be in to be able to have the ability to authenticate on the s

SQL Query date doubt

Hi: Please, could you help me with this SQL query ? I need get data from last 3 months, but it=B4s shows me only January's data. (Query doesn=B4t get data from november and december/2009) SELECT TOP 10000 CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101) AS SummaryMonth, Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, APM_AlertsAndReportsData.ComponentName AS Component_Name, AVG(APM_ResponseTime.StatisticData) AS AVERAGE_of_StatisticsData FROM (Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID =3D AP

count(*) by hour

Hi all I have this query SELECT COUNT(*) FROM Pro WHERE D_TIME BETWEEN '2010-02-14 00:00:00.000' AND '2010-02-20 23:59:59.000' AND convert(varchar(30),D_TIME,114) BETWEEN '00:00:00.000' AND '00:59:59.000' which gives me the total count for 00:00-00:59 from 02-14-10 thru 02-20-10. i need to get for all 24 hours in 1 statment. Time Total 00:00-00:59 01:00-01:59 02:00-02:59 ...... 23:00-23:59 Thank you

Place a message in the outbox of Outlook

Is there anyone out there who can tell me how to place a simple message from within T-SQL into my Outbox of Outlook (not Outlook Express) on the same machine? I have SQL Server 7, I don't have an Exchange server and I haven't setup Mail in SQL Server. Any help will be appreciated.

restore backup and roll forward versus detach/attach?

SQL Server 2005 SP2 9.0.3054 I would like to move my DB (with Full Recovery Model) onto a /different/ server. I would like to do this w/o losing any transactions. My question relates to when it is appropriate to: 1. restore my last DB backup onto the destination server, then roll forward any logs that were backed up subsequent to that backup Versus 2. detach the database from the source server, then attach at the destination server Note that I want to move my database, so its alright if it disappears from the source server. Note also that I might want to change the

SQL Server logins Windows groups contain old hostname after EXEC sp_addserver?

SQL Server 2005 SP2 9.0.3054 Using the EXEC sp_dropserver '<old>' GO and EXEC sp_addserver '<new>', 'local' GO commands, I have successfully changed the host name of a SQL Server box. However, I notice that afterwards, under SQL Server logins, I have 3 Windows groups that still contain the OLD host name. <OLDHOSTNAME>\SQLServer2005MSFTEUser$<OLDHOSTNAME>$MSSQLSERVER <OLDHOSTNAME>\SQLServer2005MSSQLUser$<OLDHOSTNAME>$MSSQLSERVER <OLDHOSTNAME>\SQLServer2005SQLAgentUser$<OLDHOSTNAME>$MSSQLSERVER Is it safe, using Mgmt Studio, to simply rename <OLDHOSTNAME> to <N

ODBC Connection Wizard: Can't see SQL Server

Hello I wonder whether you may have some hints and pointers. I'm trying to create an ODBC User/System DSN but can't see the SQL server in the ODBC New Connection Wizard drop-down. The client machine is in a different domain than the server. I can ping the server and resolve by name but typing Servername / IP in the dropdown combo doesn't work. Further: The client machine is running an application that connects to the very same SQL server using SQL Authentication just fine which puzzles me a bit. SQL Server browser is running on the server. I'm grateful for any ideas you may have.

Web service getting "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"

I'm running a website with NetworkService credentials and I'm able to connect fine on one DB, but not the other. Both DBs are running SS 2008, and all machines concerned are on the same domain. I've added machine credentials on both DBs as needed but i'm getting the above error somehow for one of the DBs. I'm guessing that the NetworkService machine level authentication is somehow failing and thereby being reduced to anonymous, but I'm not sure - never seen this before. web.config connection strings are as follows: <setting name="SqlConnectionString" serializeAs="String"> <va

Request for help with odbc driver for Python / SQL Server 2008

Hi, I am trying to port a set of Python programs originally working with PostgreSQL, to use SQL Server 2008 with Windows XP... and it is harder than expected. I tried pyodbc and ceODBC. Already read a number of documents and FAQ's. Yes I configured the Server security to allow both Windows and SQL Server logins. Is there any other admin task needed to configure the odbc interface (I assume it odbc interface ships with the SQL Server product, right?). I checked the web site www.connectionstrings.com. http://www.connectionstrings.com/sql-server-2008#p3 There are a

Why this code does not work?

Hi all, Three related questions. Q1) I tried the following code and it works with set @c = CHAR(@x + ASCII('a')) + '-' + @c but it does not work with set @c = @c + '-' + CHAR(@x + ASCII('a')) Why? /*------------------------------------------------------------------*/ declare @x int; declare @c char(100); set @c = '' set @x = -1; while @x <25 begin SET @x = @x + 1 set @c = CHAR(@x + ASCII('a')) + '-' + @c end print @c /*------------------------------------------------------------------*/ When I use set @c = CHAR(@x + ASCII('a')) + '-' + @c

DTS or Stored Procedure?

Somewhat noobish here with SQL. Have done some packages with DTS and MSDE. Looking for some guidance on the following project: Need to develop a weekly process to update a specific column in a specific table in a SQL 2008 Express database. The column contains full Employee Names. Destination field is called EmpNamePL and is PrimaryKey and it does not accept nulls or duplicates. Source: XLS or MDB Destination Database Name: Personnel Table Name: PL5 Column Name: Item (PK, varchar, no nulls) I'm thinking DTS or Stored Procedure: DTS: 1. Despite finding out that you cannot

Return valuse based on multiple "if exists' conditions (Advanced)

Hi All, Here is a more challenging question derived from my last one in this thread: http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/6d105333a6be4865?hl=en# Here is the table: state source price NY A 1 NY B 2 NY C 3 CA B 4 CA C 5 TX C 6 How can I show by state the records that satisfied the following condition: if A exists then show only the record where source = A, if A not exists then see if B exists, If B exists then show only the record where source = B, if B not exists then see if C exists, If C exists then show only th

Installation Problem SQL Server 2005 + Windows 7

I've installed SQL Server 2005 on a dozen machines before but now I'm stumped trying to install on Windows 7. I have installed the app, then installed SP3 and keep getting the same problem: there are no SQL Server services running. Using the Surface area Configuration tool I cannot add any privileges because there are none listed in the tool. I am guessing this is a rights issue but have looked in vein for a solution. Any help is appreciated. lq

Backups without data?

Our organization made a preliminary decision to store data for all new projects in a single database because there is some commonality between projects and some tables can be shared and relationships can be maintained within a single database and PK/FK relationships cannot span databases. For readability and administrative sake, we create a schema per project and the common 'metadata' tables are in their own schema. The problem with this is that the database will grow to hundreds of Gigabytes or perhaps Terabytes eventually. Since each project will have their own backup requ

Using @variable in WHERE clause when querying a view is horrible. Inline function is fine. Why?

I much prefer examples and apologize that this question doesn't have one. I unfortunately can't post CREATE TABLE statements for this problem becuase the issue doesn't show up until you get lots of rows in the tables, and the tables themselves are quite convoluted in structure (commercial system, I can't do anything about that). My query joins six tables, the largest of which (call it Driver_Table) is about 5.4 million rows. This is the "driving" table, because the other tables are OUTER joined to the driver, by which I mean that the rows in Driver_Table are preserved. Driver

Can Someone please help me with my Computer stuff? 21692

I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer Aspire AM5100-U5300A. I would like to speed this computer up, I would like a very good grasphics card without spending a fortune. Once I find out what I need I willo just go to ebay but I don't know what kind of meory, cards and such are compaitble with my machine. Help please. Virgina ghtpl@yahoo.com http://ipods-imacs.com )m<S.oWJ!GOX$dVMFMNQG,&)x

sample code for code for "sql server development with access 2000" by Wrox

Does anyone happen to have sample code for code for "sql server development with access 2000" by Wrox? I am trying to get the sample code on their site, but the book selection does not go back that far. Please help! SQL Learner

Concatenate Mutiple Rows Data to Single RowColumn comma separated Data

Hi friends I m using SQL 2005 I want to concatenate multiple rows into single row with comma separated. I tried using for XML and all but what I m looking for I m not getting that My Table structure:- Table A SOANo | TaxOrderDisplay | TaxDescription| 2009001 | 1 | Excise 2009001 | 2 | Edu Cess on Exc 2009001 | 3 | S.HS.EduCess-Ex 2009002 | 1 | Excise 2009002 | 2 | Edu Cess on Exc 2009002 | 3 | S.HS.EduCess-Ex 2009002 | 4 |

Replication & DDL Triggers - any way to do it?

I have been working on implementing DDL Triggers, to monitor changes in our environment. However, it doesn't seem to behave with Replication - at the very least, it chokes when new tables are added. Does anyone have any suggestions or workarounds? The only fix I've found is to disable/delete the trigger, let it apply, then enable/create the trigger. Not an ideal solution. Error messages: Target string size is too small to represent the XML instance (Source: MSSQLServer, Error number: 6354) Get help: http://help/6354 Target string size is too small to represent the XML instance