Back Up Problems Continued - Reply To Alex And Ray
Mar 21, 2002
Thanks for the replies but...
I doesn't work!!!!
Anymore ideas?
---------------------------------------------
Hi,
I have a rather odd problem that hopefully you'll be able to shed some light on (nobody else has come up with anythig sensible).
We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.
I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.
I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.
On our test instance of SQL Sever we can backup to other servers but not the new live version!
Any thoughts on what might cause this to happen?
Helen
View 3 Replies
ADVERTISEMENT
Feb 8, 2002
Hi MMWOPS ..
Extremely thanks for the reply . I am using transactional replication for the database . I will try with snapshot replication as you suggested .
You mentioned that it will work with Transactional replication only if the application uses the option ' with log ' for those transactions .
Can you let me know where can i set this option for transaction replication ?
I am sorry but i am not well versed with database replication procedures and management .
Thank you once again .
Yatin.
View 1 Replies
View Related
Nov 23, 2005
I have a .NET application that needs to work with about 5,000,000 XML files5Kb each. Mostly the application randomly reads these files and itadds/modifies about 100 files every 10 minutes. What would be the best datastorage in tirms of performance (connection, search and retrieval times) abig SQL table that uses NTEXT to store XML or regular NTFS file system (500folders with 10,000 files each)? How big the difference will be?--Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forum...eneral/200511/1
View 3 Replies
View Related
Jan 17, 2008
Please reference http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2699377&SiteID=1 The results sets are below:
RESULT SET #1
Date_IN
Account_Number
Patient_Name
Care_Unit_Key
Care_Unit
Care_Unit_Desc
Date_Time_In
Time_IN
Duration_Hours
Duration_Minutes
20080102
777777
DOE, JANE
1488748
3
SURGERY
NULL
NULL
NULL
NULL
20080102
777777
DOE, JANE
1509344
S4C
11TH ST 4 CENTER
1/2/08 5:38
5:38
3
57
20080102
777777
DOE, JANE
1509426
SREC
11TH ST RECOVERY
1/2/08 9:35
9:35
1
22
RESULT SET #2
Date_IN
Account_Number
Patient_Name
Care_Unit_Key
Care_Unit
Care_Unit_Desc
Date_Time_In
Time_IN
Duration_Hours
Duration_Minutes
20080102
777777
DOE, JANE
1488748
3
SURGERY
NULL
NULL
NULL
NULL
20080102
777777
DOE, JANE
1509344
S4C
11TH ST 4 CENTER
1/2/08 5:38
5:38
0
3
20080102
777777
DOE, JANE
1509426
SREC
11TH ST RECOVERY
1/2/08 9:35
9:35
0
27
20080102
888888
DOE, JIM
1496201
3
SURGERY
NULL
NULL
NULL
NULL
20080102
888888
DOE, JIM
1509361
S4C
11TH ST 4 CENTER
1/2/08 6:45
6:45
0
6
View 4 Replies
View Related
Sep 4, 2007
Thanks for previous help, I am however continuing to have problems as I attempt to search a table for a value keyed by the user (e.g. AccessionPresent= 3624-01). The input value that is being searched against is stored in the table as an INT. I have cast the INT to a VARCHAR on the line described as "MSQL=....
Can anyone ascertain why I get the error, described below? The query works in the Query Analyzer?? What am I doing incorrectly... Any assistance will be appreciated...
Thanks !
Dim DS As DataSetDim MyCommand As SqlDataAdapterDim AccessionPresent, strsearchedfor, strsearchresult As StringDim RcdCount As IntegerDim ResultCount As IntegerAccessionPresent = Accession.Textstrsearchedfor = "The Keyed Accession Number "strsearchresult = " Does Not Exist. Please Verify Your Entry. "ErrorLabel.Text = String.Format("{1}<b><font size=ex-small color=003399>{0}</b></font>{2}", AccessionPresent, strsearchedfor, strsearchresult)Dim MySQL As String
MySQL = "SELECT * FROM ClinicalSpecimen WHERE CAST(SpecimenID AS varchar(50))='" & AccessionPresent & "'"Dim objConnValidate As SqlConnectionDim mySettingsValidate As New NameValueCollectionmySettingsValidate = AppSettingsDim strConn As StringstrConn = mySettingsValidate("connString")objConnValidate = New SqlConnection(strConn)
MyCommand = New SqlDataAdapter(MySQL, strConn)DS = New DataSetMyCommand.Fill(DS, "SpecimenID")RcdCount = DS.Tables("SpecimenID").Rows.Count.ToString()If DS.Tables(0).Rows.Count > 0 ThenResponse.Redirect("Accession_Result.aspx?AccessionResult=" & AccessionPresent)
ElseIf DS.Tables(0).Rows.Count = 0 ThenResponse.Redirect(http://www.aol.com)
IS CAUSING THE FOLLOWING ERROR:
Server Error in '/ClinicTest2' Application.
Syntax error converting the nvarchar value '3624-01' to a column of data type int.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Syntax error converting the nvarchar value '3624-01' to a column of data type int.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Syntax error converting the nvarchar value '3624-01' to a column of data type int.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlDataReader.HasMoreRows() +194
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +262
System.Data.SqlClient.SqlDataReader.Read() +29
System.Data.ProviderBase.DataReaderContainer.Read() +26
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +240
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +257
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +383
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +251
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2859
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +153
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99
System.Web.UI.WebControls.GridView.DataBind() +23
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +92
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +100
System.Web.UI.Control.EnsureChildControls() +134
System.Web.UI.Control.PreRenderRecursiveInternal() +109
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4436
View 6 Replies
View Related
Oct 25, 2006
When I add a referrence to
Imports Microsoft.AnalysisServices.AdomdClient
Imports Microsoft.AnalysisServices.AdomdClient.AdomdConnection,
Because I need the for an adomd connection
I receive the following problem
'MiningStructre' is ambiguous, imported from the namespaces or types
'Microsoft.AnalysisServices.AdomdClient', 'Microsoft.AnalysisServices'
with any Mining structure declaration like Dim m_ms As MiningStructure
View 1 Replies
View Related
May 7, 2007
I continue to have issues with SP-2 for SQL 2005 suite. It has now gotten so bad, I have multiple installations, including the TOOLS ONLY on my laptop failing, that I am going to stop ALL future installations of SP-2. The COM+ failures have not been resolved that I can determine. I have tried uninstalling, I have tried SP-1 before SP-2, every combination one can find. HELP.
Time: 05/07/2007 13:24:05.631
KB Number: KB921896
Machine: GA029-MDGRAVES
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
MSXML 6.0 Parser ENU 6.00.3883.8 x86
Backward Compatibility ENU 8.05.1054 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3883
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29549
View 3 Replies
View Related
Mar 13, 2007
I have one report (R1) which includes a list of ports ("=Fields!Port_Name.Value")
Another report (R2) supplies details for individual reports and has a parameter named PortDWIDPortName which gets port names from the same dimension as those in R1. So in the field properties of the Port field in R1, I selected Navigation > Jump To Report and entered PortDWIDPortName = Fields!Port_Name.Value (also tried changing .Value to .Key or .UniqueName) but although it jumps to report R2 it does not enter a value for the parameter (ie leaves it blank or displays <Select Value> depending on whether multivalue or not).
Does anyone know the right syntax to pass the parameter ? If not, does anyone know to view what Jump To Parameter is returning so I can figure how to doctor it!
Thanks
View 1 Replies
View Related
Jan 18, 2006
We currently have access to another department's SQL server. However they are taking that server offline within a few months, and we will need to migrate our data and DTS packages to a new solution before then. We have about 30 databases and 20 somewhat simple DTS packages, but only a few users need access. Funding is very tight.
SQL 2005's support of DTS is somewhat of a mystery to me. Docs state with 2000 Enterprise client tools installed + Express edition, that I can run DTS packages on Express edition. But the docs do not state the procedure for doing so, and I cannot register the Express server in the Enterprise manager(states must be using 2005 version of Enterprise manager). It seems I can Design a DTS package that resides on the 2000 server and specify a connection to the Express server, but the DTS package would not run, stating always that the table was in use, and I haven't explored it any further. May have just been a quirk.
I'm trying to conquer this in two pieces:
Cheapest solution for graphical design of DTS packages, or some techniology similar(I think I understand that this is called SSIS in 2005?). This would be needed by 1-4 users.
SQL 2005 Developer Edition for each user, only about $50 per user.
MSDE for each user, but can this house DTS packages and be connected to by enterprise manager?
Cheapest solution for data access and ability to run DTS packages by 2-10 users.
If SQL Express Edition is used to house data, can the DTS packages be distributed in some way that allows the users to run them? I.E. exported as VB code or some sort of file that can be loaded by an Access 2002 or VB.NET frontend.
Can all users have Developer Edition or Desktop edition and run the DTS package from it, but have the DTS package connect to the Express Edition server where the data is housed? Or would this be a violation of what the Developer Edition is intended to be used for?
Any other suggested scenarios are welcome.
Are we allowed to continue using the 2000 Enterprise manager after we no longer have access to a licensed SQL 2000 Enterprise server?
The feature comparison for the different 2005 editions doesn't mention DTS, but I know it works for some editions if the add on components are installed. I'm just not sure which versions support this.
View 1 Replies
View Related
May 30, 2008
in sql server 2000 ,in query analyzer :for example i have a emp table ,when i execute a query ,i have to get the emp table column names with its data types...for example :empno ---intempname -- varchar like this...what is the query to get the output like this
View 3 Replies
View Related
Aug 28, 1998
How am I able to read replies to any message? I used to be able to see the replies staggered under the original message...but not any more.
Help!
Toni
View 1 Replies
View Related
Dec 5, 2007
Yes, I need to join the two tables with a similar column and then restrict with the where function, correct?
Thanks!
Scott
View 2 Replies
View Related
Aug 17, 2007
I am not using the SA account when I log in using windows authentication it seems to pick up my domain and active directory ID which is "usapp1dxd" it appears greyed out as well as the password on the login screen so you can't change it.
If you go into the management studio and right click on the server name in the left hand pane go to properties security the radio button for sql server and Windows authentication mode is selected.
View 1 Replies
View Related
Apr 24, 2007
Hello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick
View 5 Replies
View Related
May 14, 2015
New to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.
When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?
View 2 Replies
View Related
Jun 9, 2015
I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.
View 4 Replies
View Related
Nov 12, 1998
For the begining thank for your reply. I started with a new job and I was hopeless when all normaly claimed things can't be done. I asked a lot of peoples who works on MSSQL(including SWYNK) for my problems(I know that I'm beginer on MSSQL) but they didn't knows any solution. And afterall I wrote that. For your ilustration, we develope information system for Invest company. Back is on MSSQL and client is in ASP.
>So... if you need a database you need to look at what needs to be done and >pick your DBMS that meets your requirements.
--I didn't resolve on which DB we will develope:((
--No named cursors
I mean that in general is using curosr names bootless. And you must deal with names...
In interbase:
DECLARE var1,2 INTEGER;
FOR SELECT column,column2 FROM TABLE WHERE ...
INTO :var1,:var2
BEGIN
some code in loop;
END
In mssql:
DECLARE ..
DECLARE crs CURSOR
FOR SELECT ...
OPEN crs
FETCH NEXT FROM crs INTO @var1,@var2
WHILE (@@FETCH_RESULT = 0)
BEGIN
some code in loop
FETCH NEXT FROM crs INTO @var1,@var2
END
CLOSE crs
DEALLOCATE crs
-I thing that in mssql it isn't elegant.
-problem with recursive procs
-you must deal with names
-If you can you may use named cursors in Interbase in fact
>-it don't know create resultset's from
>> stored procs asynchronously when in sp is something else then only one
>> select(problem if I want check access rigths to sp. for exapmle "...AS
>> CheckPrivilege( ... ) SELECT.." This is confusing if user runs large
>> query & he must wait until it creates the whole recordset...Armageddon goes
>> first... Here is a solution, but it isn't very elegant and in some
>> cases don't exists good solution
>
>I'm not sure if configuring SQL Server's "cursor threshold" parameter would solve this. "When
>set to -1, all keysets are generated synchronously. If the cursor threshold is set to 0, all
>keysets will be generated asynchronously."
-"cursor threshold" resolves it only in single select's and procedures with only one select's
-It's unacceptable when your your user runs large queries
>>-max of nested procs is 16.
>That is the limit in V6.5. In V7.0 the limit is raised to 32.
-cool:)
>Union operator can't be used in a Create View statement in V6.5 according to the documentation.
>Does Oracle support this? It appears that V7.0 of MSSQL will support UNION in a view.
-cool:))
>-It don't have good exception
> handling.(something like EXCEPTION, WHEN... (oracle, Intebase))
>
>There are whole sections on error handling in SQL Books OnLine depending on >how you are
>accessing SQL Server. Maybe it's as good as Oracle/Interbase... maybe not. I >don't seem to have a problem with it.
-Books are very feeble:(
-but I thing that it can't work with EXCEPTION blocs. Good Exception handling is important tool for fast developing of robust apps
-I used example(s) from INTERBASE because I worked more on it, but in Oracle it's alike.
I'm glad for good discussion
Beargie
View 3 Replies
View Related
Nov 14, 2005
For a query like below ...
How do i have to select only the latest revisions,
if i need to filter last current revisions of each document ...
where the revision could be either alphabetical or even numerical ...
Presently I get all revisions with the below query ...
Note: csd_revi is the field of CSD table for revisions.
---
select distinct
csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi as "Document Reference No.",
csd1.csd_labl + ' ' as "Description"
from
E0437csd csd1,
E0437tra tra1,
E0437csd csd2,
E0437trd trd1,
E0437apr apr1,
E0437apc apc1,
E0437tra tra2,
E0437csd csd3,
E0437trd trd2
where
csd1.csd_orig = 'BS' and
csd1.csd_subj like '%WN1%' and
csd1.csd_type = 'D' and
tra1.tra_drgn = csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi and
tra1.tra_part = 'PARSO' and
tra1.tra_type = 'A' and
csd2.csd_orig + csd2.csd_subj + csd2.csd_type + csd2.csd_numb + csd2.csd_revi = tra1.tra_trno and
trd1.trd_trno = tra1.tra_trno and
trd1.trd_cc = '0' and
trd1.trd_part = 'PARSO' and
apr1.apr_docu = csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi and
(apr1.apr_stat = apc1.apc_code or apr1.apr_stat = '') and
tra2.tra_drgn = csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi and
tra2.tra_part = csd1.csd_ownr and
csd3.csd_orig + csd3.csd_subj + csd3.csd_type + csd3.csd_numb + csd3.csd_revi = tra2.tra_trno and
trd2.trd_trno = tra2.tra_trno
order by
csd1.csd_orig + csd1.csd_subj + csd1.csd_type + csd1.csd_numb + csd1.csd_revi
---
Life is beautiful ... When you smile ...
View 3 Replies
View Related
Aug 17, 2000
I've gotten everything to work -- almost!
Here's the scoop... I'm using SQL Server 7.0 and ColdFusion (you don't need to know anything about ColdFusion). I'm trying to get SQL Server to publish/share/etc. a database with the network so ColdFusion (our website management/creation program) can access it and use it in a webpage. Well, so far, ColdFusion can detect and access the database (called "iami"), but it cannot find any tables in the database (particularily one called "phase1"). Can anyone help me -- the sooner the better -- ???
If you reply before 4pm today and offer truly helpful advice/input, I'll send you a reward/incentive from me personally (just give me your mailing address) just for helping out!!! :-)
View 1 Replies
View Related
Oct 15, 2007
I can believe it, 40 people read my sql query problem and ONLY ONE reply to my request for help.
Thanks!!!! It's great to know that we help each other in this community.
View 1 Replies
View Related
Jul 2, 2002
Can anyone help me with handy scripts/stored procedures to capture blocking info on the server? We have SQL 7.0 w/sp3.
Ray replied earlier saying that I can use so_who2!!, I think everyone knows that,please reply with some valuable info!!Please..
Thanks.
Sonali.
View 4 Replies
View Related
Aug 28, 2000
I think jthis is a bug. I have a table created and populated on its own filegroup. I backup the db(all filegroups) and the trans log then I drop the one table. When I try to restore from my backups, it insists that I back up the trans log again. I do, then do the restore of both the filegroup and the trans log. The restore finishes, but my table is still not there and I can never get it back.
Any one with comments please help
Brad kreuzburg
View 1 Replies
View Related
Nov 23, 1999
What should I have done? Is there anything that can be done other than restoring from backup?
How does one know if the database is really recovering or is EM just joken? I can wait 2 hours
before starting the restore
I was BCPing 12 million rows into a staging table. II used the '-b' option every 20K which I thought
would do a commit and clear the log in batches. After the process EM appeared to show the transaction log
as empty. Upon inspecting the Bcp output file I discovered the message that the BCP did not complete
because syslogs was full. I could not do a truncate transaction log or a dump database. I tried to
do a truncate transaction with no_log and it appeared to just hang. I stopped the SQL Server thinking
I could dump the transaction log, but could not start the Sql Server again. I then stopped the NT Server
because 'if all else fails'. The SQL Server started but the user database if marked as recovering.
View 5 Replies
View Related
Jun 18, 1999
I cannot reply to any messages of the board? Is anyone else having this problem?
I see from the board that there haven't been any replies for a few days...
Jarlath O'Grady
mailto:jogrady@swynk.com
http://www.swynk.com/friends/ogrady
View 2 Replies
View Related
Jun 23, 2008
Hi everyone
I want to know if it's possible to do a for/while-loop so i can use INSERT
Look:
I've this int [] test = new test[140];
But i need to insert for every value (140) a number
so normally it would be :
INSERT ... (case1, case2, case3 ...) value (test[1],test[2],test[3] ...)
But isn't there a way to it with a loop?
SOmething Like this ?
for( int i = 0 , i< 140, i++) {
INSERT case[i] value test[i]
}
Thanks in advance
Jonas
View 8 Replies
View Related
Jul 23, 2005
Can it be possible to create trigger/procedurein following case2 server server A and server BA has db1db1 has tblAB has db2db2 has tblBcan it be possible to create trigger on server A.db1.tblA asinsert/update that trigger add/update record in server B.db2.tb2thnks-----------Hitendra
View 3 Replies
View Related
Jun 10, 2005
How do I indicate a post answered my question?
While reading a reply to your question you will notice a button with this Icon: Clicking on it will mark the post as the answer to your question
Thanks!
Clifford Dibble
View 9 Replies
View Related
Jan 11, 2008
I have set up a data driven subscription for a report, and against "Reply-To" I have selected "Specify a Static Value".
I have then I have entered a valid email address.
When the report is received however, and the recipient clicks reply, the reply address is filled in as the Email Address from which the report was sent.
Is this a bug with the "Reply-To" functionality? Or do I have to do this a different way?
Thanks :-)
Kate
View 2 Replies
View Related
Sep 8, 2006
Is there a way to do this? When I have a further question in the same thread, my only option is to reply to the one who answered the last question. How do I put forward that question to everyone? Do I have to start a new thread with the same subject?
thx
Kat
View 4 Replies
View Related
Jul 20, 2005
Hello,I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql server database and while I have found multiple articles online about the topics I need to accomplish, I cannot find any actual examples that explain where I input the coded used to accomplish the above-mentioned steps. I do understand the theory behind the steps I just do not know how to accomplish them!If you know of a well-documented tutorial, please point me in the right direction.Regards.
View 2 Replies
View Related
Aug 11, 2000
I'm trying to import data into an SQL Server (7.0) and I'm wondering which Source (Microsoft Data Link, Microsoft ODBC Driver for Oracle, Microsoft ODBC Driver for SQL Server, etc.) -- I THINK we would use the SQL Server driver but I'm not sure... to use AND WHERE TO GO FROM THERE? So far, I get seem to get things to work in my favor. I appreciate any help :) The data I'm trying to import is from Microsoft Excell. If there is anything else you need to know, please email me at iami@iami.org Please provide email/forum-based technical support.
View 4 Replies
View Related
Jun 11, 2007
Hi
My doubts on revoked users in MSSQL...please reply
I have following doubts:
1. Is there any stored procedure provided by MS SQL server for checking whether the user is revoked or not?
2. What is the query for checking whether the particular user is revoked or not in MS SQL?
3. Do all revoked users get stored in separate database in MSSQL ?
Please reply.
View 2 Replies
View Related
