Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 NTILE

Author  Topic 

poser
Posting Yak Master

124 Posts

Posted - 2010-04-22 : 15:11:20
When I try to use the NTILE function in the View Designer I get the message that Sql server has encountered a problem and has to be closed.
I can run the query in the query window and is okay, but in designer it fails?
Does anyone know why this would happen?
Thanks in advance..
P

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-22 : 15:34:05
It sounds like a bug in the designer. You should try installing the latest build of SQL Server so that your tools get updated in case Microsoft has a fix for this already. The latest is sp3+CU9.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

poser
Posting Yak Master

124 Posts

Posted - 2010-04-22 : 16:56:18
Okay, We are already at SP3 but I will see if the will let me apply the CU9
Thanks,
P
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-22 : 17:07:26
Just to be clear, I am not saying to apply it to the database server. I am saying to apply it to the client machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -