Hi All,
Can any tell me how to generate the Script file in SQL 2005.
If i execute that script in another server all should be created automatically including the Database with the same name.
How to do this..
Ganesh
Hi every one
I want to generate a RSS Feed from SQL Server 2005.
The scenario is that when a record is entered in the database, the database fire a trigger which generate rss feed for the new record entered in the data base
Thanx in advance
Take care
Bye
Is it possible to have a DateTime field in a row automatically generated when a row is created?
ie:
INSERT INTO [TableName] ([DateTimeStamp], [UserId], [Title], [Explanation]) VALUES (DateTime.Now(), @UserId, @Title, @Explanation)
or something like that?
Anyone know an easy way to generate the SQL Scripts to gererate the
tables/sp's/triggers/indexes/fk's, ect? I know Sql Server 2000 lets you
generate the db script, but I don't know how to do this with 2005
Using the scripting wizard in SQL Server 2005 database engine, I have been able to script all my DDL out to a flat file which is great; however, when I scripts for instance all views I would like to have the script in alphabetical order by view name, is there a value I can set to accomplish this?
Thanks
Hi there,
I have setup merge replication which successfully synchronizes with a group of desktop users using SQL Compact Edition.
However now I have setup Article Filters and when I attempt to regenerate the snapshot I get the following error:
Invalid column name 'rowguid'.
Failed to generate merge replication stored procedures for article 'AssignedCriteria'.
When I look at publication properties at the Articles page.. All my tables have the rowguid uniqueidentifier successfully added to tables and selected as a compulsory published column, apart from the table above "AssignedCriteria".. Even when I attempt to select this column in the article properties page and press ok, when I come back it is deselected again. ( The Rowguid column is however physically added to the table)
I have scripted the publication SQL and then totally reinstalled from scratch, including the database but for some reason it doesn't like this table. I remove the article filters, but still this "rowguid" is never "selected" in article properties.
We are using Uniqueidentifiers in other columns as well for historical reasons, but this doesn't appear to be a problem in other tables..
DDL For this problematic table is as follows
CREATE TABLE [dbo].[AssignedCriteria](
[AssignedCriteria] [uniqueidentifier] NOT NULL,
[CriteriaName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TargetScore] [numeric](5, 0) NULL,
[HRPlan] [uniqueidentifier] NULL,
[ActualScore] [numeric](18, 0) NULL,
[Criteria] [uniqueidentifier] NULL,
[Employee] [uniqueidentifier] NULL,
[IsActive] [bit] NULL,
[addDate] [datetime] NULL,
[totalscore] [numeric](5, 0) NULL,
[isCalc] [bit] NULL,
[Weight] [decimal](18, 2) NULL,
[ProfileDetail] [uniqueidentifier] NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [MSmerge_df_rowguid_7FF25DF903B6415FBFF24AC954BC88E4] DEFAULT (newsequentialid()),
CONSTRAINT [PK_AssignedCriteria] PRIMARY KEY CLUSTERED
(
[AssignedCriteria] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Thanks.
I have a table(say tblUserInfo) on SQL Server. What I like to do is a text file will be generated on the hard drive which SQL Server sits on when a new record is inserted into tblUserInfo. The content of the text file comes from the table. Is there any way we can go for doing that?
View 2 Replies View RelatedHi ya,
I'm generating a flat file from SSIS package and i'm having some problems.
My package contains this Data Flow which is connecting to a Database and importing the records. I did design a script component since the file I generate has some padding.
Here is the code for the component so that you really understand what i'm trying to achieve over here.
Dim toPadTo As Int32
Dim myDate As String
Dim MultVal As Int64
Dim myMonth As Int16, myMonth2 As String
myMonth = CShort(Row.TransDate.Month)
If myMonth <= 9 Then
myMonth2 = myMonth.ToString.PadLeft(2, CChar("0"))
Else
myMonth2 = myMonth.ToString
End If
myDate = CStr(Row.TransDate.Date.Day) + myMonth2 + CStr(Row.TransDate.Year)
MultVal = CInt(Row.TransAmount * 100)
Dim myChkLength As Int16 = CShort(MultVal.ToString.Length)
Dim myCombine As String = CStr(MultVal) & CStr(myDate)
Dim myCombine2 As String = CStr(MultVal) & CStr(myDate)
Select Case myChkLength
Case 4
toPadTo = 30 - (myCombine.ToString.Length)
Case 5
toPadTo = 30 - (myCombine.ToString.Length - 1)
Case 6
toPadTo = 30 - (myCombine.ToString.Length - 2)
Case 7
toPadTo = 30 - (myCombine.ToString.Length - 3)
End Select
' + myDate.ToString.Length - 1))
Row.myConvert = myCombine2.PadLeft(toPadTo, CChar("0"))
Dim MyNewRow As String = myCombine2.PadLeft(toPadTo, CChar("0"))
Dim ChkSign As Int16
ChkSign = CShort(Math.Sign(CDec(MyNewRow)))
If ChkSign = 1 Then
Row.myConvert = MyNewRow.PadLeft(2, CChar("+"))
ElseIf ChkSign = -1 Then
Row.myConvert = MyNewRow.PadLeft(2, CChar("-"))
Else
Row.myConvert = MyNewRow.PadLeft(2, CChar("+"))
End If
End Sub
Obviously i don't think this is the best approach hence i'm asking? not to mention the sort of problem i'm getting with the + and - insertion part of the code.
To give you an example of how the value would be:
Actual value: 159.23
After transformation it should be like this : +00000000000015923
Depending on the amount x no zeros should be inserted.
Any other way to achieve it? Apart from this I also need to generate a sequence no with some string at the end of the ragged file. How would i go for it ?
Cheers
I'm trying to generate a DTS Package with VB.Net using the Microsoft DTSPackage Object Library and
and the Microsoft DTSDataPump Scripting Object Library
I have to load csv files into SQL tables.
I could generate both a SQL connection and a FlatFile connection and the transformationtask.
When I look at the transformationtask and click on the transformation tab I get this error
"Incomple file format information"
The problem is I don't find where I could set the FlatFile connection properties like "Text Qualifier" and
"row delimiter"
I tried this but it still shows CRLF as row delimiter when I look at the generated DTS Package
Dim oConnection As DTS.Connection2
Dim package As DTS.Package2
Dim filename As String
filename = "myfilename.csv"
oConnection = package.Connections.New("DTSFlatFile")
oConnection.Name = filename
oConnection.ConnectionProperties.Item("Row Delimiter").Value = vbTab
Hi, I'm a first time user at reporting services and in dire need of some help, I'm having a real hard time finding the information I need.
I have made two reports in Business Intelligence Development Studio that access a sql database and I can deploy them and see them at http://localhost/reports etc.
What I wan't to do is be able to "trigger" the reports to be built from a schedule (e.g. every 8 hour on weekdays, every 12 hours on weekends but should be able to be changed) and after built to be saved to a html file.
I also need to set the sql query for the dataset before generating the report (select * from table where DateTimeType between This and That).
Anyway, I'm completely lost on how to achive this and would greatly appreciate and tips or pointers to where the information can be found.
Kindest Regards
Hi All,
I need to know how to create a AScii 7 bit flat file using Integration services. I do have basic charecters in the flat files - only other charecters required are a pipe (|), which is used as delimeter and additionally it will have line feed (LF) which is used as row delimeter.
Please let me know if this is possible.
-vinu
Hi All,
I am using MS SQL 2005 and using Integration Services I have created FTP task to create a txt file with the required information on to a FTP location. But I need the encoding of the file to be set to AScii 7 bit mode rather than unicode or Ansi-Latin I - which are 16 bit. I tried creating the file first in unicode first & then converting it Ascii, but this made me to loose some data from the generated file. Looks like this doesnt work out and my attempts generating AScii 7 bit flat file is failing. I need solution to URGENTLY otherwise I will have think of some alternative other than Integration services. Egarly waiting for any responses!!
-vinu
Hi: I have SQL Server 2005 Express edition and I am trying to generate a script that someone can take and import into the full version of SQL Server. Using the Generate Scripts Option, I have been able to generate scripts for the various SQL statements that I created - but cannot get it so that the data is included. I'm new to this and would appreciate any help. I have a populated database that I would also like to transfer to the new server.Any help greatly appreciated.Roger Swetnam
View 2 Replies View RelatedI've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as:
select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table
There's also a CASE statement in there with some other data transformations.
Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Server Compact Edition database - within an application that I'm creating in Visual Studio 2005.
For whatever reason, I can't seem to do anything like that in 'bulk' and there aren't any data migration tools that work with anything other than "full" SQL Server versions. My client doesn't support SQL Server, but I can deploy my app with SQL CE. I need a 'local' copy of the database (for several reasons) and just can't seem to figure out how to make this work.
I'm really going nuts. I feel like I'm soooo close when I see the data I want in the table adapter - but I can't seem to actually *move* the data over!!
Can anyone help?
thanks,
Jon
we have data base in ms access and reports in crystal reports 5 recently we converted our data base to sql sever 7
and reports to crystal reports 8. when i opend directly in cystal reports and given data base connecting through oledb
i am getting reports but from the application it is in vb6 the report window is poping up and latter a error msg saying un able to open sql server
when i checked up the connection it is ok help me
anil
I am trying to generate a hex value automatically at time of insert. The column used for the hex # is an identity column. I am getting an error that the trigger fails because the field doesn't accept nulls. My guess is that the identity column is not populated yet.
Below is the table and trigger.
CREATE TABLE [dbo].[scancode](
[scancode_id] [int] IDENTITY(1,1) NOT NULL,
[scancode] [varchar](50) NOT NULL,
[parent_object] [varchar](150) NOT NULL,
[parent_object_id] [int] NOT NULL,
[Created] [datetime] NOT NULL,
[code].....
we can generate drop-down list on the tables by writing sql query at "Access". I was wondering whether or not the same thing can be done for SQL Server?
View 4 Replies View RelatedHi,
I use SQL Server 2005 Dev Edition and am not new to making databases (then again, I've had enough experience and my dad does the same thing).
I am (unfortunately) a university student and for my dissertation I am going to produce a SQL Server database with a strong emphasis on data mining.
Obviously, for the data mining to be useful at all I need to produce loads and loads of test data.
Fair enough, and there are applications which do this, such as EMS Data Gen, but can anyone recommend me any other data gen utilities? EMS Data Gen has poor handling of unique attributes, and as I am doing a car manufacturer this will give me problems when I come to the registration number attribute.
Also, why are utilities for SQL Server (and Oracle at that) so expensive? This makes it out of my reach and makes it difficult to build a truly good database that will net me good marks, and demotivates me. :(
Lastly, please feel free to recommend to me any utilities for SQL Server - such as performance monitors, backup utilities. Anything. But if they are priced utilities, they have to be sensibly priced (<£100), because I cannot yet afford to pay >£1k on such utiltiies.
Thanks
Generating different types of letter (PDF formats) from SQL server?
View 3 Replies View Relatedhow can persist schema for a sql server table into an xml file from .net application?
thanks
I have recently returned to developing a website using Visual Web Developer Express 2008. I want to store information in a database. I have SQL Server 2005 Express edition installed on my pc.
When I try to Add New Item -> SQL Database from VWD2008 by right clicking in the App-Data folder and completing the dialogue I get the following error message:
Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled' to generate user instances.
I have SQL Server Management Studio installed but do not seem to be able to resolve this issue.
My operating system is windows XP Home SP2.
Some guidance on solving this would be appreciated.
Many thanks
Roger L
I am trying to generate dates for a roster dynamically in a stored procedure. If my start date is '01/01/2015', end date is '12/31/2015', I should generate dates from '01/01/2015' adding 7 days.
The output comes like this:
01/01/2015
01/08/2015
01/15/2015
.
.
.
until end date
I do it through loop but just posting it here to know, if there is any other efficient way using CTEs or some sort of queries which can avoid loop in SP.
Use sp_configure 'user instances enabled' to generate user instances.
I get the above error when I attempt to add an SQL Database item into my VS (C#) project. I do not understand what needs to be done to correct the problem.
Any help is appreciated.
Thank You,
Klaus
Hello
We are using SQL 2005 and now we are planning to use SQL 2000. what are the ways to do the process.
We taken the script spcificall for 2000 and run it in SQL 200. But we are getting the error in SCRIPT?
Could you please give me the step to do?
Thanks,
Sankar R
Hi
How Can I Generating wrapper code for SQL Server Stored Procedure ??
If You will Go To The Following link you will see an example for Generating wrapper code for Oracle Database .. And Also the author say there is built in tool for Generating wrapper code for SQL Server
http://www.codeproject.com/vb/net/OracleSPWrapper.asp
my question .. where is this tools ???
and thanks with my regarding
Fraas
I have created a link server in SQL Server 2005 to connect to Oracle 7.3. The driver in link server is MS-OLEDB. I have created a dynamic procedure in SQL Server 2005 using OpenQuery method to connect to Oracle. When I execute this procedure in SQL this gives me the results I want from Orcale.
In SSRS 2005, I am calling this procedure with the schema name.When I do Refresh,this should automatically list me the Parameters I am using in procedure. It is NOT listing me the AUTOMATIC generation of parameters.
Please help..
Deepak
Hi Dear,
May Any one guide me?
I have a backup file of database which is in SQL Server 2000. it has no Extension.I want to restore this backupfile or this database in my SQL Server 2005.
I have tried to Attach Database or attach this backup file in Sql Server2005 but it also fails .
First I have created New database name as is on the backupfile and then I have also tried to rename this file with .bak extension and then try to restore again it fails.
Plese Guide me urgently........
:eek: :eek: :eek: :eek: :eek:
hello,
I have a question about opening files in the Microsoft SQL Server 2005 Management Studio.
In the old Query Analyzer from SQL 2000 I can open SQL Files via drag & drop (from explorer to QA) or open it with a double click in the explorer. Then the Files opened, if I had actual a connection to a server / database (QA is stared with one file and has a connection to Server/Datebase), with this connection.
Now in Microsoft SQL Server 2005 Management Studio I'll be asked everytime for Server and have to get the database from the database list - it does not connect automaticly to server/database, that is actual connected (I have opened a file with the connection and a connected database in the object explorer).
Someone do not have this problem - but we found no option to set it up.
Any ideas?
thanks &
best regards,
Christian Kiedels
Hi
I was wondering if it was possible to call reporting server web service directly from my sql server stored procedure. The call that I need to make to reporting web service needs to generate the report in a PDF format.
I have been given a .bup file which I am told contains a database I need to access. How do I open this .bup file. Please help !
View 1 Replies View RelatedHello There,
I would really appreciate if you can help me with this problem. I am currently using SQL Server 2005 Express for one of my web application. I have a .bak file (backup file) provided by my client which I want to use for testing purpose. Now I just want to know how can I use that backup file without installing SQL SERVER 2005 as one way to do this I know is to restore the database in SQL Server 2005 Enterprise Manager but I can't install SQL Server 2005.
To my knowledge, SQL Server Express uses .mdf file for database but what I have is .BAK file..
I would be really glad to see your quick answers.
Thank you for reading this far.
Sincerely,
Zulfiqar
helloi am working on a mdf file on sql server express 2005 and i would like to migrate the content to sql server 2005.How can i do it ?
View 3 Replies View RelatedHi
I am very inexperienced with the Administration side of SQL Server 2005.
I have been given a .bak file which I need to restore onto my SQL Server. The database .bak file was created on another PC and I cannot seem to restore/recover the .bak file onto my SQL Server.
Can anybody help me with this?
Thanks!!