I am looking at some SQL in a stored proc and I noticed that they
use a command called "contains". Can someone tell me more about this
command. I can't find anything on it in the SQl books I own?
SELECT distinct
dmz.fileName,
dmz.title,
dmz.description,
dmz.fileType,
createdBy,
createDate
FROM Documents dmz
WHERE d.pId like @PID
AND (contains(dmz.title, @SearchWords)
or contains(dmz.description, @SearchWords)
or contains(dmz.filename, @SearchWords)
or contains(dmz.createdBy, @SearchWords)
)
my local instance of reporting services is named and therefore I think causing me a problem when I issue the following command to set up an unattended account...
rsconfig -s localhostinstance name -e -u domain nameuser name -p password
the message I keep getting is "No Reporting Services instance found on local host.". I tried a couple of things including replacement of the word localhost with my computer name but to no avail. I tried single and double quotes around the -s parameter but no success.
i am using visual web developer 2005 and SQL 2005 with VB as the code behindi am using INSERT command like this Dim test As New SqlDataSource() test.ConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnectionString1").ToString() test.InsertCommandType = SqlDataSourceCommandType.Text test.InsertCommand = "INSERT INTO try (roll,name, age, email) VALUES (@roll,@name, @age, @email) " test.InsertParameters.Add("roll", TextBox1.Text) test.InsertParameters.Add("name", TextBox2.Text) test.InsertParameters.Add("age", TextBox3.Text) test.InsertParameters.Add("email", TextBox4.Text) test.Insert() i am using UPDATE command like this Dim test As New SqlDataSource() test.ConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnectionString").ToString() test.UpdateCommandType = SqlDataSourceCommandType.Text test.UpdateCommand = "UPDATE try SET name = '" + myname + "' , age = '" + myage + "' , email = '" + myemail + "' WHERE roll 123 " test.Update()but i have to use the SELECT command like this which is completely different from INSERT and UPDATE commands Dim tblData As New Data.DataTable() Dim conn As New Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True") Dim Command As New Data.SqlClient.SqlCommand("SELECT * FROM try WHERE age = '100' ", conn) Dim da As New Data.SqlClient.SqlDataAdapter(Command) da.Fill(tblData) conn.Close() TextBox4.Text = tblData.Rows(1).Item("name").ToString() TextBox5.Text = tblData.Rows(1).Item("age").ToString() TextBox6.Text = tblData.Rows(1).Item("email").ToString() for INSERT and UPDATE commands defining the command,commandtype and connectionstring is samebut for the SELECT command it is completely different. why ?can i define the command,commandtype and connectionstring for SELECT command similar to INSERT and UPDATE ?if its possible how to do ?please help me
i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables,
enterName - String packageLevel (will store the name I enter)
myVar - String packageLevel. (to store the query)
I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName = " + @[User::enterName] + " )"
Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error.
Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E0C. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object.".
Can Someone guide me whr am going wrong?
myVar variable, i have set the ExecuteAsExpression Property to true too.
Hi. I am writing a program in C# to migrate data from a Foxpro database to an SQL Server 2005 Express database. The package is being created programmatically. I am creating a separate data flow for each Foxpro table. It seems to be doing it ok but I am getting the following error message at the package validation stage:
Description: An OLE DB Error has occured. Error code: 0x80040E0C.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object".
.........
Description: "component "OLE DB Destination" (22)" failed validation and returned validation status "VS_ISBROKEN".
This is the first time I am writing such code and I there must be something I am not doing correct but can't seem to figure it out. Any help will be highly appreciated. My code is as below:
private bool BuildPackage()
{
// Create the package object
oPackage = new Package();
// Create connections for the Foxpro and SQL Server data
MessageBox.Show("The DTS package was not built successfully because of the following error(s):" + sErrorMessage, "Package Builder", MessageBoxButtons.OK, MessageBoxIcon.Information);
I am trying to run a sql script that was written by a third party to set up the tables and stored procedures of a 6.5 database. The script crashes about half way through. The error looks like this...
The vendor said that I needed to change the client configuration to tcp/ip sockets instead of the named pipes that I was using. When I change this setting I can no longer connect to the server through enterprise manager. The error message is...
I am not sure if the db-library is not set up correctly for the server or why it will not connect through the tcp/ip socket. I ran the ping command from the command line and it returns a valid connection to the server. This doesn't make a lot of sense to me.
Does anyone have any experience with this problem or suggestions of something to try to fix this problem. Any ideas would be great. Thanks.
This is the message when I try to connect to the server using tcp/ip sockets...
A connection could not be established to SERVERNAME - [DB-Library]Unable to connect SQL Server is unavailable or does not exist. General network error.
I am running SQL2k SP3 with a default instance. I have recently added a second, named instance. When I try to connect to the named instance through Enterprise manager, it often times out. I never get a timeout accessing the default instance. Is there something I missed when setting up the second instance that is causing this access delay?
Can anyone please tell me why i have one SQL 2000 server that is only accepting Named Pipes connections from clients? In the Server Network Configuration Utility both protocols are enabled, although Named Pipes in first and i cannot change the ordering.
All - I have 2 SQL2K clusters, both have local applications and replication. The first cluster uses TCP/IP for all its connections when looking at SQL Management processes. The second is still using named pipes for all connections. How do I set or configure the second cluster to use TCP/IP on local connections and replication? Thanks.
We have a vendor product that can only handle up to 18 characters for the server name and the instance name (we did not know this when we created the named instance) and of course our combined name is 19 characters, so it trys to pass the 18 charater name and then fails with the following error:
[LOG] Unable to read local eventlog (reason: The data area passed to a system call is too small)
So, can i rename the instance, or do i have to create a new named instance?
I have a "Date" dimension with several attributes in it such as "Accound Period", "Calendar Year", "Completed Year"etc. I want to create a "named set" for some dataset to filter out the "Calendar Year" which has the value "Less than or equal to" the value of the attribute "Completed Year".
The structure for the "Date" dimension is as follows:
Calendar Year (attribute)
Members Calendar Year------member Properties
Completed Year (attribure)
Members Completed Year------member Properties
It has only a single value for the "Completed Year" and it was calculated in the data source view using "getdate() -2" ie. 2005 for the entire attribute. How to create a named set to filter out the Calendar Year with this? Thanks.
I'm working on an insert into a database and I barrowed this code stright from Microsoft, changing the info I need. I keep getting an error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" This is the same connection string that I use for querying the database without a problem. Anyone have any ideas? Jeff SqlConnection con = new SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=software.mdf;Integrated Security=True;User Instance=True;");SqlCommand cmd = new SqlCommand("INSERT INTO download_table (username, computer_name, computer type, install type, date, email, agree, title) VALUES (@username, @computer_name, @comptype, @installtype, @date, @email, @agree, @title)", con);cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar, 50));cmd.Parameters["@username"].Value = username;cmd.Parameters.Add(new SqlParameter("@computer_name", SqlDbType.VarChar, 50));cmd.Parameters["@computer_name"].Value = computer_name;cmd.Parameters.Add(new SqlParameter("@comptype", SqlDbType.VarChar, 50));cmd.Parameters["@comptype"].Value = comptype;cmd.Parameters.Add(new SqlParameter("@installtype", SqlDbType.VarChar, 50));cmd.Parameters["@installtype"].Value = installtype;cmd.Parameters.Add(new SqlParameter("@date", SqlDbType.DateTime, 50));cmd.Parameters["@date"].Value = date;cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.VarChar, 50));cmd.Parameters["@email"].Value = email;cmd.Parameters.Add(new SqlParameter("@agree", SqlDbType.VarChar, 50));cmd.Parameters["@agree"].Value = agree;cmd.Parameters.Add(new SqlParameter("@title", SqlDbType.VarChar, 50));cmd.Parameters["@title"].Value = title;cmd.Connection.Open(); <--- This is where I get the above errortry{cmd.ExecuteNonQuery();}catch (SqlException ex){}cmd.Connection.Close();
Can anybody help? I have recently got any error - Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection Broken /
Does anybody know how to resolve or point me in the right direction.....?
I had a huge problem with my SQL database and I had it restored by using my back up tapes from the days before. I tried to back it up although it allowed me to restore it...it now says that the database is "suspect"= not found,,lost?... How can I get rid of this suspect & open my database,,, Does this mean that my database cannot be restored from a prior day (using my backup tapes from past days through the server?)
Can someone please help me concerning "suspect database names in SQL Serbver 7.0?
Any ideas ...please help me ...more detail?
Thanks in advance, Brad Isaacs Junior VB Developer / SQL Server 7.0 databases
I have a table *named* "dbo.tSales", in addition to being owned by dbo. The fully qualified name would look like "databasename.dbo.dbo.tSales".
In other words, the name starts with "dbo." and shows up in the output when you do:
select name from sysobjects where name like '%Sales' and type = 'u' name ------------------------------ dbo.tSales tSales
"tSales" is a real table, also owned by dbo. I don't know how the bogus table got there. The only reason that I've noticed this is because Backup Exec tries to backup this table by explicitly naming it in a DUMP TABLE statement and the statement fails on syntax because the fully qualified name has too many periods in it.
I can't select from dbo.tSales, rename it or drop it using TSQL or SEM. All methods fail because they are expecting that the tablename cannot contain any periods, since the period is a delimiter.
I have rows in sysindexes where the name starts with '_WA_Sys_' followed by a column name from my application tables. What is causing the creation of these sysindexes rows?
I'm trying to create calculated columns in a SELECT query (inside a sp) that are based on other calculated columns in the same SELECT list. But since I'm not allowed to refer to each calculated column by name, I'm forced to repeat long calculations every time I build one calculation based on another.
I'd like to do something on the order of: SELECT Price*Quantity AS SalePrice, SalePrice*1.08 AS SalesPriceWithTax FROM Orders
Access used to let me do that, but not SQL. Any suggestions? Can I use variables declared and assigned before I start my SELECT, and then put those variables in my SELECT list? Anyone have a useful shortcut?
Informatica jobs were erroring out with a sql server driver error while connecting to a named instance in SQL Server. The issue was because in sql server named instance, the port was allocated dynamically and Informatica 7.1.4 (provides 4.21 version of Datadirect odbc drivers for SQL server) which dont have support for named instances with dynamic port allocation. This feature is only present from version 5 of the Datadirect odbc drivers for SQL server To fix this issue, I need to allocate the port for the named instance instead of getting it dynamically. My questions 1) Whats the impact of doing a port allocation for the named instance on the existing environment. 2) Is there any issues which we can foresee in the applications 3) Things which i need to be aware of Thanks in advance sreenath
I have a SQLSERVER INSTANCE A, to which I want to connect from a Client as TEST, using the SQL Server alias functionality under the client network utility program. The alias is working fine with the TCPIP connection but it fails when I try to connect to the SQL Server using the named pipes. In my case I'm trying to connect to a named instance of SQL Server 2000 using the following pipe: \servernamepipemssql$instancenamesqlquery
Hi, all. To use Named instance on the same machine, Do I need to check any license issue? My Company has one server license and wants to use Named instance. thank you..
I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that there are additional 4 more instances on the Server ..... is is possible to get the port on which they are listening using the QA ....
I knw that we can go to the servers network utility & see it there in the TCP /IP ... but i dont have access to that , neither do i have access to the error logs that tell me , on which port is SQL Server listening to
