Is there a way to have a common set of stored procs and views which can run againsts a specified database dynamically. We want to keep a common set of SP and Views in one master DB and have ma...
I am running Backup Exec v10.1 rev5629, trying to backup databases on an MS SQL Server 2005 build 9.0.2047 running on MS Windows Server 2003 v5.2.3790. It is our first SQL 2005 native mode dat...
I have an app that upto 40 users are on in VB with an SQL backend. The current solution does not allow other users to see changes to the dataset that other users have done. The dataset is larg...
can anyone tell me why i keep getting this problem
WEB_DOCS\ERETAILERS.COM\APP_DATA\ERETAILER.MDF" because the database is read-only
i have checked all the settings in SQL server, and m...
I have a table that contains multiple fields that contain a comma delimited list of IDs like this
column vehicles / data VID-1,VID-2,VID-33 etc.
I want to parse this data out into a cro...
I have a SSIS package on a remote SQL2005 server. I wish to execute this package from local PCs by a variety of users.
Can I call a stored procedure to do this, if so how ?
Are there bet...
I changed my SQL server installation to a SQL Cluster, now my odbc connection for a php app does not work. I'm wondering if I missed something when I setup the cluster.
My php script returns ...
I use the attached trigger to form an audit trail of changes made to records in a project database. How do I modify the routine to insert only changed values into the audit database and null ...
My user has just converted from SQL Server 2000 to SQL Server 2005. They previously used schemas in their code (i.e. pm.TerminalIdentity). (See attached coding example). The user has now confi...
I am having problems replcating SQLServer across two domains, my office, 'MyOffice' and my client 'MyClient'. The domain are non-trusted and they will not be able to link to each other (settin...
How to select a column with order by for the same column,
For eg :- If a table Employee having 4 columns Empno, Empname, Sal, DOJ and i want to get the top 50 employees based on the latest ...
I'm fairly new to SQL and trying to configure email notifications on completed backup jobs.
So far I created a back up database task and configured database email. I sent a test message an...
Is it better to Insert/Update/Delete Or Drop Table/Create Table/Insert Or Drop Table/Select Into?
Hi,
I have this code which has to be written in SQL Server stored Proc . Basically stored proc accepts
StartDate and EndDate and Calcuates the days and loops thru the end of the date and r...
We have been remediating our Servers using Retina and GoldDisk as our survey tools. We had to update our SQL 2005 SA password and got this error. Also our systems were pushed out Symantec 10...
Hi....
I am having problems connecting with Sql Server 2005 Express in Sql authentication mode. The server is installed on my local machine and I resorted to uninstalling then re-installing S...
Currently all my databases are in Access and the client wants to upgrade to SQL server(tables are getting too big in Access).
I have 5 separate "Land Development" databases, that have to st...
Hello All
I have a view in SQL that contains a list of dates. What i want to do is create 2 more views, one showing items 3 months and over the other showing 3 months and under, how can i do ...
I am trying to use a Common Table Expression but I am getting the error 'Incorrect syntax near the keyword 'WITH'.' I am not sure what the problem is. I tried the adventureworks example and ...
Does MS SQL Server support Java stored procedures? Please, explain?
I am upsizing from Access 2007 to SQL Server Express 2005 on Vista. I chose the default settings for the Upsizing Wizard:
- Create New Database
- (local) SQL Server
- Using Trusted Locatio...
In trying to understand how to get and use a returning 'id' in a newly inserted row, I came across the code below by one 'Pootle Flump' in answer to a question posed at http://www.dbforums.com...
I am looking for C# code to copy an existing Sql Server 2005 database to a new named database. I found this site with sample code, but I am not following which namespace contains the Server an...
We have an development team that builds applications in VB.NET 2008 and VBScript. All of these applications use SQL Server 2005 as the database. Our company is very strict about security and t...
I have setup two alerts on sql 2005
Unable to read local eventlog (reason: The parameter is incorrect) under SQL Agents for alerting for backup failures etc and integrity on all databases.
...
