New to SQL - Please help

Welcome to SQL
Try doing the following at a time when the database has
few or no users.
Right Click on the Database and select Properties
Select Options Tab
Under Recovery - Model if its not set to simple change it
to simple.
Press OK
Right Click the database and select All Tasks -> Shrink
Database
Select the check box 'Move Pages to beginning...'
Press ok
Go make yourself a drink whilst your waiting ;)
And after if finishes change your 'Recovery - Model' back
to what it was prior to your change.
Peter

>--Original Message--
>Please excues my ignorance, but I am in no way a SQL guy;
so here goes:
>I have an accounting package that uses SQL 2000. SQL is
creating a backup
>file that is getting HUGE (about 2 GB)
>The actual data is around a few hundred MB.
>Is there a way to reduce the size of the backup file by:
>Compacting?
>Performaing a backup (that SQL knows about)?
>Is there a way to move that file?
>Can any of this be done on-line?
>Thanks for any help.
>Regards;
>PB
>
>.
>
Please forgive my ignorance, but:
Where is the database? It appears that the app that uses SQL is pointing to
a file share on another server. The backup file (BAK) is local, and it is
killing me. As I said, it is 2 GB and growing.
If it is the BAK file that is huge; will that fix my problem? The database
itself is only 132 MB.
TIA;
PB
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...[vbcol=seagreen]
> Welcome to SQL
> Try doing the following at a time when the database has
> few or no users.
> Right Click on the Database and select Properties
> Select Options Tab
> Under Recovery - Model if its not set to simple change it
> to simple.
> Press OK
> Right Click the database and select All Tasks -> Shrink
> Database
> Select the check box 'Move Pages to beginning...'
> Press ok
> Go make yourself a drink whilst your waiting ;)
> And after if finishes change your 'Recovery - Model' back
> to what it was prior to your change.
> Peter
>
>
> so here goes:
> creating a backup
|||When releasing space SQL Server doesn't actually free
disk space, its thinking is if its needed it before, it
needs it now, so if you say delete half your database you
will see the same disk space.
The problem though is probably to do with your log file
that will grows a heck of a lot.
To work out where your files are click onto your database
then at the top menu selecy view 'Something (I'm away
from SQL) pad'
It will give you the location and size of your data files
and log files.
These files can be anywhere on your Network.
As for your backup files (.BAK) its considered good
practice to store them on a different server than the one
that SQL is on.
And yes, performing the steps will solve the problem as
the steps will release the unused disk space and so the
backups will not be fooled into thinking there is more to
the files than there actually is.
Anyway its 22:15 here and I am off to do something else.
Good luck
Peter
Peter

>--Original Message--
>Please forgive my ignorance, but:
>Where is the database? It appears that the app that uses
SQL is pointing to
>a file share on another server. The backup file (BAK) is
local, and it is
>killing me. As I said, it is 2 GB and growing.
>If it is the BAK file that is huge; will that fix my
problem? The database
>itself is only 132 MB.
>TIA;
>PB
>
>"Peter The Spate" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...
it[vbcol=seagreen]
back[vbcol=seagreen]
guy;[vbcol=seagreen]
is[vbcol=seagreen]
by:
>
>.
>

New to MS SQL 2000

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination.
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:58C5D3AA-D2FC-419E-B560-DD5703546B5A@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
if
> I expand the database server I could select all task, backup database and
> select the destination.
If you've got the Veritas netbackup SQL Server agent, you can configure
netback to capture all relevant databases. If not, you can use the SQL
Server backup database task wizard to backup your databases, then use
netbackup to backup these files.
Steve

New Subscriptions never show

If I select "New Subscription" and I select a delivery method and time and
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?
BartNot sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bart" <test@.test.com> wrote in message
news:#Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||I got that fixed, but now I can't deliver the subscription.
The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.
It looks like an AuthZ problem, but I'm not sure how to resolve it.
Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
"Bart" <test@.test.com> wrote in message
news:%23Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:
changed by
<name_of_the_user> [unknown]
For me the "unknown" is the key.
Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.
r|||It seems that after installing SP1, the problem was resolved. I will
continue testing.
Bart
"Roland" <nomail@.spamprotect.com> wrote in message
news:uPS$4MJWEHA.3236@.tk2msftngp13.phx.gbl...
> Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
> since weeks. Could you please doublecheck on the properties page of your
> reports with details on: Is there some entry like this:
> changed by
> <name_of_the_user> [unknown]
> For me the "unknown" is the key.
> Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
> with Brian concerning this issue.
> r
>|||Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.|||Bart wrote:
> If I select "New Subscription" and I select a delivery method and
> time and select OK, the screen flashes, but no subscriptions are
> listed. I have the user as a Browser and Publisher, but I don't get
> an error. Is there something else I have to check or setup?
> Bart
Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:
* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly
-- BUT --
the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"
-- BUT -- (Again)
if I login as admin I can view and edit the subscription.
I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?
roland

New MS SQL Server

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination. Which is the proper way to backup these databases.
You could get a Veritas agent that will be able to back up the database real
time. The problem with using the plain vanilla Backup EXEC is that it can't
back up a file that is in use. Alternatively, you can use a scheduled task
within Enterprise Manager to back up the database before you backup to tape.
We have ours set up this way and it works well...
Regards,
Hank Arnold
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:12671BDC-34F2-427E-80EF-753A96DC4818@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
> if
> I expand the database server I could select all task, backup database and
> select the destination. Which is the proper way to backup these databases.

New line in query

Hi,
I was wondering if there is any way I can place a new line inside a query...
e.g.
select field1 + 'NEWLINE' + field2 from tablename
I want to place a new line between field1 and field2
Thanks in advanceselect field1 + char(13) + field2 from tablename|||Thanks for reply blindman

I have tried this already but it doesn't work :(
any other suggestions would be appreciated.

Thanks|||It works in query analyzer. What are you looking at the results in?

select 'a' + char(13) + 'b'|||I am using MSSQL 2005 Server Management Studio which replaces both the SQL Server 2000 Enterprise Manager and the Query Analyzer.

Thanks|||Odd. It still works for me.

select 'a' + char(13) + 'b'

--
a
b

(1 row(s) affected)|||Actually It works on the text mode result but not Grid mode ...still it doesn't save a and b on different lines in the database itself not sure why

Once I fetch the record it displays it on a single line...

On my other fields where I am saving text from my .net application textboxes it creates double boxes for a newline... I was wondering how would I create thoes double boxes :)|||Ahh, the grid is saving the carriage return, but it displays as a blank in grid mode.

-- Using Northwind

DECLARE @.MyText CHAR(26)
DECLARE @.MyText2 CHAR(26)
SET @.MyText = 'a' + char(13) + 'b'
PRINT @.MyText

SELECT ShipCity
FROM Orders
WHERE OrderID = 10248

UPDATE Orders
SET ShipCity = @.MyText
WHERE OrderID = 10248

SET @.MyText2 = (SELECT ShipCity
FROM Orders
WHERE OrderID = 10248)

PRINT @.MyText2

SELECT ShipCity
FROM Orders
WHERE OrderID = 10248

UPDATE Orders
SET ShipCity = 'Reims'
WHERE OrderID = 10248

Run this in text mode and you will see that the newline is saved.
Run this in grid mode and you will see that the newline is converted.

I hope this helps,|||Still it will show a one straight line when fetching that data ....what I am thinking now is create a tiny function in .net and add new lines there it did worked for my other data before....

"thank you all for the help guys this forum ROCKS :)"|||Why are you concerned with how it looks in Management Studio? Neither Management Studio or Query Analyzer is meant to be used as a user interface or reporting tool.