Is there anyway I can backup a database to a *.bak file and verify it and have it automated to run daily? I have SQL Server Business Intelligence Development Studio but unsure on how to use, is the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2273...
I have a table DimCounty(CountyID,CountyDescr).This has 3000 distinct rows
CountyID CountyDescr
1 Abbeville
2 Acadia
3 Adair
Another Table CountyStatusFA...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2274...
Hello,
I would like to copy a series of stored procedures from one database to another - one time only.
SQL 2005 on Windows 2003 Server. Any help would be greatly appreciated.
Thank you in ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2276...
This query is meant to retrieve a count of the no. of stocks that have prices in the last 8 days.
select E.exchangename,PH.marketdate,
count(*) as PriceToday
from excha...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22769182.html
When migrating a SQL Server 2000 database to 2005 I see that there are the In-Place or Side-by-Side Upgrade options.
How do I determine which is the best option to pursue, and do you have a rec...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2277...
xp_cmdshell returns null. I have turned on the security option for xp_cmdshell, so no error messages are thrown.
if i run:
exec master..xp_cmdshell 'blabla'
All i get is a recordset with one col...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2277...
Hi there,
Basically, I have a large set of users who use my application to log in to the SQL Server 2005.
All of them use the same login id and password because i do not have rights to dynamica...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2277...
Currently, i have an active/active cluster. How can i set up a job that will alert me when one of the nodes fails over to the other node?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22785519.html
I am trying to give a user rights to create a database and then view the properties of the database after he has created it. (such as size, and location of files)
I will change the owner of the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2278...
how to apply user and password on a database when the windows authtocation is on.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2279...
