sp_refreshview command is used when you made any changes to the tables.
had tried that solution to all client workstations before but to no avail..is there other ways? Thanks.
Hi all, I had a few reports using sql reporting services 2000 and render to PDF format using weblink. Example:...
If the SQL Server 2005 Express is installed with Windows Authentication, I don't think there is SA password. Databases will directly authenicate...
this queries work: SELECT SUM(CAST((REPLACE(Column_Name, '"', '')) AS INT)) AS Column_Name FROM tbl SELECT AVG(CAST((REPLACE(Column_Name, '"', ''))...
I thought I went to the wrong forum....this is an impressive and fresh website!
that's quite true... =)
Some reference books help too. http://technet.microsoft.com/en-us/sqlserver/bb331756.aspx
I don't think you can use import/export utility from sql server to import the information to the table unless the information is like:...
I tried the query. If table2 does not existed, running select * from table1 where id in (select id from table2) will definitely give error Invalid...
maybe these sites help: http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx http://technet.microsoft.com/en-us/library/ms177411.aspx
[<img src='/community/emoticons/emotion-2.gif' alt=':D' />] that's a good one
CREATE DATABASE [dbname] ON (NAME = 'dbname_Data', FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQLdatadbname.MDF', SIZE = 21, FILEGROWTH = 10%)...
Hi all, Recently I am required to create a scheduler to send out maintenance email every 1st day of the week. All records are in SQL server. Thus,...
i got it.....thank you everyone for your help..
Hi all, Need help urgently as I could not simply think of any solution till now. I have two tables (one is main table and the other is details...
3 more days to go before christmas. Hereby to wish everyone "Merry Christmas" [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
do you mean that currently you are using ftp and point to ip address of the remote server and now you would like to use ftp and point to the dns of...
quote:Originally posted by emamuthu rrors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_v_dim_CoverageGeography,...
some other sites for samples: http://builder.com.com/5100-6388_14-6140404.html...
Separate names with a comma.
