Friday, March 30, 2012
ID Field Reset
When the users started using the system they noticed that the record ID numbers had reset and were starting from 1 and going up 2, 3, 4 etc. The last good id number was about 20500. The id columns are set as primary key with identity and increment of 1.
This shouldn't happen should it? Is it a bug? I never touched the ID column, just added the new one.I bet you made the change using Enterprise Mangler. EM tends to make these changes not with a simple alter table add column, but with a drop and re-create of the table. You can try running DBCC CHECKIDENT(table) on the table, which should reset the identity column nicely.|||That's interesting. I am going to test that on my test system now to see what happens.
Thanks!
Monday, March 12, 2012
I think i killed Analysis Services (05), need a reset button
I'm a cube rookie and have been deploying funky cubes while i'm cutting my teeth on AS. Unfortunately, AS has completely stopped responding, connecting to it in SQL Server Management studio or BI Studio just results in a hang. The service will stop and start without error in the Event log, but i can't interact with it any more. Restarting the PC doesn't help...
I tried to uninstall it, but setup is forcing me to uninstal SQL server with it, which isn't a good idea for me at this point. Is there any way to 'reset' AS?
Thanks!
Edited To Add:
Well, i've blown away any file i could find under this directory that appeared to have anything to do with my cube and i can now connect to AS...wish me luck!
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP
Apparently in spur of the moment you killed too much :)
The files you needed to delete were under C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data
Now you probably have no choice but uninstall and re-install the product again.
Run Remove for SQL Server, later in the uninstall wizard you should be able choose to remove Analysis Services only.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Fortunately I just left the detail out of my post, and only deleted the files under Data. So far things have been working well. I'm still learning a lot about how to put this stuff together, but the difference in performance between this and Access Pivot tables makes it all worth while.
Thanks!
Friday, March 9, 2012
I need URGENT help about **Lost DTS password**
I forget my dts password for an dts on Sql 2000 SP3 .How can i reset or find my password for edit my DTS .I have db admin and sys admin user rights on this database.
thanks for your help.
?zgür ?etiner
ozgurcetiner@.hotmail.com
http://msdn.microsoft.com/subscriptions/managednewsgroups/list.aspx|||There is no way around this. To have a workaround for this would be a security issue. Sorry.
I need URGENT help about **Lost DTS password**
I forget my dts password for an dts on Sql 2000 SP3 .How can i reset or find my password for edit my DTS .I have db admin and sys admin user rights on this database.
thanks for your help.
?zgür ?etiner
ozgurcetiner@.hotmail.com
Thanks
Laurentiu