-
- SQL Server service pack question
by Ashok Ojha
- 2 Replies
- Last post
by Ashok Ojha
- I have installed SQL Server 2005 (32 bits Dev. Ed.) in Windows 2003 (64bits OS) Server.
Which Service pack I should install. I am little lost that 64 in file name is for OS or SQL Server.
SQLServer2005SP2-KB921896-IA64-ENU.exe
SQLServer2005SP2-KB921896-x64-ENU.exe
SQLServer2005SP2-KB921896-x86-ENU.exe
Thank you - Ashok
-
- parallelperiod
by lvb
- 3 Replies
- Last post
by Deepak Puri
- Hi all,
I've use this function in my KPI goal expression as shown below:
( PARALLELPERIOD ([Dim Time].[Acct_Period].[CalYr],1,[Dim Time].[Acct_Period]. CurrentMember ),[Measures].[Tran Amt])*1.1
I have a time dimensions hirearchy called [acct_period], it will start from Calyr --> CalQtr --> Period. In my KPI goal, I want to set the goal as 10% increase from the same peri
-
- Web Control for Cluster Profiler/Diagram?
by dj1smsu
- 3 Replies
- Last post
by Jamie MacLennan
- I know Microsoft has released web controls that replicate some of the functionality found in Management Studio for data mining (decision tree, cluster characteristics / descrimination). I cannot seem to find one for the Cluster Diagram or Cluster Profiler. Does anyone know if this is currently avaliable anywhere I have determined the calls these built-in viewers are using, but before trying to bui
-
- Server: the operation has been cancelled. - when processing cube
by mobigital
- 13 Replies
- Last post
by viswa
- When I highlight a few
partitions and start processing, the process occasionally stops with a
message that operation has been canceled, like this: Response 3 Server: the operation has been cancelled. Response 4
Server: the operation has been cancelled.
Response 5 Server: the operation has been cancelled. ..etc... (no further error message details are provided) SQL profiler shows that b
-
- use of variant type parameter in ExecuteNonQuery()
by Boyd564852
- 1 Replies
- Last post
by Boyd
- In the following code snippet, the stored procedure executes up to the
iRet = vciSqlCommand.ExecuteNonQuery();
command and fails with error:
System.Data.SqlClient.SqlException: Incorrect syntax near 'value'.
That would point to the
" = @data_Param where
section.
So what is the proper syntax
Code Snippet
SqlParameter data_Param = new S
-
- Transferring logins
by Starwarsbigbang
- 1 Replies
- Last post
by Arnie Rowland
- Does anybody know how to transfer logins between instances in SQL 2005. KB246133 used the two procs sp_hexadecimal and sp_help_revlogin. Since the table master..sysxlogins does not exist in SQL 2005, is there any other way to transfer logins.....I am not interested in SSIS......this throws lots of errors.
-
- complex query - need help
by Sofiz
- 7 Replies
- Last post
by mobin.p
- I have three tables-
MemberTable (primary key: memberID),
MemberDataTable (PK: DataID),
CompanyTable(PK: CompID) The MemberTable contains name,address of members along with companyID (CompID) The CompanyTable contains list of all comapny name along with CompID The memberData table contains multiple rows for each memberID in memberTable. I want to write a query which will give me the la
-
- Cannot open database during merge replication
by Mar72Vin
- 1 Replies
- Last post
by L Zhou
- Hi All, I am replicating an SQL2005 express machine to SQL2005 standard edition server using merge replication. I have a simple VB application using ADO polling msMerge_history at the subscriber every second so that i can show the end user the progress of the replication. When the subscription first subscribes and after the initial snapshot is applied replication downloads all changes from the ser
-
- getDate() throws error with MS JDBC Driver v1.2
by sqlserver_user
- 1 Replies
- Last post
by sqlserver_user
- Hi, I have a small program to query a stored procedure in SQL Server 2000 and print out the contents of a returned date field. The program is as follows: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbc qlserver://host:1433;database=db;user=u1;password=p1"; Connection con = DriverManager.getConnection(connectionUrl); CallableStatement
-
- inserting script into SQL using management studio express.
by Kokie
- 1 Replies
- Last post
by Michiel Wories - MSFT
- Hi,
First of all. First time on this forum so it could be that i posted this on the wrong forum.
I use: Vista Ultimate 64-bit
my SQL files:
SQLServer2005 SP2 SQLServer2005 SSMSEE (studio management) 64 bit
Script that I tried to insert:
http://files.filefront.com/account+dbtxt/;8885036;/fileinfo.html (srry that I do it on filefront)
When I put it in a q
-
- Connecting Visual Studio 2003 to SQL Server Express 2005 Edition
by ailin
- 1 Replies
- Last post
by Buck Woody - MSFT
- I was wondering if it is possible to connect the SQL Server 2005 Express Version to Visual Studio 2003.If its possible , how can it be done Cos i seem to have an error if i do so.
-
- Listing Size of all user Databases in SQL2005
by GW1948
- 3 Replies
- Last post
by Ryan Hanisco
- Can anyone please tell me of a way of generating a list of all user databases and their size with one command or view Thanks,
-
- Download DTS for SQL 2005 Express
by Vladox
- 14 Replies
- Last post
by Waldy
- I'm trying to export a SQL 2005 express database to SQL 2000 without success, really a pain in the ass :-( But I found that it may be a hope but I can't find the page to download the in this page mentioned additional download for SQL 2005 express that will add DTS functionality to it. http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx " DTS runtime Yes Yes (Web downlo
-
- How to set my SQL Server Express to remote?
by NeoNmaN
- 6 Replies
- Last post
by NeoNmaN
- Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it :)
this error i get when i trying to connet from my laptop to my server
TITLE: Connect to Server ------------------------------
Cannot connect to 192.168.47.128\SQLEXPRESS.
------------------------------ ADDITIONAL INFORMATION:
An error has occurred while esta
-
- suggestions
by sureshv
- 10 Replies
- Last post
by sureshv
- I want to transform textfiles to sql server set based and not row based.what would be the best way to transfer.
let me know.
-
- Upgrading 2000 to 2005, can I just move data file?
by Craig
- 2 Replies
- Last post
by Arnie Rowland
- I just installed SQL 2005 on a new box. I want to move a database from a SQL 2000 server to the new server. Can I detach the database, copy it and attach it in the new server without having problems
I'm concerned that if the datafile is in SQL2000 format, when I connect it to SQL2005 server, will it still be in old format or will it upgrade ....or is this something you don't worry about....
-
- SQL Server Compact 3.5 - I've a sdf file created in a .NET windows desktop command line program. How to now consume the data?
by Andre Moraes
- 12 Replies
- Last post
by bodhi311
- SQL Server Compact 3.5 - I've a sdf file created in a .NET windows desktop command line program. How to now consume the data in MS Excel
I can see that under
C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\
I've one DLL called
sqlceoledb35.dll
But I don't have any oledb driver listed when creating an UDL file
How can I consume the data in other apps
-
- strange lookup behavior
by mruniqueid
- 10 Replies
- Last post
by mruniqueid
- I have a data flow two lookups components (call them lookup1 and lookup2). They both query the same relational table but with different values. Each has a single row result set containing one column and the each of the two columns is mapped to a corresponding package-level variable. The original data flow sequence had lookup1 executing after lookup 2. Each component redirects errors to a separate
-
- stored procedure is rounding decimals
by Cammyr
- 2 Replies
- Last post
by Cammyr
- I have a sp that inserts payments made today from table account1
insert into dailysales ([Date],CustomerID,InvoiceID,Payment ,PaymentType)
SELECT Account1.Date, Customers.Name, Account1.CustomerID, Account1.Total , Account1.[Transaction]
FROM Account1 INNER JOIN
Customers ON Account1.CustomerID = Customers.CustomerID
WHERE (Account1.Date = DATEADD (dd, DATEDIFF (dd, 0,
-
- Navigating a hierarchy
by RobertAkiraWatts
- 16 Replies
- Last post
by RobertAkiraWatts
- I'm hoping someone can help out with this. It seems like it should be easy, yet I keep banging my head against it to no avail. In short, I've got a table of employees. There's a number of fields, but the only relevant ones are:
ID int
SupervisorID int
LastName varchar (25)
What I'm trying to get is a list, by employee, of everyone under him in the hierarchy - not just one level
-
- AUTOMATE PROCESS
by tsohtan
- 3 Replies
- Last post
by Darren Gosbell
- Hi
Currentyl after i transfer the data from another database(source) to datawarehouse. I need to click on the "process" button in order to see the latest result. Do it have a command or way to do it programmatically or using the SSIS to do it
Anyone please point me the link for me to do the automate process
Thanks in advance for anyone provide me some clue.
-
- There was an error parsing the query
by Punikin
- 1 Replies
- Last post
by João Paulo Figueira
- There was an error parsing the query. [ Token line number = 8,Token line offset = 26,Token in error = UPDATE ]
*********************** START CODE ***********************
CmdString = @"INSERT INTO tbl_document
(Batch_id, DocLastUser_id, FileDrawer_id, ParentDocument_id, DocCount, PageNumber, FileName, FileSize, FileCRC, DocIndexed, DocVerified,
DocCommitted, DocOCR, DocLastUpda
-
- Insert into table fails with msg 128
by pkflmngo
- 2 Replies
- Last post
by Louis Davidson
- Hi,
Please be gentle as I am new to this, but trying to insert a row into a table using simple sql statement
INSERT INTO dbo . Cabinet_Fields ( CabinetID , FieldID , Name , Type , Length )
VALUES ( 40 , 7 , DOB , 0 , 10 )
and I get:
Msg 128, Level 15, State 1, Line 2
The name "DOB" is not permitted in this context. Valid expressions are constants, constant
-
- Opening SSIS package without validation
by TheViewMaster
- 5 Replies
- Last post
by Jamie Thomson
- Is there a way you can open an SSIS package without validating it The reason is - when I take a package from PROD and open it in DEV - initially all settings-variables are wrong - and the validation takes heck of long time in that case. And then I need to change the variables and reload the package. And bloody hell - if I forgot to change a variable - I sometimes have to validate package 3 times.
-
- Strict Transaction Nesting Bug with CLR
by HiTech2k
- 10 Replies
- Last post
by HiTech2k
- Dear all, I am constantly running into this error when calling CLR functions from triggers (even when the triggers are CLR functions themselves): The context transaction which was active before entering user defined routine, trigger or aggregate "[name of CLR sp]" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting. However,