Script to find dbs with full recovery model
Wed, 1 Oct 2008 10:47:19 +0530
Hello,
In our SQL Server farm, I want to find out which databases have 'full'
recovery model and no scheduled log backup. Is there any script or easy way
to do this?
Thanks,
SQL_Help
...
|
Create tables problem
Tue, 30 Sep 2008 17:43:41 -0700 (PDT)
Hello,
I got the full script to create the ASP.NET Membership tables.
When I run the scripts on my table I get the following:
---------------------------------------
Starting execution of InstallCommon.SQL
---------------------------------------
(310 row(s) affected)
Cannot grant, deny, or revoke permis ...
|
Users created during SQL installation
Tue, 30 Sep 2008 21:08:58 -0300
By default, what users are created during the SQL Server installation?
Thanks,
Felipe
...
|
problem with Bind Variables
Tue, 30 Sep 2008 14:37:22 -0700
In the C# code below, I'm having trouble when I try to use a bind variable
for the column name in an update command. The example below works fine when
I use the first sqlstr spelling out the column name. When I try to use the
second sqlstr using @columnName I get an error saying string or binary data
would ...
|
Dump out SQL accounts and rights
Tue, 30 Sep 2008 14:31:37 -0700 (PDT)
Heya,
Anyone have a SQL script that dumps out the SQL and Windows accounts?
And the database roles and rights? Im doing up some quick docos for
auditors. SQL 2005 and Windows 2003.
Thanks
ChrisW ...
|
How to set a date conditionally in SQL
Tue, 30 Sep 2008 14:23:02 -0700
Hi I have a stored procedure that inserted data into a database and also
inserts a due date. I need the query to set the due date as follows;
If the 5th day of the month falls on a saturday I want to set the due date
to the friday prior (4th), if the 5th falls on a sunday I want to set the due
date on the f ...
|
copy db wizard error
Tue, 30 Sep 2008 15:57:38 -0400
Hello,
I tried to copy db's etc. from a SQL 2000 sp3 server to a sql 2005 sp2
server but it failed right at the end of the wizard before doing anything
with the error: "an entry with the same key already exists". I can't find
anything online about this. Any ideas what's wrong?
tia,
jj
...
|
|
|
Old sql 2000 Databases.. Last time updated? Last time accessed
Tue, 30 Sep 2008 11:39:32 -0700 (PDT)
We have a server with some 100 sql 2000 Databases.
How can I tell the last time a database was updated? accessed?
Will the mod date on the data file be a clue? how about the mod date
on the log file?
Is there anywhere I can extract access logs for the entire instance?
Thanks. ...
|
SQL 2K5 Dr Watsons
Tue, 30 Sep 2008 11:39:55 -0700
We have been experiencing some crashes on our cluster which consists of an
Active/Passive 64 bit SQL2K5 SP2 with updates that bring the version to
9.0.3282 and is connected to a SAN
The error message in part is as follows:
Non-yielding IOCP Listener with External dump process return code 0x20000001
External j ...
|
osql -d parameter
Tue, 30 Sep 2008 11:37:16 -0700 (PDT)
Does anyone know if the -d parameter is needed to define the database
in osql if this is the users default database?
I have a user (test) and his default datbaase is test.. when running
an osql script, it fails unless I provide the -d option with the test
database (i.e. -d test)
I do not recall having to do ...
|
