error using default value property in table column properties (mssqlserver sme)(mssql2005 express)

SQL Server Tools General

Index ‹ SQL Server

- Previous
  - 1
    - Drillthrough results conditioning Thanks for the suggestion Deepak. I've tested your solution and it works pretty well. Yet, if I want to drillthrough on several measures, and if my needs require to have different filter conditions, I have to create several measure groups which increase seriously the size of my cube (since I got to create named queries corresponding to each group). I was hoping to be able to design some MDX queries allowing me to solve my problem without increasing the volume of my datas, but I guess if it can't be done, I will just have to check thoroughly my users needs. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 2
    - Restarted SQL Server 2005, and it's working great now, but WHY?? Thanks for the insights. Forgive me for requesting such a general answer to my question without even giving out any specifics (i.e. hardware processors, OS versions, etc.). I was just curious to know other people's experiences and opinions, especially why it works so well upon restart. I'm sure my server will need to be tweaked some more. I'll be spending the rest of the day reading those articles. Thanks! Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 3
    - Unpivot Transformation and Expressions I think that's a reasonable approach, thanks. BTW, I was actually doing the unpivot in my SQL using a UNION ALL after I created a temp table. But I get an error when I paste my SQL into the SSIS OLE DB Source when it has a temp table: Error at Release Hours [OLE DB Source [3100]]: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "Invalid object name '#timesheet'.". Why aren't temp tables allowed for this Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 4
    - Oracle odbc driver on windows 2003 64 bit, SQL Server 2005 Unfortunetly not :( I have posted this issue on several forums including Oracles site. We are going to leave that database which demand linked servers to Oracle on the 32 bit server. I am going to install SQL Server 2005 on that server later. But I am still hoping for some solution to this delicate problem. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 5
    - Partitioned View Pruning Issue It is a bug in SQL Server 2000 due to auto-parameterization. It has been fixed in SQL Server 2005 so your examples will work fine there. You can make it work in SQL Server 2000 by adding some bogus parameter to the WHERE clause of the UPDATE & DELETE statement. declare @p int SET STATISTICS IO ON UPDATE Call SET [callStartedOn] = '2004-01-01 00:00:00.000' WHERE [id] = '20040104-fake-asdf' and @p is null go declare @p int SET STATISTICS IO ON DELETE FROM Call WHERE [id] = '20040104-fake-asdf' and @p is null go To summarize, the partition pruning will not happen in cases where auto-parameterization of the statement occurs. This typically happens in cases where you use constants/literals in WHERE clause. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 6
    - Backup on remote disk actually, you do not need to add a dump device, simply execute: Code Snippet backup database MyDB to disk = '\\Server\Share\BackupFilename.BAK' Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 7
    - Insert failure while using ForEach Loop + Execute SQL task. One more thing. Set the Result Set to "Full Result Set" if you are expecting multiple rows from the select statement. I am guessing this is why you are using a ForEach loop Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 8
    - statment completion in vidual studio 2005 so why microsoft add this feature if it dons't work and if it work in vs2008 Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 9
    - How to count no of items in nested table I need to do on nested query and I tried to search for CTE but I couldn't get the job done, It's always return the incorrect results WITH RegionRestaurantCount (RegionID, RegionName,ParentID, NumberOfRestaurants) AS ( SELECT RegionID, RegionName, ParentID, (SELECT COUNT(*) FROM Region node WHERE node.RegionID = parent.RegionID) as NumberOfRestaurants FROM Region parent ) SELECT rc.RegionName, rc.NumberOfRestaurants FROM Restaurant res INNER JOIN RegionRestaurantCount rc ON res.RegionID = rc.RegionID ORDER BY RegionName Could you please help Thank you Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 10
    - sp_sidmap alternative in sql 2005 Thanks a lot for the reply. That's the info I was looking for.. Dan Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 11
    - copying and pasting cubes Hello, I was copying and pasting cubes (sql 2000) today--- Like I have done several times before.. And I got this error: Unable to set new aggregation prefix for at least one partition. Please change these manually to avoid conflicting aggregation tables. What does it mean How can i fix it Thank you, Liat Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 12
    - Group Total Summary Help Hi Jarret, Thanks for your response. The rows 1, 2, 3, & 4 are actually summary rows of the details. All details are hidden. This is where my problem lies. The details are in the dataset but in the report I have them rolled up. To obtain each summary I have a formula that needs to know the summary for each group to determine the outcome. For example: Group Summary 1 > 0 Use Formula A Group Summary 1 <= 0 User Formula B I can get the correct summary at this level, but I then need to total all of the summary records and obtain a second group total. Finally I need to sum all secondary group totals to obtain a grand total. Thanks, Simone Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 13
    - Can't run the scheduled SQL Agent Job? Hi, What is local login we only setup use the windows authenication mode for the sql server Thanks! Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 14
    - urgent server installing problems thanks but there si a problem im using windows xp professional 2005, , and using sql server standard edition, but the problem is there , so is there any other solution, as i know this sqlserver side does work on xp, i did it before but at that time i didnt setup the whole thing, .........this is the case now any one wid a solution,, help me out here ppl, ur all are good at this... so help me set up the thing,, help... urgent,,, Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 15
    - Commit Error I thought of that and I ran a script to enter those offending values - and there were no errors. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 16
    - Snapshots - not having to create them Thanks for your answer-To do as you have sugested do i script the subscription then change thr alt_Snapshot property to get the snapshot from the subscribers location - or can i do it from the wizard Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
- Next
  - 1
    - Passing value from a child Package to the Parent package that calls it in ssis i believe it show how to pass from the parent to the child.. I am aware of that.. I was looking from child to parent... Thanks Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 2
    - Using SQL Server Destination adapter with SQL 2000 database It’s always said that using the SQL Server Destination adapter is much faster when loading data to a SQL Server database. My question is, if I have a SQL 2000 database, can I still use the SQL Server Destination adapter, or is it only for SQL 2005 db Is OLE DB Destination adapter my best bet My data files(flat files), SSIS package and destination SQL 2000 db are all in the same physical server. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 3
    - using trigger to insert data to different server database Both transactional and merge replication can do the job. Here is a thread may help: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2186767&SiteID=1&mode=1 Thanks, Zuomin Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 4
    - Error 26 on a local machine You said everything is fine except one application which you don't originally own. Can you post the connection string used by the application Are you able to connect to the same server using SQL Management Studio Are you app using .Net, SNAC(sqlncli), or MDAC Thanks. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 5
    - Period over Period Deepak, I've already read that blog, and it doesn't quite do it for me. I need a more straightforward example of how this can be done. I'm really looking for a short/concise example of how to do this "generic" period over period calculation. Thanks, dcb99 Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 6
    - Virtual Address Space very large When I run dbcc memorystatus on my SQL 2005 Server under Memory Manager I get: VM Reserved 33610144 VM Committed 1478012 Doesn't the VM Reserved seem really high Is there a way to force SQL to release the VM Reserved memory Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 7
    - Parent Package Variables and SQL Package Store yeah, that makes sense... I've been thinking about doing that for about a day now myself, although I was just wanting to get this to work first before going through with it. I think I will go ahead and change things over to build up the string dynamically, that way I won't have to retype everything in the set values tab every time I want to tinker with which database or server it is going to. Right now I am building a test package that is passing the connection string and it works fine, however the test package is passing it to a pacakge on the file server (not in the sql package store). There shouldn't be any difference in how a package accepts parent variables between a file server executed package and a sql store executed package should there Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 8
    - Select Stament Help Jorge: I would suggest something more like: select a.tsAlarmTime, d.tsTimeStamp, a.alarm, d.rDiameter from alarm a inner join diam d on d.tsTimestamp between dateadd (ss, -15, a.tsAlarmTime) and dateadd (ss, 15, a.tsAlarmTime) In addition, this looks like a query in which performance is important so I would suggest that you also add or verify that you have an index on the DIAM table that is based on (1) tsTimeStamp and (2) rDiameter. If in fact performance is important for this query I do not suggest using the DATEDIFF method because this method will NOT allow you to employ an index for your join criteria. ALSO! The placement of the DATEADD in my query is critical. By placing the DATEADD function on the ALARM table it allows the index lookup to take place on the DIAM table -- which should be a better choice. Dave Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 9
    - Update data on SQL2005 linked servers to DB2 Hi Jivko, Thanks for promptly reply. I checked the Provider documentation, you are right. It does not support commit and rollback transaction. Thank you so much. Regards Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 10
    - SQL Server 2005 Cluster Thanks it's so useful Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 11
    - Time dimension design Johan, thanks for your prompt reply. I have not well understood your approach. You said: Make a date dimension for every country, link it based upon date_SK and country_SK. So one country_SK in every date dimension to identify which country the date dimension refers to. Could you explain it more How do i link it to the fact tables Thanks Christina Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 12
    - Error: Method, property or field is not static Thanks, that was very close to getting the thing to work. I neglected to mention that there are a number of other subs & functions in the class and when I declared them all 'Shared' it finally deployed. I'll start debugging now. Thanks very much. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 13
    - Error After Package Configuration Details for Connection Manager XYZ Provider: Native OLE DB\Microsoft OLE DB Provider for Oracle Server Name : Ora_serv UserName: User1 Pawwword: Password Execution Result : [DTS.Pipeline] Information: Validation phase is beginning. Progress: Validating - 0 percent complete Progress: Validating - 50 percent complete [OLE DB Source "PQR" [1]] Error: The AcquireConnection method call to the connection manager "XYZ" failed with error code 0xC0202009. [DTS.Pipeline] Error: component "OLE DB Source PQR" (1) failed validation and returned error code 0xC020801C. Progress: Validating - 100 percent complete [DTS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. Validation is completed [Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Validation is completed Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 14
    - Changing Data Source of Existing Cube Looks like RS-related question. Moving to reporting services forum. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 15
    - Need help with an SQL query Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
  - 16
    - Using SMO to manage indexes (online rebuild question) Allen White wrote: The Index object has a boolean property called OnlineIndexOperation() which you can set to True, which should allow you to rebuild the index online. I see this, but there are no appropriate methods after it ... Index.OnlineIndexOperation: CompareTo Equals GetHashCode GetType GetTypeCode ToString How do I tell it to do an Index Rebuild Online Thanks Tag: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)

moralesramon

I'm trying to set the NOW() function as default value property of a table field (datetime type) but I'm getting the folowing errors:

error validating the default for column 'optime'

'NOW' is not a recognized built-in function name

i used now, now(),NOW,NOW() as default value property

sorry 'my bad english'

Re: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)

Madhu K Nair

Now() is not a SQL Function... use Getdate() function

Madhu

Re: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)

Satya SKJ

Ture, you have NOW() function in MS Access & VB and not in SQL server.

http://msdn.microsoft.com/library/default.asp url=/library/en-us/script56/html/74f3ca98-792a-43e6-9d7e-c9a2bab0be7b.asp

If you are using the VB script then ensure you are referring the object correclty.

Re: error using default value property in table column properties (mssqlserver sme)(mssql2005 express)

moralesramon

thank you